| Event Id | 3 |
| Source | Altiris eXpress Server |
| Description | “SQL Server does not exist or access denied. ConnectionOpen(Connect())” |
| Event Information | Cause: 1. Windows Application Event Log: If the SQL Server and Deployment Server are on the same machine, then the error occurs because Altiris eXpress Server is attempting to load before SQL Server has finished loading. This is not a problem because eXpress Server will keep retrying to open SQL and eventually succeed when SQL Server finishes loading. 2. and 3. Web Console and 32 bit console: The communication between the services and the SQL server is not working correctly. 4. AxSched, AxExport, and AxImport: incorrectly specifying the command line parameter when using SQL instances. Resolution: 1. Windows Application Event log: If the SQL Server and Deployment Server are on the same machine, to get the error messages to stop appearing, set a dependency for the Deployment Server Services by running the following three lines in your command prompt: sc config “Altiris Deployment Server Data Manager” depend= “MSSQLSERVER” sc config “Altiris Deployment Server DB Management” depend= “MSSQLSERVER” sc config “Altiris eXpress Server” depend= “Altiris Deployment Server DB Management” 2. and 3. Web Console and 32 bit console: Verify that the communication is configured properly to the SQL server. If MSDE is used and the SQL server and DS are on separate boxes, TCPIP must be enabled as a protocol. Also verify that the SQL server has TCPIP enabled as a protocol. Below are steps to configure the protocols with SQL 2000. --a. From the Run command type, “C:\program files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe”. -- b. Add TCPIP as a communcation protocol. Set the port to the port specified on the SQL server, normally port 1433. --c. Open Control Panel > Administrative Tools > Data Sources(ODBC) > System DSN. --d. Configure the Altiris express database. --e. Change server to the IP address or the fully qualified name of the server (for example, server.domain.com). --f. Click Finish. --g. Restart Dbmanagement, Datamanager, and Axengine services. |
| Reference Links | Error "SQL Server does not exist or access denied" |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.