Difference between revisions of "ConnectR Individual Log-ins"
Jump to navigation
Jump to search
(Created page with "==ConnectR Steps== #Log into ConnectR using idxadmin. #Click Admin on the left. #Click User Profile. #In the User Name drop-down, ensure the user you want to create does not alre...") |
|||
(2 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
− | ==ConnectR Steps== | + | ==Description== |
− | #Log into ConnectR using | + | This page contains instructions on how to make individual log-ins for users for ConnectR. This is if your organization does not want to utilize shared log-ins for the application. FOR EXPERIENCED DBAs ONLY!!!!! Use at your own risk! Please contact a member of the Galen Technical Services team if you require assistance. |
+ | |||
+ | ==Instructions== | ||
+ | ===ConnectR Steps=== | ||
+ | #Log into ConnectR using credentials. | ||
#Click Admin on the left. | #Click Admin on the left. | ||
#Click User Profile. | #Click User Profile. | ||
Line 12: | Line 16: | ||
#Log out of ConnectR. | #Log out of ConnectR. | ||
− | ==SQL Steps== | + | ===SQL Steps=== |
#Log in to SQL server management studio on the ConnectR server as an administrator | #Log in to SQL server management studio on the ConnectR server as an administrator | ||
#Expand Security. | #Expand Security. | ||
Line 20: | Line 24: | ||
#Right-click Logins and select New login… | #Right-click Logins and select New login… | ||
#Enter the desired username. | #Enter the desired username. | ||
− | #Select SQL Server authentication and input the | + | #Select SQL Server authentication and input the credentials twice. |
− | #Uncheck enforce | + | #Uncheck enforce credentials policy. |
#Change the default database to ConnectR. | #Change the default database to ConnectR. | ||
#On the User Mapping page, ensure the Map box is checked for ConnectR and master. | #On the User Mapping page, ensure the Map box is checked for ConnectR and master. | ||
Line 28: | Line 32: | ||
#Under master, ensure db_owner and public are checked. | #Under master, ensure db_owner and public are checked. | ||
− | ==Test== | + | ===Test=== |
*Open ConnectR using the new user and verify access. | *Open ConnectR using the new user and verify access. | ||
+ | |||
+ | ===Keywords=== | ||
+ | User Users Login Logins Log-ins Log-in Log in Log ins ConnectR Connect R Individual Unique |
Latest revision as of 11:39, 15 June 2012
Description
This page contains instructions on how to make individual log-ins for users for ConnectR. This is if your organization does not want to utilize shared log-ins for the application. FOR EXPERIENCED DBAs ONLY!!!!! Use at your own risk! Please contact a member of the Galen Technical Services team if you require assistance.
Instructions
ConnectR Steps
- Log into ConnectR using credentials.
- Click Admin on the left.
- Click User Profile.
- In the User Name drop-down, ensure the user you want to create does not already exist.
- If they do, then troubleshoot the reason why they cannot log in.
- Click File -> New. The New User Dialog will appear.
- Enter the desired username. Click OK.
- Click Yes to copy from an existing definition.
- Select the user you want to copy from in the drop-down box that appears. Click OK.
- Click Save to save the new user.
- Log out of ConnectR.
SQL Steps
- Log in to SQL server management studio on the ConnectR server as an administrator
- Expand Security.
- Expand Logins.
- Ensure the desired user does not already have a username.
- If they do, skip to step
- Right-click Logins and select New login…
- Enter the desired username.
- Select SQL Server authentication and input the credentials twice.
- Uncheck enforce credentials policy.
- Change the default database to ConnectR.
- On the User Mapping page, ensure the Map box is checked for ConnectR and master.
- Ensure both ConnectR and master have default schema set to dbo.
- Under ConnectR, ensure ConnectR_User, db_owner, and public are checked.
- Under master, ensure db_owner and public are checked.
Test
- Open ConnectR using the new user and verify access.
Keywords
User Users Login Logins Log-ins Log-in Log in Log ins ConnectR Connect R Individual Unique