"The user associated with the DSN has insufficient privileges" when upgrading from vCenter Server 5.x to 6.x

Products

• VMware vCenter Server

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.

1. From the server that is hosting the vCenter Server database, open the Microsoft SQL Management Studio.
2. Click New Query.
3. 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

For more information, see the vSphere Installation and Setup Guide.

Additional Information

vCenter Server 5.x から 6.x にアップグレードすると「DSN に関連付けられているユーザーの権限が不足しています (The user associated with the DSN has insufficient privileges)」と表示される
VMware vCenter Server 从 5.x 升级到 6.x 时出现”与 DSN 关联的用户没有足够的权限（The user associated with the DSN has insufficient privileges）”报错