Web
Analytics Made Easy - StatCounter

vCenter 5.5: create vCenter database and DSN

vsphere55dsn01

If the vCenter database is installed on a dedicated SQL server, we need to create the vCenter database and DSN to link the DB to the vCenter.

To perform this configuration is required a working MS-SQL server.

 

Installation guide

 

Part 6 - Create vCenter database and DSN

From the MS-SQL Server, open the SQL Studio Management tool and access the system.

vsphere55dsn02

In Security > Logins define the account used in vCenter to manage the database.

vsphere55dsn03

Right click Databases item and select New Database option.

vsphere55dsn04

Type a Database name (VIM_VCDB) and assign as Owner the dedicated account previously defined.  The owner has to be same account used in vCenter. Click OK to confirm then exit SQL Studio Management.

vsphere55dsn05

 

Install SQL Native Client in vCenter

To link the database created in MS-SQL Server to vCenter, the SQL Native Client must be installed in vCenter Server. You can download the SQL Server 2008 R2 Native Client driver here. Select the version that match your architecture (32 & 64 bit) then launch the installation wizard.

Click Next to start the installation.

vsphere55dsn06

Accept the EULA then click Next.

vsphere55dsn07

Click Next to continue.

vsphere55dsn08

The Client Components is what we need then leave default settings and click Next.

vsphere55dsn09

Click Install to begin the installation.

vsphere55dsn10

The screen shows the installation Status.

vsphere55dsn11

When installation completes successfully, click Finish to exit the wizard.

vsphere55dsn12

 

Setup DSN

Access ODBC Data Source Administrator from Start > Administrative Tools. Select System DSN and click Add button.

From the Create New Data Source window select SQL Server Native Client 10.0 driver and click Next to start the configuration.

vsphere55dsn13

Type a Name and a Description for your data source. Click the right arrow in the Server field and select the SQL instance you want to connect to. Click Next.

vsphere55dsn14

Leave default settings then click Next.

vsphere55dsn15

Tick Change the default database to field and select the vCenter database VIM_VCDB previously created in the MS-SQL Server. Click Next to continue.

vsphere55dsn16

Leave default then click Finish.

vsphere55dsn17

Test the connection with a click on Test Data Source button.

vsphere55dsn18

The system is properly configured if you get the message:

TESTS COMPLETED SUCCESSFULLY!

Click OK to save the DSN parameters.

vsphere55dsn19

The System Data Source is configured. Click OK to exit ODBC Data Source Administrator.

vsphere55dsn20

When vCenter database is created and DSN configured, we are ready to proceed with next installation step: vCenter Server.

Next: Part 7 - Install vCenter Server

firma

One Response

  1. Arif Kaya 29/05/2014