Fail to connect to database. Vendor's error code is [0], SEPM's error code is [11501]. Error message is [Unable to get information from SQL Server xxxx]

Article:TECH159897  |  Created: 2011-05-12  |  Updated: 2012-07-21  |  Article URL http://www.symantec.com/docs/TECH159897
Article Type
Technical Solution


Issue



When using the Management server configuration wizard to create a database for replication, the wizard hangs and does not respond for a long time. Replication eventually fails with errors. The SQL database installation fails.

 


Error



In the install_log.err file, the following error can be found:

SqlPropPanel >> CheckDBConnection > Fail to connect to database. Vendor's error code is [0], SEPM's error code is [11501]. Error message is [Unable to get information from SQL Server: xxxxxxxxxxx]

 


Environment



SEP 11 RU6a

Windows 2008 R2 64 bit

Ms SQL Server 2005 on a seperate server on Windows 2008 R2 64 bit

 


Cause



The UDP port 1434 was not open.

 


Solution



TCP port 1433 and UDP port 1434 need to be opened and listening both ways from SEPM Server to Remote SQL and from Remote SQL to SEPM Server in order for the SEPM to communicate with the SQL database.

To check, you can use PortQryV2 (http://support.microsoft.com/kb/832919) from Microsoft -  C:\PortQryV2>PortQry.exe -n helios -e 1433 -p both

A successful query will return information such as InstanceName, Port, Version of SQL.

If UDP 1434 is being blocked the only response you'll see is "Filtered" in which you'll need to allow communication on 1434 UDP bi-directionally.

 



Article URL http://www.symantec.com/docs/TECH159897


Terms of use for this information are found in Legal Notices