Difference between revisions of "ConnectR Individual Log-ins"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
==Instructions== | ==Instructions== | ||
===ConnectR Steps=== | ===ConnectR Steps=== | ||
− | #Log into ConnectR using | + | #Log into ConnectR using credentials. |
#Click Admin on the left. | #Click Admin on the left. | ||
#Click User Profile. | #Click User Profile. | ||
Line 24: | 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. |
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