book
Article ID: 315333
calendar_today
Updated On:
Issue/Introduction
Granting additional privileges to the vCenter Server database user resolves the issue.
Symptoms:
- Upgrading the VMware vCenter Server from 5.x to 6.x fails while validating the database.
- You see the error:
Error : The user associated with the DSN has insufficient privileges.
Resolution: Provide sufficient privileges for the user by granting the user the following permissions:
* VIEW SERVER STATE
* VIEW ANY DEFINITION
Environment
VMware vCenter Server 6.0.x
VMware vCenter Server 6.5.x
Cause
This issue occurs because vCenter Server 6.x requires additional privileges to be assigned to the vCenter Server database user.
Resolution
To resolve the issue, grant additional privileges to the vCenter Server database user.
-
From the server that is hosting the vCenter Server database, open the Microsoft SQL Management Studio.
- Click New Query.
- Run this query to grant the appropriate permissions to the user that the vCenter Server uses to connect to the database:
use master
go
grant VIEW SERVER STATE to [vCenter_database_user]
go
GRANT VIEW ANY DEFINITION TO [vCenter_database_user]
go