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


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 :)

 

About Alex Hunt

Hi All I am Manish Kumar Jha aka Alex Hunt. I am currently working in VMware Software India Pvt Ltd as Operations System Engineer (vCloud Air Operations). I have around 5 Years of IT experience and have exposure on VMware vSphere, vCloud Director, RHEL and modern data center technologies like Cisco UCS and Cisco Nexus 1000v and NSX. 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.
This entry was posted in vCenter Server, Vmware. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s