Troubleshooting Arcserve Backup Installations › Setup Cannot Communicate with Remote Microsoft SQL Server Databases

Setup Cannot Communicate with Remote Microsoft SQL Server Databases

Valid on Windows platforms.

Symptom

Setup cannot communicate with Microsoft SQL Server database instances installed on remote computers. As a result, the installation process fails.

Solution

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:
  1. Open Odbcad32.exe located in the following directory:
     • x86 systems:

       %systemdrive%\Windows\system32

     • x64 systems:

       %systemdrive%\Windows\SysWoW64

     The ODBC Data Source Administrator dialog opens.

  2. Click the System DNS tab and then click Add.

     The Create New Data Source dialog opens.

  3. Specify SQL Server as the data source and click Finish to continue.

     The Create a New Data Source to SQL Server dialog opens.

  4. 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.

     Click Next.

  5. On the next dialog, click Client Configuration.

     The Add Network Library Configuration dialog opens.

  6. On the Add Network Library Configuration dialog, clear the checkmark next to Dynamically determine port number.

     In the Port field, specify 1433.

     Click Finish.

     UDP port 1433 is applied.

• 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.