1

i am needing to rename my SharePoint farm SQL DB server i have been told that i would have to fully recreate the farm to rename the sql server.

i am needing to rename it to SQLSERVRE2 original naming being SQLSERVER

is there any other options?

Many thanks

Improve this question

2 Answers 2

Reset to default
2

Two things:

  1. have you set up the SQL Alias and used that to connect SQL
  2. or use the DNS alias or simply server name

If you use alias then its very simple to rename.I would shut down the sharepoint, rename the server and update the SQL alias on the servers and start the SharePoint, everything will be work.

If no Alias then you have to rebuild the farm because their is no supported way to update the config db connection string.

But still you have your Content DB and Serivces db their so once you rebuild the farm then you can attach old DBs to new farm.

http://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx

Improve this answer
1
  • yes i used run>cliconfg.exe to create a TCP/IP Alias pointing to the new sqlserver name and it running fine cheers.
    – Gordon
    Commented Jun 5, 2014 at 15:53
0

You can use the PowerShell command Rename-SPServer to rename SQL server.

Rename-SPServer -Identity "SQLSERVRE" -Name "SQLSERVRE2"

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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