Page Comparison

Once the data source is created, the ODBC Microsoft SQL Server Setup window opens to list the chosen settings. The ODBC source will use all the standard defaults which will work in most cases. Click Test Data Source to test the connection.

If unsuccessful, you may need to speak to your DBA (database administrator) about changing these if necessary. To make changes, go to the ODBC Data Source Administrator and click Configure.

There are a few settings that you may need to change:

1. Integrated Security (default): Sometimes you might want to use a SQL Server user and password instead of the default Integrated Security to connect to a Microsoft SQL Server database. To change to a user login, select SQL Server Authentication, enter User and Password.

2. Database: You can specify the database that you want to use by default.

3. Incorrect port number: SQL Server defaults to port 1433, but a different port can be used. Speak to your database administrator (DBA) or network administrator.