unsupported DSN entry detected. The ‘SQL Native Client’ driver must be used for databases SQL Server 2005 and later


Symtom: When you try to install VMware Site recovery, it will prompt an error “unsupported DSN entry detected. The ‘SQL Native Client’ driver must be used for databases SQL Server 2005 and later” while configuring in the DSN option.

System config:

OS: Win2008R2 64bit

Solution: Check in the registry entry

HKLM/Software/Wow6432Node/ODBC/ODBC.INI/ODBC DATA SOURCES
Keys are:
(default) REG-SZ(value not set)
vCenterUpdateMgr REG-SZ SQL Server

HKLM/Software/Wow6432Node/ODBC/ODBC.INI/vCenterUpdateMgr
Keys are:
(default) REG-SZ (value not set)
Database REG-SZ vCenterUpdateManager
Server REG-SZ (local)
Trusted_Connection REG-SZ Yes
Driver REG-SZ C:\Windows\system32\sqlncli10.dll

Also install the sql client driver before modifying the registry

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/sqlncli_x64.msi

Ref:  http://www.yellow-bricks.com/2010/07/15/32-bit-odbc-dsn-for-vum-4-1/#comment-9174

 

 

 

 

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: