The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Thursday, March 28, 2024 Login
Public

Client Network Utility 2/15/2011 10:14:02 AM

Always thought this wasn't available unless client tools were installed, but that is not correct.

Found a great post here on the client network utility, http://www.mssqltips.com/tip.asp?tip=1620 but what surprised me was this part,

"If you haven't installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility. This has come installed automatically on every operating system from Windows 2000 on. To bring up the utility, click on Start, then Run, and run cliconfg.exe."

No sense rehasing such a great tip, but at least I'll have a place holder on my blog for cliconfg.exe; especially for those pesky vendors that tell you they can use a named instance, but then after you do all the paper work to open the ports on the firewall wait for the monthly change window and then the vendor on site (at our expense).... "well we can use a name instance, but we can't specify a port number" !  doh !  They have to have the slash \ ; which i don't want to open port resolution with the firewall...

Client network utility to the rescue;

1.  Client network utility does not require sql client tools to be installed.

2.  Just because sql client tools is not installed, does not mean an alias does not exist on a server.

 


Blog Home