Troubleshooting 'Unable to connect to the Symantec Ghost Solution Suite DB Management Service'

Products

• Ghost Solution Suite

Issue/Introduction

When launching the Ghost Solution Suite (GSS) console, the error "Unable to connect to the Symantec Ghost Solution Suite DB Management Service. Please make sure this service has been started and is running correctly" appears. This indicates that the service is either stopped, unable to authenticate, or unable to communicate with the SQL database.

Environment

• Ghost Solution Suite 3.x
• SQL Server Express (All supported versions)

Cause

Port 505 is blocked or unavailable.

Resolution

The Ghost Solution Suite, as per our documentation TCP/UDP ports required in Ghost Solution Suite 3.X, port 505 over the TCP protocol needs to available.  If your SQL database is not located on your Ghost Solution Suite server, the port required is 1433.

To confirm, you can run the following PowerShell command:  

Get-NetTCPConnection -LocalPort 505 -ErrorAction SilentlyContinue | Select-Object LocalAddress, LocalPort, State

If the command returns an error, the port is not available and you should work with your server administrator or network team to make it available.

If the command returns nothing, that means the Altiris Deployment Server DB Management service is not running.  You should start the service and try again.

Otherwise, the command should return something that looks like the following:

Additional Information

Some other items to check in addition, are as follows:

1. Check Windows Event Viewer:

   • Open Event Viewer > Windows Logs > System.
   • Filter for errors involving the Altiris Deployment Server DB Management service.
   • Error 1069 (Logon Failure): The service account password is incorrect or expired. Re-enter the service account credentials in the service properties.
   • Error 1067 (Process Terminated Unexpectedly): This often indicates a full transaction log. Check if the SQL database recovery model is set to 'Full'. If so, change it to Simple.

2. Verify SQL Authentication:

   • Ensure the SQL Server instance is configured for "SQL Server and Windows Authentication mode" (Mixed Mode).
   • Verify the GSS service account is explicitly added as a user in the eXpress SQL database with db_owner permissions.

3. Restart Services:

   • Manually restart the following services:
     • Altiris Deployment Server DB Management
     • Altiris eXpress Server