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.
  • This will open the ODBC Data Source Administrator:

Create New Data Source

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

Choose Driver

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

Name Data Source

Create Data Source
  • Create a New Data Source to SQL Server screen will appear.
  • 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.

  • Click Next.

Enter Login Information

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

Select Database

Create Data Source
  • 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.


  • 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.

Finished

Create Data Source
  • Click Next.

  • Click Finish again to exit the ODBC Data Source Administrator.