Unable to connect to the Ghost Solution Suite DB during Remote Console install

Products

• Ghost Solution Suite

Issue/Introduction

While attempting to install an additional remote Ghost Solution Suite (GSS) console, the GSS SQL Database is not found. If a connection from the remote console computer to the SQL database is attempted with SQL Management Studio or ODBC, the connection attempt fails.

Environment

GSS 3.x

SQL Server and SQL Server Express

Cause

In at least one instance of this issue, it was discovered that Named Pipes and TCP/IP protocols were disabled for the SQL server

Resolution

To resolve this issue do the follwing:

1. Open 'SQL Server Configuration Manager' directly on the SQL server
2. Expand 'SQL Server Network Configuration' and click on 'Protocols for MSSQLSERVER'
3. Enable 'Named Pipes' and 'TCP/IP' and restart SQL Server Services
4. Attempt the GSS Remote Console installation again