Connection to database failed. Altiris.NS.Exceptions.AeXException: Failed to open database connection

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

Getting an error message in the a.log file

Connection to database failed. ---> Altiris.NS.Exceptions.AeXException: Failed to open database connection. Current user is Domain\AltirisService. Error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid) ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid)
 

Cause

AltirisService account does not have DBO  rights to the Symantec_CMBD  (NS  database).

Resolution

From within the SQL  Management Studio, give the AltirisService account DBO  rights to the Symantec_CMDB

Applies To

SMP  7.x