ConnectR Individual Log-ins
Jump to navigation
Jump to search
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