Join 2,575 other subscribers
My ramblings on the stuff that holds it all together
It’s well documented that if you want to install vCenter on an x64 Windows 2008 OS you need to create a 32-bit DSN rather than he normal x64 DSN, Jason has a post on this over at his site.
However – on a clean install of Windows 2008 R2 x64 you don’t get the drivers for the SQL Native Client out of the box so whatever you do, you can’t create a compatible DSN
If you have a separate VC server from the SQL server you need to install the SQL native client on your VC server otherwise it won’t work.
You can download it from this page as part of the SQL 2008 Feature pack; the direct download links are below
Microsoft SQL Server 2008 Native Client
You can then install this package on your vCenter server
You can then follow the steps in Jason’s post to run odbcad32.exe and configure a 32-bit DSN
Scroll to the end and select SQL Native Client (not “SQL Server”) and configure the client as required (remember to change the default database setting to the vCenter DB you created (see install guide)
Then restart the vCenter installation process and you will be able to select the DSN you created