Pointing SharePoint to a new instance of SQL without using an alias RRS feed

  • Question

  • Hello!

    I'm moving my MOSS2007 installation to a new SQL instance (all on the same server). I've already detached and moved the database tables to the new server, and I'm ready to point SharePoint to the new SQL instance.

    However, everything I've found on TechNet tells me to create an alias to the new SQL database and that seems more like a workaround than a solution. Isn'[t there some way to simple point sharepoint to the new SQL server?



    Wednesday, August 15, 2012 1:27 PM

All replies

  • It is a workaround and is the only solution other than rebuilding a new farm. Any other methods that may exist (I've heard of people modifying registry keys and updating database records) are unsupported.

    SharePoint ties itself to this first instance that is provided when creating the configuration database. You can't move the configuration database once the farm is created. Using an alias provides the benefit of not having to recreate the entire farm.

    The best approach if you do want to change instances for the entire farm is to do a full farm backup (aka catastrophic backup), create the new farm (that is run the configuration wizard), deploy customizations (i.e. solutions) and then restore the backup. This is not a fun process and has the nice side effect of being difficult to roll back unless you clone/ghost/snapshot (if a VM) the entire farm.

    Jason Warren
    Infrastructure Specialist

    Wednesday, August 15, 2012 4:27 PM
  • Hi,

    This is the only solution. After you change the aliases you need not change these entries in web.config files.

    However if you are using any custom tools those connect to DB with a config file with config entry then you need to change them as well.

    I hope this will help you out.

    Thanks, Rahul Rashu

    Wednesday, August 15, 2012 6:38 PM