PVS fails to connect to database after sql server mirroring failover
Article ID: CTX213393
Updated On:
Description
SqlException on db open, number = 53, msg = <A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
Resolution
dbmssocn will speed up failover connection re-try, follow below Microsoft documentation to enable sql TCP/IP Alias to prevent this issue:
Problem Cause
If principle host crashed, and sql native client didn't receiver current Principals/failover partner information, it takes more time to obtain Principals/failover information.
Was this article helpful?
Yes
No
Powered by
