I am trying to migrate the vCenter database from SQL 2008 Express to SQL 2012 Standard (AD domain environment).
I have followed this guide: VMware KB: Moving the VMware vCenter Server 4.x/5.x/6.0.x SQL database but still run into problems.
I have detached the original databases from Express server and attached them on the new SQL server, created new role which was given db_owner permissions on the transferred databases.
I have update the ODBC connection on the vCenter server to reflect the new connection set and the connection test completes successfully.
However when I try to start the cVenter service it fail and in the logs I find this information:
2015-10-21T09:40:09.823+01:00 [11076 info 'utilvpxdVdb'] Registry Item DB 5 value is '50'
2015-10-21T09:40:09.824+01:00 [11076 info 'utilvpxdVdb'] [VpxdVdb::SetDBType] Logging in to DSN: VMware vCenter with username vpxuser
2015-10-21T09:40:09.831+01:00 [11076 error 'utilvpxdVdb'] [VpxdVdb::SetDBType]: Login failure - retrying once...
2015-10-21T09:40:09.831+01:00 [11076 error 'utilvpxdVdb'] [VpxdVdb::SetDBType] Failed to connect to database: . Retry attempt: 1 ...
2015-10-21T09:40:11.774+01:00 [04608 warning 'VpxProfiler' opID=SWI-41a7] VpxUtil_InvokeWithOpId [TotalTime] took 12000 ms
2015-10-21T09:40:19.832+01:00 [11076 info 'utilvpxdVdb'] [VpxdVdb::SetDBType] Logging in to DSN: VMware vCenter with username vpxuser
2015-10-21T09:40:19.840+01:00 [11076 error 'utilvpxdVdb'] [VpxdVdb::SetDBType] Encountered login error. Subsequent connection attempt failed: 28000
2015-10-21T09:40:19.840+01:00 [11076 error 'utilvpxdVdb'] [VpxdVdb::SetDBType] Aborting after 1 retries.
2015-10-21T09:40:19.840+01:00 [11076 error 'Default'] Error getting configuration info from the database
2015-10-21T09:40:19.840+01:00 [11076 warning 'vpxdvpxdMain'] Database not initialized. Nothing to unlock
2015-10-21T09:40:19.841+01:00 [11076 info 'Default'] Forcing shutdown of VMware VirtualCenter now
What am I missing?
When you test your ODBC connection, does the test succeed? It looks like you are missing permissions on the new database for vpxuser.
test the ODBC connection while you are logged in with the service account (if you use windows authentication).otherwise the user tries to log in with your admin account you are logged in on the server...
btw haveyou tried to log in to the instance with the sql management studio?
ODBC test is successful and I was also able to login to the database with the vpxuser via SQL Management Studio. But still nothing.
Taking brunofernandez1 suggestion on different accounts I have created a service account on AD and set the vCenter Server service to be run by this account. Than I added that account to the DB server and gave it db_owner permissions for the vCentre BD. It all worked. I had to do the same thing for the update manager database.
Thanks for all the suggestions.