Upgrading vCenter Server 6.0 with a Microsoft SQL Server 2008 database fails with the error: Source vCenter Server validation found an issue: Error executing 'SELECT required_perm.permission_name'

Products

• VMware vCenter Server
• VMware vSphere ESXi

Issue/Introduction

• Upgrading to vCenter Server 6.0 with an external Microsoft SQL Server 2008 database fails with the error:
  
  Error: Source vCenter Server validation found an issue: Error executing 'SELECT required_perm.permission_name' Resolution: Please make sure your database is configured to meet vCenter Server upgrade requirements.
   
• The issue occurs when using a domain user.
• The issue does not occur when using a local system user.

Environment

VMware vSphere ESXi 6.0
VMware vCenter Server 6.0.x

Resolution

This is a known issue affecting the Microsoft SQL Server 2008 versions.

For more information on the upgrade process, see the vSphere Upgrade Guide.

 

Also, for Microsoft SQL Server compatibility, see VMware Product Interoperability Matrixes.

 

Note: The preceding links were correct as of March 24, 2015. If you find a link is broken, provide a feedback and a VMware employee will update the link.

For translated versions of this article, see:

日本語:Microsoft SQL Server 2008 データベースを使用している vCenter Server を 6.0 にアップグレードしようとすると、次のエラーで失敗する： Source vCenter Server validation found an issue: Error executing 'SELECT required_perm.permission_name' (2111648)