Wednesday, November 11, 2009

vCenter and MSSQL

To prepare a SQL Server database to work with vCenter Server, you generally need to create a SQL Server database user with database operator (DBO) rights. When you do this, make sure that the database user login has the db_owner fixed database role on the vCenter Server database and on the MSDB database. The db_owner role on the MSDB database is required for installation and upgrade only, and you can revoke it after installation.

If you are using SQL 2008, make sure you go to the “CMD” line and change the default ODBC from 32 to 64 Bit

Should read: If you are using Windows 2008 64 bit OS and vCenter with SQL, launch the 32 bit ODBC connector.

Create a 32-Bit DSN on a 64-Bit Operating System
You can install or upgrade to vCenter Server on both 32-bit and 64-bit operating systems.
Even though vCenter Server is supported on 64-bit operating systems, the vCenter Server system must have
a 32-bit DSN. This requirement applies to all supported databases. By default, any DSN created on a 64-bit
system is 64 bit.
1 Install the ODBC drivers.
n For Microsoft SQL Server database servers, install the 64-bit database ODBC drivers on your Microsoft
Windows system. When you install the 64-bit drivers, the 32-bit drivers are installed automatically.
n For Oracle database servers, install the 32-bit database ODBC drivers on your Microsoft Windows
NOTE The default install location on 64-bit operating systems is C:\VMware.
2 Run the 32-bit ODBC Administrator application, located at [WindowsDir]\SysWOW64\odbcad32.exe.
3 Use the application to create your DSN.
You now have a DSN that is compatible with vCenter Server. When the vCenter Server installer prompts you
for a DSN, select the 32-bit DSN.

No comments: