Once the data source is crated, the ODBC Microsoft SQL Server Setup window which lists 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. Speak Image AddedIf 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. Image AddedThere are a few settings that you may need to change: User login/Integrated Security (default): Sometimes you might want to use a SQL Server user and password . Using integrated security is the usual way instead of the default Integrated Security to connect to a Microsoft SQL Server database. If this does not work speak to your DBA ( database administrator) about the user credentials you should use to connect to the database. To change to a user login, select SQL Server Authentication, enter User and Password. Database: You can specify the database that you want to use by default. 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.
|