NS connection to SQL server failed. Symantec-CMDB (In Recovery)

Products

• Client Management Suite

Issue/Introduction

Notification server is not responsive and console not loading after rebooting the database: 

 

[5/5] SQL connection failed, current user='SERVICE ACCOUNT', total time=00:02:29.9670338

Connection Timeout Expired.  The timeout period elapsed during the post-login phase.  The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=9; handshake=14; [Login] initialization=0; authentication=0; [Post-Login] complete=29722;

 

Environment

Release : 8.x

 

Cause

Checked the CMDB and found in front of the Symantec CMDB is written 'In Recovery'. Database were gone to recovery mode because the reboot and the corruption before that.

 

 

Resolution

Check the database logs to know the phase of the recovery. It will also show the estimated time needed for the recovery to get completed.

If it will take longer that usual to get completed, usually means that the database may have issues that were not able to be resolved. You may be better to restore the database to a safe backup .

*You can also check the SQL server logs and Altiris logs to know the reason of the crash.