How to Create an ODBC Database Connection in VCenter Server

The database is required to store the vCenter server. There are two ways you can create a database on the VCenter server. The first is Express SQL 2008 and the other is to use a dedicated database server. In this article, we will see how to create an ODBC database connection with a special SQL server Server 2012 on vCenter Server.

Process of Creating ODBC Database Connection in VCenter Server

Now, as we have installed in SQL Server 2012, Server 2012 R2, let’s create a database and ODBC connection here. But before that, I will create a user account in the active directory that will be used to manage the vCenter server.

The user we created has created a user account called vCenUser that has administrative authority in vCenter. We will use this user account to log in to the vCenter server and manage the vSphere infrastructure.

Create_Vcenter_User
Create_Vcenter_User

 

We are now creating a database on the SQL server. To create a database on the SQL server, log in to the database server, then open Microsoft SQL Server Management Studio. Expand the server in the left pane. Right-click Databases and click New Database.

Microsoft_SQL_Server_Management
Microsoft_SQL_Server_Management

Our database will open as below. In the General tab, we will write the name of the database we want to create. We created its name as vCenDB. We press OK.

New_Database
New_Database

There are two methods to associate user accounts in this database.
The first one is to create a local user account on the SQL server, the second method is that we can use the same user account that you created in Active Directory. We will link the same AD user account for this database. To do this, open the Security segment. Right-click the Entries folder and click New Entry.

We write the user account here. Type the user account as is, mustbegeekvCenUser. Under the default database, we select the value of vCenDB from the incoming list.

Select Server Roles on the right. Check general and sysadmin server roles.

Login_Propertis
Login_Propertis

Now select User Mapping from the right pane. We control vCenDB under Users mapped to this login option. Similarly, for database role membership for the vCenDB option, we check db_owner and public. Then we click OK.

Now login to the vCenter server to create an ODBC connection to the newly created database. Open the ODBC Data Source Manager application. Select the System DSN tab and click Add.

ODBC Data Source Administrator
ODBC Data Source Administrator

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

Now the Create New Data Source To SQL Server dialog box will open. Here we write the name, description of the ODBC connection, and the server IP address we made as shown below. Then we click next.

ODBC Data Source Administrator
ODBC Data Source Administrator

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

Create_new_data_source_to_SQL_Server
Create_new_data_source_to_SQL_Server

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

Finally, we check the settings and click on the finish.

We can now test the data source. If we encounter any problems, we will go back and repeat the initial steps.

We create the ODBC connection as mentioned above. In the next step, we can now start installing the vCenter server.

I hope it was a useful article.