Event ID 17 Unable to open the database Sql Server does not exist or access denied
Log Name: Application
Source: Active Administrator Agent
Date: 18/04/2012 19:28:46
Event ID: 17
Task Category: None
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:
The network connection was lost between the server running the service agent and the Active Administrator database server
The user account used by the service agent no longer has access to the Active Administrator database
The database no longer exists or was renamed
SQL Express installation does not have TCP/IP and Named Pipes enabled
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.