Insufficient Database Privileges - You do not appear to have sufficient privileges to create the Sophos database on the selected SQL Server instance.

  • ID dell'articolo: 116690
  • Aggiornato il: 18 gen 2012

Issue

When installing Enterprise Console 5.x the following message is shown:

You do not appear to have sufficient privileges to create the Sophos database on the selected SQL Server instance.  Are you sure that you want to continue?

First seen in


Enterprise Console 5.0.0

Cause

The logged on user does not have the SQL permission "CREATE ANY DATABASE".

What To Do

Either log on to the computer, that hosts the SQL Server, with a Windows account that has the 'dbcreator' right or temporarily grant the logged on user the 'dbcreator' right.

Technical Information

The installer checks the logged on user has sufficient rights to create a new database by executing the following SQL command:

SELECT permission_name FROM sys.fn_my_permissions(NULL, 'SERVER')

This command returns a list of permissions the logged on user has over the SQL instance.  The installer checks that the 'permission_name' value 'CREATE ANY DATABASE' is returned.

If the permission is not returned, the error above is displayed and the following message is logged in the installer log file (%temp%\Sophos_bootstrapper [TIMESTAMP].log):

[TIMESTAMP], INFO : Validating logged on user permissions...
[TIMESTAMP], ERROR : Logged on user does not have permissions to create a database

 
Per maggiori informazioni o per assistenza, vi preghiamo di contattare il supporto tecnico.

Valutate l'articolo

Molto scadente Eccellente

Commenti