Setting up the SQL Server User Account

Print Friendly and PDF Follow

This step is for self-hosted sites only. Sites with servers hosted by OCLC or Atlas Systems will need to contact their server provider to have an account created for them.

These instructions were written using Windows Server 2008, SQL Server 2012 and SQL Server Management Studio. If you have different versions, the screens and process may vary slightly from the steps outlined here.

Adding the ILLiadLink Login

  1. On your ILLiad Server or on any machine currently connected to the ILLiad server, open SQL Server Management Studio.
  2. Double click on the Security folder to expand it.
  3. Right click on the Logins folder and select New Login.
  4. Verify that you are in the General page of the Login screen.
  5. Type the Login name in the space provided. Atlas Systems suggests using the name ILLiadLink, but you can name this anything you would like.
  6. Select SQL Server authentication.
  7. Type in a password for your login name. Be sure to use the same password consistently throughout this setup.
  8. Check or uncheck the 3 password enforcement options according to your institution's specific password policy.
  9. Under Default database select ILLData (or the name of your ILLiad database).
  10. Click OK. The window will close and you will be back on the main page.
  11. Double click on the Logins folder to expand it.
  12. Double click on the new ILLiadLink icon.
  13. In the properties screen, click the User Mapping page to open it.
  14. Under Users mapped to this login check the box next to the ILLData(or the name of your ILLiad database).
  15. ILLiadLink will now appear as a user next to the database name.
  16. Click OK to close the window.

Setting Permissions for the ILLiadLink Login

You will want to give user ILLiadLink read access to all tables in the ILLData database. You do this by making the login a member of the Role Member db_datareader.

  1. Navigate to the ILLiadLink user under Databases | ILLData | Security | Users | ILLiadLink.
  2. Double click to open the ILLiadLink user.
  3. Verify that you are in the Membership page of the screen.
  4. Under Database role membership check the box next to db_datareader.
  5. Click OK to close the window,

Testing the ILLiadLink Permissions

You can test the ILLiadLink permissions by logging into the SQL Server Management Studio using the ILLiadLink login and password and running a simple query.

If you receive any errors during this process, review the Adding the ILLiadLink Login and Setting Permissions for the ILLiadLink Login sections above to make sure the link was created correctly.

  1. If you have SQL Server Management Studio open, close it.
  2. Open SQL Server Management Studio again.
  3. To log in to your ILLiadLink user account, select SQL Server Authentication.
  4. Enter your ILLiadLink login and password.
  5. Click Connect.
  6. On the main screen, click New Query.
  7. In the open space type a simple query such as:

    select * from customization
  8. Click Execute to run the query.
  9. Query results will appear in a grid at the bottom of the screen along with the message Query executed successfully.


If this article didn’t resolve your issue, please contact Atlas Support for assistance:

Contact Support