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
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.
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.
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
sysadmin server roles.
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.
The Create a New Data Source dialog box will open. Select
SQL Server Native Client 11.0 and click
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
Here, we choose the Integrated Windows authentication. The SQL server will verify the authenticity of the login ID using
Active Directory, so we click
Here, change the default database to
vCenDB and click
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.