Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks,
Arnold

share|improve this question

2 Answers 2

Yes, its true, you need client tools to access this console. Obviously if you don't have SSMS running locally, then you have another computer that has the client tools running that can access the database server.

You can either use the computer management console from the computer with SSMS to connect to your SQL Server box as described here or, there is a lesser known method to get access to this from within SSMS:

  1. Register the server in the registered servers console
  2. Right-click on registered server and click SQL Server Configuration Manager...

alt text

The tool is actually a mmc snap-in called SQLServerManager.msc, although I don't think it's portable enough to simply copy to a box to run stand alone.

share|improve this answer
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).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.