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

I have tried moving all databases to another server, but I forgot to change the default database server in Central Administration.

From Googling it, I found out that stsadm or psconfig could help me out here, but I can not figure out how to do this.

I was thinking, "What would happen if I ran the Configuration Wizard, detached from the farm, and then reattached to the existing farm?" Wouldn't that just sort it out for me?

share|improve this question
up vote 4 down vote accepted

Here are the instructions for moving the databases for:

Also, it is a Best Practice to use SQL Aliases when referencing any instance of SQL server from a SharePoint farm. Doing so makes all future database moves a great deal easier.

share|improve this answer

It might get you connected to the Config database on the new server, but all the other databases would still be wrong.

The technet article Move all databases (SharePoint Server 2010) suggests that you create an SQL alias pointing to the new database server after making sure you got permissions set up correctly

share|improve this answer
Thanks, i will get the dba to sort this out. – Alexander May 22 '12 at 18:51

SQL 2012 brings a new option to the table regarding SQL Aliases for SP2010 & SP2013. If you are using Always-on Availabily Groups (AP) in SQL 2013, you get a SQL listener that does the same function as as the SQL Alaise. AG gives you automatic db failover for your Sp farm. Issue is if you use AG with a SQL alaise you have a single poing of failure so your DB won't automatically failover.

So the big reason to use SQL Aliases for me in the past was to allow me to split my database servers when 1 became the bottleneck. The goodness with AG outweighs this option to improve performance especially as if i'm using AG I probably have suffliecient resources as this is planned upfront.

share|improve this answer
in what way does this specifically address the OP regarding running the SP Configuration Wizard? – RJ Cuthbertson Jan 11 '13 at 14:51

Your Answer


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.