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

Article Id: 156406

Status: Published

Updated On: 24-10-2014 06:50

Legacy Id: TECH188398

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