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

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".