SQL Database Connection Failure During Remote Console Installation - Ghost Solution Suite

Products

• Ghost Solution Suite

Issue/Introduction

During the installation of an additional remote Ghost Solution Suite (GSS) console, the installer fails to locate or connect to the GSS SQL Database. Manual connection attempts via SQL Server Management Studio (SSMS) or ODBC from the remote computer fail to establish a link to the database server as well..

Environment

• Product: Ghost Solution Suite (GSS) 3.x
• Database: SQL Server, SQL Server Express (All Versions)
• Component: Remote Console Installer

Cause

This issue is typically caused by the SQL Server being configured to allow only local connections, with required network protocols (Named Pipes/TCP-IP) disabled by default

Resolution

To resolve the database connectivity failure, verify and enable the necessary SQL Server network protocols and services:

1. Log in directly to the server hosting the GSS SQL database.
2. Open the SQL Server Configuration Manager.
3. Expand SQL Server Network Configuration and select Protocols for [YourInstanceName] (e.g., Protocols for MSSQLSERVER).
4. Right-click and Enable both Named Pipes and TCP/IP.
5. Ensure the SQL Server Browser service is running and set to Automatic.
6. Restart the SQL Server Services for the changes to take effect.
7. Relaunch the GSS Remote Console installation on the remote workstation.