Cannot continue with the installation. The user does not have sufficient rights to the SQL server

Article Id: 169710
Status: Published
Updated On: 26-07-2017 09:16
Legacy Id: TECH246836
Products:
Ghost Solution Suite
Issue/Introduction:

When upgrading Ghost Solution Suite from 3.1 X to 3.2 you may receive an error. Cannot continue with the installation. The user does not have sufficient rights to the SQL server.

 

Cannot continue with the installation. The user does not have sufficient rights to the SQL server.

Cause:

Under Negation

Environment:

Ghost Solution Suite from 3.1 X to 3.2

Resolution:

To resolve this you will need to add "sysadmin" to the SQL user's permissions.

  1. Open SQL management studio.
  2. Connect with the database. 
  3. Expand the security and login folders.
  4. Right click the service account and go to properties.
  5. On the left hand side click "Server Roles".
  6. Add the check for "sysadmin".