Top menu

‘Select permission denied on object 'name', database 'name', schema 'name'’ error when installing DeviceLock Enterprise Server, or modifying its configuration in DeviceLock Enterprise Server options

DESCRIPTION

SQL Server connection configuration returns ‘Select permission denied on object 'name', database 'name', schema 'name'’  error  either during the installation of DeviceLock Enterprise Server, or when configuring its oprions in DeviceLock Enterprise Server options.

COMMENTS

The error the user account (login) used to connect to SQL Server does not have read/write access to the existing database.

RECOMMENDATIONS

The login should have at least db_datareader and db_datawriter Database roles (see User Mapping in Login Properties of Microsoft SQL Server Management Studio).