Event ID 17 Unable to open the database Sql Server does not exist or access denied (SL4015)

Event ID 17 Unable to open the database Sql Server does not exist or access denied

Event ID: 17 errors in the Application event log on the domain controller or the server where the Active Administrator ™ agent is installed.

Log Name:      Application

Source:       Active Administrator Agent

Date:          18/04/2012 19:28:46

Event ID:      17

Task Category: None

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      computername.acme.com

Description:

CActiveAdministratorAgent::DoAgentWork - Unable to open the database.

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Error = -2147467259.

This error occurs when the Active Administrator service can no longer connect to the Active Administrator database. This condition can occur for the following reasons:

1. The network connection was lost between the server running the service agent and the Active Administrator database server

2. The user account used by the service agent no longer has access to the Active Administrator database

3. The database no longer exists or was renamed

4. SQL Express installation does not have TCP/IP and Named Pipes enabled

5. SQL Browser service is not started

• Logon to the SQL server

• Open the SQL Server Configuration Manager

• Expand SQL Server Network Configuration

• Click on the instance where the database is residing

• Ensure Named Pipes and TCP/IP are Enabled

• Double click on TCP/IP, ensure the port (1433 default SQL port) is configured

• RDP to the server where Active Administrator agent is installed and open a Command Prompt.

• Telnet to the SQL Server IP Address or SQL server name, and port number 1433. For example: Telnet DNA-VSQL01 1433

• If a blank screen is displayed and no error message displayed, the port is open and the server is communicating.

• Ensure that the SQL Browser service is set to automatic and running.

• Also, verify that the user account used by the service agent exists and has access to the database. If using Windows authentication this account also needs to be in the AA_Admin security group. This group is either local on the SQL server, or global in Active Directory Users folder, depending on what was selected when the database was created.