Error: The User Associated With the DSN Has Insufficient Privileges

Posted on by Jordansphere

I was just about to upgrade vCenter 5.5 u2 -> 6.0 u2 . DB Server: MS SQL 2008 R2 SP2.  During the pre-upgrade checks I got the following error

 

Error: The user associated with the DSN has insufficient privileges
Resolution: Provide sufficient privileges for the user gy granting the following permissions:

* VIEW SERVER STATE

* VIEW ANY DEFINITION

 

 vcenter_pre_upgrade1

 

Reslution:

It appears these commands were global but I double checked the user jordansql had full db_owner permissions first of all

I then applied the following settings via SQL Studio Management Studio:

use master
go
grant VIEW SERVER STATE to [jordansql]
go
GRANT VIEW ANY DEFINITION TO [jordansql]
go

 

 

Screenshot :

vcenter_pre_upgrade2

 

The pre-check progressed past this check.