pdm_configure fails on MSSQL named instance when SQL Browser port is closed on firewall

Document ID : KB000101357
Last Modified Date : 13/06/2018
Show Technical Document Details
Introduction:
pdm_configure fails with this error in configure.log: 
[Microsoft SQL Server Native Client 11.0] [ SQL Code=0 SQL State=HYT00] Login timeout expired; 
[Microsoft SQL Server Native Client 11.0] [ SQL Code=53 SQL State=08001] 
Question:
pdm_configure fails with this error in configure.log: 

XXXXXXXXXXXX sql_ckeckdb 10028 ERROR sqlclass.c 473 Failed to logon to SQL Server (YYYYYYYYYYYY) 
Reason: [Microsoft SQL Server Native Client 11.0] [ SQL Code=0 SQL State=HYT00] Login timeout expired; 
[Microsoft SQL Server Native Client 11.0] [ SQL Code=53 SQL State=08001] 
A network-related or instance-specific error has occurred while establishing a connection to SQL Server.
Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections 

For more information see SQL Server Books Online.; [Microsoft SQL Server Native Client 11.0] [ SQL Code=53 SQL State=08001] Named Pipes Provider: Could not open a connection to SQL Server [53].
Environment:
SDM 17.0 running conventional configuration, primary server, secondary server, remote MSSQL server 
Firewall between database server and primary server 

 
Answer:
Open the UDP port 1434 in firewall
SqlBrowser need UDP port 1434, it make the connection to correct port when port was not set at the connection