THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

SQL Client config, 32 and 64 bit

Say you want to change the preferred netlib connection order. Or add a server alias.

You can do this using the "SQL Server Configuration Manager" program. But installing this on each client machine where you want to do the modification might not feel that attractive.

Another option is to use a tool like regmon while doing the config on a reference machine, sniff the registry modifications and then shoot these out to the client machines. This might be overkill, though.

Yet another option is to use the cliconfg.exe tool, which ship with Windows. This tool is already available on your machine. However, on a 64 bit machine, you need to consider whether the client app is a 32 or 64 bit app. The processor architectore for that app will determine where in the registry the app (client libraries) will look. Below is my results from working on a x64 XP installation.
64 bit (native): HKLM\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib
32 bit (WOW): HKLM\SOFTWARE\WOW6432Node\Microsoft\MSSQLServer\Client\SuperSocketNetLib

Razvan Socol was kind enough to enlighten me, a while ago, of the fact that runnig the 64 bit version of cliconfg.exe will modify in the "64 bit" registry entry (as per above) and vice versa for the 32 bit version of cliconfg.exe. Razvan mentioned that starting cliconfg.exe from Run will start the 64 bit version, and from a 32 bit app (Explorer for instance - which I couldn't find how to do, but I'm sure somebody will enlighten me) will start the 32 bit version.

Above made me wonder in what folder each file is. Here are my findings (on the test machine I was using - a pretty clean XP x64 machine):

64 bit version of cliconfg.exe: C:\Windows\System32
32 bit version of cliconfg.exe: C:\Windows\SysWOW64

(And, before you ask, no, above is not a typo. There is some logic behind this. :-) )

Published Tuesday, September 08, 2009 2:04 PM by TiborKaraszi

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Kourosh said:

I have problem connecting to sql server client on 64-bit windows

January 28, 2013 11:04 PM
 

Steve Dybing said:

Thanks Tibor, saved me a lot of trouble today looking for a way to set a 32-bit alias. :-)

June 6, 2014 4:13 PM
 

TiborKaraszi said:

Hi Steve! Cool, glad you found it useful. I sort of forgot about this blog post. Just for the heck of it (for other readers potential benefit) here are the paths for the two cliconfig.exe, as I found on my win 8.0 machine:

62 bit: C:\Windows\System32\cliconfg.exe

32 bit: C:\Windows\SysWOW64\cliconfg.exe

June 9, 2014 3:39 PM
 

Dave said:

Thanks sooooo much for this, have been frustrated ever since I got Win 7. Interestingly typing opening cliconfg in RUN was opening the 32 bit version for me, so I had to use your location to go find the 64 bit version.

August 19, 2014 6:50 AM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement