How To Configure ODBC DSN with Different Port Numbers?

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: FYI_SQL_SERVER
Description: FYIcenter.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: "FYIcenter".

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:

Click OK and continue with the next tutorial to finish up ODBC DSN creation.

⇒ Configuring and Testing ODBC DSN Settings

⇐ Verifying the Port Number of the SQL Server

⇑ Configuring ODBC Connection and DSN for SQL Servers

⇑⇑ SQL Server Connection Tutorials