Setup Cannot Communicate with Remote Microsoft SQL Server Database Instance
Valid on Windows platforms.
Setup cannot communicate with Microsoft SQL Server database instances installed on remote computers. As a result, the installation process fails.
ODBC communicates with the SQL Server browser service using UDP port 1434 to detect the TCP port that SQL Server is using to communicate. ODBC then uses the detected port to communicate with SQL Server. If UDP port 1434 is blocked, Setup cannot communicate with remote Microsoft SQL Server instances, which causes the installation process to fail.
To help ensure that Setup can communicate with remote Microsoft SQL Server databases, verify whether UDP port 1434 is blocked or not blocked. Then do one of the following:
UDP port 1434 is blocked--If UDP port 1434 is blocked, configure the ODBC data source to specify port 1433 as the TCP/IP port number of the System DSN. To set the port number, do the following:
Open Odbcad32.exe located in the following directory:
The ODBC Data Source Administrator dialog opens.
- x86 systems:
Click the System DNS tab and then click Add.
The Create New Data Source dialog opens.
Specify SQL Server as the data source and click Finish to continue.
The Create a New Data Source to SQL Server dialog opens.
Complete the following fields on the Create a New Data Source to SQL Server dialog:
- Name--The name of the data source. For example, testmachine1.
- Server--The name of the SQL Server system. For example, testmachine1\mysqlserver.
On the next dialog, click Client Configuration.
The Add Network Library Configuration dialog opens.
On the Add Network Library Configuration dialog, clear the checkmark next to Dynamically determine port number.
In the Port field, specify 1433.
UDP port 1433 is applied.
- Open Odbcad32.exe located in the following directory:
UDP Port 1434 is not blocked--If UDP port 1434 is not blocked, verify that the SQL Server browser service is enabled.
Note: The SQL Server browser service is disabled when you install Microsoft SQL Server.