Create ODBC Database Connection in vCenter Server

vCenter server requires database to store its information. There are two methods you can use to configure database in vCenter server. You can use express SQL 2008 instance or separate dedicated database server. In this post, I will show steps to create ODBC database connection in vCenter Server with dedicated SQL server Server 2012.

Create ODBC Database Connection in vCenter Server 

As I have already installed SQL Server 2012 in Server 2012 R2, let’s create some database and ODBC connection. But before that I will create a user account in active directory which will be used to manage vCenter server.

Here, I have created user account called vCenUser which will be administrator for vCenter server. I will use this user account to login to vCenter server and mange vSphere infrastructure.

Create User in AD

Now get back to SQL server and create a database. To create a database in SQL server, login to database server, then open Microsoft SQL Server Management Studio. Expand the server on the left pane. Right-click Databases and click New Database.

Create vCenter Database

New Database dialog box will open as shown below. On the General tab, type the name of the database. In this case, I have typed vCenDB. Click OK.

New vCenDB Database

We have two option to associate user account to this database. You can either create local user account in SQL server or link the same user account that you created in Active Directory. Here, I will link the same AD user account for this database. To do so, expand Security. Right-click Logins folder and click New Login option.

New Login

Here, type the user account. In this case its the domain user account so type, mustbegeek\vCenUser. Under the default database, choose vCenDB from the drop down.

Type the user account

Select Server Roles on the left pane. Check public and sysadmin server roles.

Server Roles

Now select User Mapping on the left pane. Under Users mapped to this login option check the vCenDB. Similarly, for database role membership for vCenDB option, check db_owner and public. Then click OK.

User Mapping

Now log into vCenter server to create ODBC connection to the database we just created. Open the ODBC Data Source Administrator application. Select System DSN tab and click Add.

System DSN

A new Create New Data Source dialog box will open. Select SQL Server Native Client 11.0 and click Finish.

SQL Server Native Client

Now Create a New Data Source to SQL Server dialog box will open. Here, type name of the ODBC connection, description and server IP address which I have already done as shown below. Then click Next.

SQL Info

Here, choose Integrated Windows authentication. SQl server will verify the authenticity of the login ID using Active Directory so click Next.

Integrated Windows Authenticatin

Here, change the default database to vCenDB, and click Next.

Change default database

Review the settings and click Finish.

Other ODBC Info

Now you can test the data source. If there is any issues, then go back fix the problems and repeat the above steps.

Test ODBC Connection

This is how you create a ODBC connection. Now you can start installing vCenter server.

The following two tabs change content below.
Bipin is a freelance Network and System Engineer with expertise on Cisco, Juniper, Microsoft, VMware, and other technologies. You can hire him on UpWork . Follow Bipin Giri on Google+. Bipin enjoys writing articles and tutorials related to Network technologies. Some of his certifications are, MCSE:Messaging, JNCIP-SEC, JNCIS-ENT, and others.