To Set Up an SQL Server Data Source Using ODBC

1. Do one of the following:
   • Windows 7: Click the Windows Start button Control Panel.
   • Windows 8: Right-click the Windows Start screen (or use the swipe up gesture from the bottom edge while on the Start screen). Click All Apps Windows System Control Panel.
   • Windows 8.1: On the Windows Start screen, click the All Apps button located near the lower-left corner of the screen (or use the swipe up gesture from the bottom edge of the screen). Scroll to the Windows System section and click Control Panel.
2. Double-click the Administrative Tools icon, and then double-click Data Sources (ODBC).

   You might need to click the Performance and Maintenance or System and Security category link based on you operating system.

3. In the ODBC Data Source Administrator dialog box, do one of the following:
   • Click the User DSN tab to create a data source that is visible only to you and can be used only on the computer you create it in.
   • Click the System DSN tab to create a data source that is visible to all users who have access rights to the computer.
   • Click the File DSN tab to create a data source that can be shared with other users who have the same ODBC drivers installed on their systems.
4. Click Add.
5. Select SQL Server, and then click Finish.
6. Follow the instructions in the wizard to complete the data source setup.

   Microsoft provides additional Help topics describing the interface components of each page in the wizard. To view Help for a wizard page, click Help.

7. In the ODBC Data Source Administrator dialog box, click OK.