Skip to main content
OCLC Support

How can I set up Microsoft SQL Management Studio to do Database queries on a Hosted ILLiad site?

Symptom
  • You want to use Microsoft SQL Management Studio to do a query for the ILLiad Database
Applies to
  • ILLiad
Resolution

Here are the steps to access the ILLiad Database so you can run Queries using Microsoft SQL Management Studio:

  1. Follow the documentation for Setting up the ODBC Data Source Link.  Wherever you see the ILLiadLink Login ID, you will replace it with the ILLiadLink Login ID OCLC gives you.
  2. Open Microsoft SQL Management Studio.  If you do not have it, you will need to install it.
  3. Open a New Connection.
  4. Put in the server name you also have in your ATLAS SQL Alias Manager.  For example, abc-db.illiad.oclc.org in the Servername field.
  5. Put the link name OCLC sent you in the login field.
  6. Put the password OCLC sent you in the password field.
  7. Click on Remember Password.
  8. Click on Connect.  Here is an example: 
  9. Accessing ILLiad Database.png
Additional information

If you need help with running queries, you will need to contact your Technical Department.  If you need help setting this up, contact OCLC Support.  You will only have read access.

Page ID
46068