Hi,
I needed to move the vCenter database from SQL Server 2008 R2 Express install locally on the vCenter server to a full SQL 2012 server. I moved it and followed the instructions in this VMware KB: Migrating the vCenter Server database from SQL Express to full SQL Server
When I start the vCenter service, I get this error in the vpxd log :
"2014-02-28T15:25:49.928-05:00 [03588 info 'Default'] Registry Item DB 5 value is '50'
2014-02-28T15:25:49.928-05:00 [03588 info 'Default'] [VpxdVdb::SetDBType] Logging in to DSN: SQL Server Native Client 11.0 with username vcenteruser
2014-02-28T15:25:49.928-05:00 [03588 error 'Default'] [VpxdVdb::SetDBType]: Database error: ODBC error: (IM002) - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2014-02-28T15:25:49.928-05:00 [03588 error 'Default'] Error getting configuration info from the database
2014-02-28T15:25:49.928-05:00 [03588 warning 'Default'] [VpxUnhandledException] Win32 Exception (0xe06d7363) detected at 7FEFCDC940D"
Anyone have seen this kind of issue before?
Thank you.
I finally did it.
The key 1 in HKLM\SOFTWARE\VMware, Inc.\VMware VirtualCenter\DB needs to have the same name as provided in the DSN settings, and not the type of driver used.
I used VMware vCenter as the name of the ODBC connection so I had to provide the same name in the registry and the service started
Thanks for you help Madmax01!
Hello, could you please open the ODBC Data Source and repoint to the DB again.
you have to choose the correct SQL Client Driver for sql 2012 .
Because seems to be theire is something missing ;).
Just create System DSN again but with "SQL Server Native Client 11.0"
then test connection with you're created internal sql user or windows user. depending on you're config (mixed mode?)
PS: Please choose correct DB ;(
thx Max
Hello,
I deleted all System DSN and recreated both 32bits and 64bits. Still have the same error in the logs :
"2014-03-03T09:40:38.585-05:00 [04660 info 'Default'] Registry Item DB 5 value is '50'
2014-03-03T09:40:38.585-05:00 [04660 info 'Default'] [VpxdVdb::SetDBType] Logging in to DSN: SQL Server Native Client 10.0 with username vcenteruser
2014-03-03T09:40:38.585-05:00 [04660 error 'Default'] [VpxdVdb::SetDBType]: Database error: ODBC error: (IM002) - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2014-03-03T09:40:38.585-05:00 [04660 error 'Default'] Error getting configuration info from the database
2014-03-03T09:40:38.585-05:00 [04660 warning 'Default'] [VpxUnhandledException] Win32 Exception (0xe06d7363) detected at 7FEFCDC940D"
Is there any other way I could force vCenter to use the right System DSN?
Thank you
i'am confused. didn't you told you moved to 2012 Database? so theirefore you have to use the correct odbc driver for that.
SQL Server Native Client 11.0
Please create it with this Native Client and test the ODBC Connections.
thx
Max
Sorry I forgot to say that I used the SQL Server Native Client 11.0 to recreate the System DSN.
I deleted both System DSN and retry to start the service : same error.
Could it be an issue in the registry? Here is the key that was changed :
HKLM\SOFTWARE\VMware, Inc.\VMware VirtualCenter
- DbInstanceName : sqlserver\sqlinstance
- DbServerType : Custom
HKLM\SOFTWARE\VMware, Inc.\VMware VirtualCenter\DB
- 1 : SQL Server Native Client 11.0
- 2 : domain\user
Thank you.
I finally did it.
The key 1 in HKLM\SOFTWARE\VMware, Inc.\VMware VirtualCenter\DB needs to have the same name as provided in the DSN settings, and not the type of driver used.
I used VMware vCenter as the name of the ODBC connection so I had to provide the same name in the registry and the service started
Thanks for you help Madmax01!
I am also having issues moving my local SQL Express 2008 on Windows 2008r2 to a remote SQL Full 2012 on Windows 2012. I would like to install the SQL Server Native Client 11.0, but cannot do so on my Windows 2008R2 server. Am I missing something?
Hello DDuwe,
Did you install the ODBC driver? Check over here : http://www.microsoft.com/en-us/download/details.aspx?id=36434
After installing the ODBC driver you should be able to configure the DSN.
Regards,
This is totally my bad. I reversed my 32 and 64 bit versions. I just installed it with no problem. Thank you for the response. Sorry about the mistake.