ODBC Set-Up: MS SQL Server
To set up a MS SQL Server DSN:
- Open the Windows Data Sources (ODBC) control panel:
- From the Start menu, choose Control Panel.
- On Windows 2000/XP, open the Administrative Tools folder.
- Double-click the Data Sources (ODBC) icon.
- This will open the ODBC Data Source Administrator:
- On the System DSN tab, click the Add… button.
- From the list of drivers that appears, choose SQL Server, and
click Finish.
- 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.
- Select the With SQL Server authentication using a login ID and
password entered by the user radio button.
- 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.
- Click Next.
- Click Finish again to exit the ODBC Data Source Administrator.