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