Take the 2-minute tour ×  I need to configure SQL Server aliases
on a public-facing production server. To do that, I need to
install SQL Server Configuration Manager.  I was not able to
find a standalone installer for that, so I am having to install
SQL Server 2005 Client Components. This approach is not ideal as
we don't want to have SSMS on an public-facing production
server.  Is there a way to install SQL Server 2005 Configuration
Manager without installing SQL Server Management Studio?  EDIT:
Found a way. See my answer below.   share|improve this question
add comment  2 Answers  up vote 2 down vote accepted  I've found
a way to configure aliases that doesn't involve installing
client tools on the production server.  Aliases can be setup
using SQL Server Client Network Utility (cliconfg.exe) as
described in this article: How to setup and use a SQL Server
alias  This utility is part of a standard install since Windows
2000 Server and I can confirm that it worked for me on Windows
2008 Server R1 (64-bit).  s