When installing vCenter 4.1 on a Windows Server 2008 R2 instance there are some prerequisite, which have to be fullfiled before the actualy installation can be started.
When using a SQL Database server which resides on a different host, the installation of the SQL Server Native Client is required. When not installing the software, the ODBC connection to the database isn’t working. With the following URL the required software can be downloaded:
While creating the ODBC connection to the SQL Server Database with the Data Source Administrator program, the connection needs to be created with the selection of the SQL Native Client.
On the SQL Database server the database need to be created and some specific SQL Server user account needs to be created. The created SQL Server account is given some specific permission to get the installation to work. The account needs the db_owner permission on the database just created and the same permission on the msdb database. The last permission can be released after the installation of vCenter is finished.
When doing the actualy instllation of the vCenter machine the just created ODBC connection can be selected as the installtion destination, and all the database information is written to this database.
After finishing these steps the installation is done and you end up with a working vCenter installation.