SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Our network admin installed MOSS using the SQL Server address instead of using the SQL alias. How can we change this after the fact? We tried using a simple stsadm commmand to change server name but then MOSS CA would not open, stating Configuration DB unavailable.

There is no way in CA to change the SQL settings to an alias that I've found.

share|improve this question
up vote 3 down vote accepted

You can use the SQL alias tool (cliconfg.exe) on your server to just create an alias with the original servername, and then point it to the new one. This way SharePoint will not be aware of the changes, but will hapilly connect to the new server. Even if you don't want to change to a new server right away, you can still use it to introduce an alias - pointing to the same name if needed.

  • "Server Alias" -> OriginalServerNameUsedBySharePoint
  • "Server Name" -> NewServerNameToBeUsed

Just keep in mind that this alias will affect all SQL client related connections originating from this machine that used the original servername.

share|improve this answer
tx, Thomas. If you have a DBA like ours, not using the alias would be taboo in the long term so using the cliconfig was not an option. – Anonymous Nov 24 '09 at 18:20

Looks like the stsadm command to change server name is just very finicky;

stsadm -o renameserver -oldservername -newservername

We couldn't strip the port out the command line so rolled back the install and re-installed using the PSConfig command.

Moral of story, install MOSS with your alias first! ; )

share|improve this answer

Your Answer


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