First, we need to prepare a SQL server database to work with VirtualCenter. Use SQL Server Enterprise Manager to create a SQL Server database and a database user with database operator DBO rights. That’s it for the SQL Server database.
Now we can go to the VirtualCenter server to install VirtualCenter. Before we do the installation, we need to set up the ODBC Data Source.
Go to Settings -> Control Panel -> Administrative Tools -> Data Source (ODBC)
Type an ODBC DSN name in the Name field. For example, Type in Virtual Center. Optionally, type an ODBC DSN description in the Description field. Select or type in the SQL Server host name
After clicking on Next, select SQL Server authentication (Windows NT authentication is supported only if the SQL Server is running on the same system as VirtualCenter Server), enter the VirtualCenter database’s login information.
After choosing the correct database, we can test the Test Data Source. If it passes the test, we are done.
During VMware VirtualCenter Server 2.0’s installation wizard, the first thing it would ask is the database storage. For testing purpose, you could use MSDE. But for production, it is recommended to use Microsoft SQL Server or Oracle. VMware won’t provide technical support in MSDE.
After clicking on Next, it would ask for the database information. Enter the Data Source Name (DSN) for the VMware VirtualCenter database that was created previously (if it is not created yet, click on the button ODBC DSN Setup), along with the ODBC Source Administrator and password.
Proper licensing is required to run the VMware VirtualCenter Server, and here we are configuring it to connect to a VMware License Server, which has been installed in the same server as the VirtualCenter Server.
Next step is to configure VMware VirtualCenter Web Service. And the following port numbers are default.
The next step is to set up how to start up VirtualCenter Web Service.
After this, you just need to confirm that you want to continue to install VMware VirtualCenter, and it will do the rest. Now you are done.