Failing vcentre install because of 64 bit ODBC connection

[Bluemoon404]

I am trying to install VMware Vcentre 4.1 on my Windows 2008 R2 Ent server. VMware Vcentre needs a database to connect to during the install so I’m trying to connect to my Windows 2008 Sql R2 server where I have created the database. VMware Vcentre 4.1 only supports a 64 bit DSN. My install of VMware Vcentre 4.1 fails complaining there is no 64 bit DSN.

I have successfully created a System DSN to a database which I have created on my SQL 2008 R2 box but during my install of VMware Vcentre 4.1 it fails to detect any 64 bit DSN’s. The ODBC driver on my Windows 2008 R2 Ent server where I’m tying to install the VMware Vcentre 4.1 is SQL server 6.01.76t00.16385 sqlsrv32.dll dated 14/07/09.

Can anybody help with why my 2008 R2 which I believe to be a 64 bit server does not have a 64 bit SQL ODBC driver?

[vmroyale]

Hello.

Set up your 64-bit DSN to use the SQL Native Client driver. This is required.

Good Luck!

[Troy_Clavell · Accepted solution]

try the one below

http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409

found at

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&dis...

[golddiggie]

Did you install the SQL Native Client (had forgotten what it was specifically called) onto the vCenter Server (from the SQL install media)?? You need to have that specific driver/client set selected when building the DSN in order for it to work... If you didn't actually install that onto the vCenter Server, you'll need to (mount the SQL install ISO onto that VM and install it, assuming you're using a VM for the vCenter Server)...

Personally, I'm using VM's for both the SQL Server and vCenter Server in production environments. It makes a lot more sense to have the vCenter as a VM unless you're using it to control a LARGE cluster...

VMware VCP4

Consider awarding points for "helpful" and/or "correct" answers.