Problem Installing vCenter Server 6: The user associated with the DSN has insufficient privileges

By | 25/04/2016

Today while working in my lab I was facing one issue when I was trying to install vCenter Server on top of Server 2012. I was experimenting to deploy vCenter Server with external SQL 2014 database. This was my first experience with working on external database for vCenter Server and I knew I am gonna face some issues.

I created vCenter Server database on my SQL Server and tested connection from vCenter Server to database (ping, telnet etc) and all went fine. I setup 64 bit DSN on my vCenter Server to connect to the SQL Server and that too went fine and I was very relaxed that most difficult part is already over.

vc-14

This is when my happiness was blown away by error as described below.

vcp-5

On database settings page when I choose next I was getting error “The user associated with the DSN has insufficient privileges“. This is shown below:

vcp-1

I was not aware of this issue so I started googling and immediately found the solution.

To resolve the above issues we need to follow below steps:

1: Uninstall Microsoft ODBC Driver 11 for SQL Server (if installed any)

In my case I had that installed in my system and I removed it for good measures:

vcp-2

The only requirement for vCenter Server to connect to external SQL Server database is presence of SQL Server Native Client. The latest version  of native client can be downloaded from here

2: Assign VIEW ANY DEFINITION and VIEW SERVER STATE permission to the vCenter server user.

To do so connect to your SQL Server database and navigate to properties.

vcp-3

Go to Permissions and select the vcenter server user (alex\svcvcenter in my case), Under permissions drag the sidebar to the bottom most part and checkmark the view any definition and view server state checkboxes. Hit OK to save.

vcp-4

And that’s it. You will be able to navigate to next page of installation without any issues.

I hope you enjoyed reading this post. Feel free to share this on social media if it is worth sharing. Be sociable :)

 

Category: VMware

About Alex Hunt

Hi All I am Manish Jha. I am currently working in OVH US as Operations Support Engineer (vCloud Air Operations). I have around 7 Years of IT experience and have exposure on VMware vSphere, vCloud Director,vSphere Replication, vRealize Automation, NSX and RHEL. If you find any post informational to you please press like and share it across social media and leave your comments if you want to discuss further on any post. Disclaimer: All the information on this website is published in good faith and for general information purpose only. I don’t make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information you find on this blog is strictly at your own risk. The Views and opinions published on this blog are my own and not the opinions of my employer or any of the vendors of the product discussed.