Test your SQL server connectivity

Click Start > Settings > Control Panel.

Double-click Administrative Tools.

Double-click Data Sources (ODBC).

• The ODBC Data Source Administrator opens

Click the System DSN tab.

Click Add.

• The Create New Data Source window opens

Scroll to the Microsoft SQL Server entry and click it.

Click Finish.

• The Create a New Data Source to SQL Server window opens

Enter the following field information:

• Name : Test
• Description : Test
• Server : <SQLServer>\<SQLInstance> or select from drop-down menu

Click Next.

If using Windows authentication, select the Windows NT® authentication option. If using SQL authentication, select the Microsoft SQL Server authentication option.

If using SQL authentication, type the user name and password used by the server to access the Microsoft SQL Server.

Click Next.

• The ODBC attempts at this point to connect to the Microsoft SQL Server
• If the connection fails, an error message appears

If the connection succeeds, select the Change Default Database to check box.