I recently got asked a few times about what DSN to use for 64-bit and 32-bit versions of SQL Server so I thought I’d write a post to get that cleared up. The answer is regardless of what version of SQL Server, whether it’s 32-bit or 64-bit, you should use a 64-bit DSN for vCenter Server’s database and a 32-bit DSN for vCenter Update Manager’s database. The DSNs only matter to the application that’s using it and does not care what version the database on the other end is.
|Application||Application Architecture||DSN Required|
|vCenter Server 4.1||64-bit||64-bit|
|vCenter Update Manager 4.1||32-bit||32-bit|