After stopping and restarting MSSQLSERVER service , eCM cannot connect and receives error message [Microsoft][ODBC SQL Server Driver]Communication link failure. The logical solution would be to stop and start vcs server service after MSSQLSERVER has been restarted. Unfortunately, this is not always appropriate and can be extremely bothersome if SQL is shut down on a daily basis.
Resolution: When a new database is added, configure the MSMQ on the settings page of the admin module (if you want to enable notifications) then restart the Notification Process. Workaround:
Notification service gives error "Log entry string is too long. A string written to the event log cannot exceed 32766 characters" and must be restarted