MS SQL Server Interview Question:

How To Configure ODBC DSN with Different Port Numbers?

Submitted by: Administrator

If your SQL Server is not using the default port number, like 1269, you need to set the port number to the correct value during the ODBC DSN creation process, as show in this tutorial:

1. Start ODBC Data Source Administrator and click System DSN tab.

2. Click Add button, select SQL Server and click Finish button.

3. Enter the following and click Next:

Name: ggl_SQL_SERVER
Description: GlobalGuideLine.com SQL Server
Server: LOCALHOST

4. Select the radio button on "With SQL Server authentication using a login ID and password entered by the user. Also enter in Login ID field: "sa" and in Password field: "GlobalGuideLine".

5. Click "Client Configuration..." button. The "Edit Network Library Configuration" dialog box shows up.

Check and uncheck "Dynamically determine port" and enter "1269" as the Port Number. See picture bellow:
ODBC DSN Port Number Setting

Click OK and continue with the next tutorial to finish up ODBC DSN creation.
Submitted by: Administrator