1 (888) 569-7711
Toll-Free:

ODBC Set-Up: MS SQL Server

To set up a MS SQL Server DSN:

  1. Open the Windows Data Sources (ODBC) control panel:
    1. From the Start menu, choose Control Panel.
    2. On Windows 2000/XP, open the Administrative Tools folder.
    3. Double-click the Data Sources (ODBC) icon.
  2. This will open the ODBC Data Source Administrator:

    3. Create New Data Source

    Create Data Source
  3. On the System DSN tab, click the Add… button.

    4. Choose Driver

    Create Data Source
  4. From the list of drivers that appears, choose SQL Server, and click Finish.

    5. Name Data Source

    Create Data Source
  5. Create a New Data Source to SQL Server screen will appear.
  6. For Data Source Name, enter a name for the data source. Remember the name you choose, it is the same name you should enter in the ODBC DSN box in the Extractor.
  7. Click Next.

    8. Enter Login Information

    Create Data Source
  8. Select the With SQL Server authentication using a login ID and password entered by the user radio button.

    9. Select Database

    Create Data Source
  9. Enter the credentials into the Login ID and Password fields. Then click Next.
    Note: You may need to modify Client Configuration. If you have trouble with this step, please talk with your local IT administrator.
  10. If your Database is not setup as the default database, click on the Change the default database checkbox and select the database from the drop down list.
    Note: You are not required to enter data in the remaining fields.

    11. Finished

    Create Data Source
  11. Click Next.
  12. Click Finish again to exit the ODBC Data Source Administrator.

Contact support

Toll Free
1 (888) 569-7711
Support hours
Monday-Friday
8:30AM - 3:00PM PST
Start a support request
By email