VMware Cloud Community
frcouture
Enthusiast
Enthusiast
Jump to solution

Move vCenter database

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.

Reply
0 Kudos
1 Solution

Accepted Solutions
frcouture
Enthusiast
Enthusiast
Jump to solution

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 Smiley Wink

Thanks for you help Madmax01!

View solution in original post

Reply
0 Kudos
8 Replies
Madmax01
Expert
Expert
Jump to solution

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 Smiley Wink.

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

frcouture
Enthusiast
Enthusiast
Jump to solution

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

Reply
0 Kudos
Madmax01
Expert
Expert
Jump to solution

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

Reply
0 Kudos
frcouture
Enthusiast
Enthusiast
Jump to solution

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.

Reply
0 Kudos
frcouture
Enthusiast
Enthusiast
Jump to solution

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 Smiley Wink

Thanks for you help Madmax01!

Reply
0 Kudos
DDuwe
Contributor
Contributor
Jump to solution

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?

Reply
0 Kudos
frcouture
Enthusiast
Enthusiast
Jump to solution

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,

Reply
0 Kudos
DDuwe
Contributor
Contributor
Jump to solution

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.

Reply
0 Kudos