CMT SSMT Individual Log-ins

Description

This page contains instructions on how to make individual log-ins for users for CMT or SSMT. This is if your organization does not want to utilize shared log-ins for these applications. FOR EXPERIENCED DBAs ONLY!!!!! Use at your own risk! Please contact a member of the Galen Technical Services team if you require assistance.

Instructions

1. Ensure user is a valid user in EEHR.
   1. Log in as an administrator (contact Allscripts or your Galen resource for login credentials if needed)
   2. Search for the user.
   3. If they exist, this step is fine.
2. Ensure user is a valid user in SQL.
   1. Log into SQL management studio.
   2. Look for user in Logins.
   3. If they are not there, you must create a new user.
   4. Login name should match the EEHR login name exactly.
   5. Use SQL authentication for password.
   6. Create password.
   7. Uncheck enforce password policy.
   8. Set default database to Works.
   9. On user mappings page, check Map for the following DBs: IDXwf, Impact, master, Works
      1. Ensure the Default Schema for each is dbo
      2. Click the IDXwf database, and in the lower pane, check db_owner and public.
      3. Click the Impact database, and in the lower pane, check db_owner and public.
      4. Click the master database, and in the lower pane, check IDXUsers and public.
      5. Click the Works database, and in the lower pane, check idxusers and public.
   10. Save your changes
3. Test it out.

Keywords

User Users Login Logins Log-ins Log-in Log in Log ins SSMT CMT CMT/SSMT SSMT/CMT Individual Unique