Knowledge Base

Minimum Server role : public

Minimum Right on database: dbreader and dbwriter

Since SQL Server 2012 this minimupm right are not suffisant due to a change from SQL Server in the way to connect to Database engine.

When the HDS connects to a database, the SQL Data Management Objects (SQLDMO) driver makes an SQL request using the stored procedure sys.sp_MSdbuserpriv. For earlier versions of SQL server (SQL Server 2008 for example) this works fine, but for SQL Server 2012 the request is rejected and the HDS fails to connect. The problem is due to a change in the user rights required to run the procedure.

The solution is to give the User, that started PcVue, the rights to execute this procedure. This is done in two steps.

1. Map the User to the database using the Guest schema. You must check with the System Administrator if this is acceptable.

2. Give the User the Execution right to the stored procedure sys.sp_MSdbuserpriv.