Error connecting to database server message when starting a Ghost Solution Suite remote console

book

Article ID: 170187

calendar_today

Updated On:

Products

Ghost Solution Suite

Issue/Introduction

You have installed a remote GSS 3.x console on a client machine using the component installation option and receive an error when launching it. 

Error connecting to the database server. Please check your database server to see that it is functioning properly. 

State:28000,Native:18456,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

Cause

The currently logged in user has insufficient privileges on the eXpress DB on the SQL server. 

Environment

Ghost Solution Suite 3.x 

Resolution

In Active Directory

  1. Create an Active Directory group 'GSS Console Users'
  2. Add the users you require to the group

On the SQL server hosting the eXpress DB using SQL Server Management Studio:

  1. Add the GSS Console Users group to the logins in the Security folder
  2. Under the General section, select the eXpress DB as the default
  3. Under the User Mapping section, tick the eXpress DB in the top pane and in the lower pane add the datareader and datawriter permissions
  4. Log in to the remote client with the user credentials from a member of the GSS Console Users group and verify the connection is successful