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
You must also assign db_owner permissions to the user you have specified for VIM_VCDB to the system database msdb.
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?
you need dbo on the MSDB and the VCDB
Make sure you use the SQL Native Client for ODBC
you should crerate a 32 bit DSN insted of the native 64 DSN.
How do I create a 32 bit dsn rather than 64 bit?
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*