Configuring Microsoft SQL Server for VirtualCenter - AnotherWay

[renegadeZA]

If you carrying out a full VirtualCenter 2.5 installation you will need two databases: one for

VirtualCenter and one for the new VMware Update Manager Service

At the SQL Server

1. Open Enterprise Admins, and Expand + Microsoft SQL Servers, + SQL Server

Group, + (Local) (Windows NT)

2. Right-click the Database folder, and choose New Database and type: vc-db (or

something similar/appropriate) - and choose OK

3. Expand the + Security tab, and right-click Logins, and choose New Login

4. Browse with ... button to select the account created for VirtualCenter database...

5. Choose the option SQL Server Authentication and type in the password for the

VirtualCenter Database User

6. and set the Default Database to be the database created at point 2

7. Click the Database Access tab, Permit access for the database, for VirtualCenter

Database User, also enable the permission db_owner - and choose OK

8. Click OK, and Confirm the password again

Note:

Repeat this process for the Update Manager Service database, perhaps calling vmwareupdateDB.

I used the same database user account to authenticate to both databases

Configuring VirtualCenter with Microsoft DSN

Previous VirtualCenter installations had a button in the installer to load the Data Sources (ODBC)

manager. This Microsoft Management tool is used to configure DSN settings to allow the

VirtualCenter to "speak" to the Microsoft SQL Database. Prior to starting the VirtualCenter 2.5

installation these settings need to pre-configured for both databases.

At the VirtualCenter Server

1. Open ODBC Data Source Administrator from Administrative Tools on the Start,

Programs menu

2. In the ODBC Data Source Administrator choose the System DSN tab

3. Click the Add button

4. From the end of the list choose SQL Server, and select Finish

5. In name field of the Create a New Data Source to SQL Server dialog box, type

VMware VirtualCenter

Note:

The VirtualCenter installation assumes this name

6. From the drop-down list select your SQL server and click Next

7. Select "With SQL Authentication..." and type in the user account and password for the

database set up in SQL and click Next

8. Enable "Change the default database to" and select the VirtualCenter Database you

created earlier

9. Click Next and Finish

Note:

You should be now able to confirm all the dialog boxes associated with the ODBC setup -

and also test that you have connectivity to the database server. This test is nearly always

successful. It does not test your user account credentials.

Note:

Repeat the above steps for the Update Manager Database using "VMware Update

Manager" as the name of the DSN

Comptia A+ | Comptia N+ | CCNA |NES |HP ACT | EE N3 | MCP | MCTSx1 | MCITPx1 | SCS