ODBC Set-Up: MS SQL Server

To set up a MS SQL Server DSN:

1. 
   
2. 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

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

Choose Driver

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

Name 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

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

Select Database

• 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

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