vSphere Center Server on Windows 2008 64 bit

[fcait]

Hello everyone, I am very new to the use of vSphere Center. I have installed vSphere Center Server on Windows 2008 X64 standard. It chose to install the SQL 2005 Express. I got through the AD setup portion and am working on the Database setup. It keeps giving me an error about needing to initialize the database, but I can browse and query the database just fine. So my first question is which database is it? I am assuming it is "VIM_VCDB" and here is the instance of the default install "SQLEXP_VIM" and here is the error I keep getting when trying to apply changes.

Error: Database connection successful. No schema found. Please initialize database.

The user I am using has dbo access and the default schema is showing up as dbo. I would appreciate any help on this?

Thanks

[java_cat33]

You must also assign db_owner permissions to the user you have specified for VIM_VCDB to the system database msdb.

[fcait]

I have set the database role membership fo the database to db_owner and set the default Schema to dbo, where else do you set permisions on a database?

[Troy_Clavell]

you need dbo on the MSDB and the VCDB

Make sure you use the SQL Native Client for ODBC

[Geoflex]

you should crerate a 32 bit DSN insted of the native 64 DSN.

[FOSKingston]

How do I create a 32 bit dsn rather than 64 bit?

[admin]

Hi,

Invoke odbcad32.exe from C:\WINDOWS\SysWOW64\odbcad32.exe

Thanks.

*if you found this or any other answer useful, please consider allocating points for helpful or correct answers*