How to Configure SQL Server for vCenter Server 4.1

Now i will explain about how to create database for both vCenter and Update Manager from SQL Server Management Studio..

Select Server type : Database Engine
Server Name : SQLSERVER
Authentication : Select SQL Server Authentication

I am going to create new login for vCenter and databases for vCenter (VCDB) and Update Manager (VUMDB)
Click Connect

We should create a new login for vCenter in order to access the databases. Select Security folder from Management studio.

Expand Security folder and right click on Login selecting “New Login” options

Provide a login name and password for vCenter and select the option SQL Server authentication. (Creating new login user is vcenter)

From the below image you can see from the new user login is created “vcenter”

From the object explorer window, right click on the “Database” folder and select “New Database”.

On the New Database window, provide a name for the database (here my vCenter server DB name is “VCDB”) and set the owner for the db is vcenter. (My vCenter DB owner is vcenter).

Check your vcenter Database name (VCDB) and Owner (vcenter). Press “OK”.

Now Create Update Manager Database (VUMDB)