2

Is it possible to change the content database of a site from a machine name to a SQL alias in SharePoint 2013?

The SharePoint admin content database is correctly configured. But I have a site(s) that is incorrectly configured using a machine name instead of an SQL alias.

Is it as simple as "Remove Content Database" then add content database using the SQL alias?

1 Answer 1

1

No actually. When you add an SQL Alias to your server hosting Central Admin, you need to move ALL the databases to the new storage (provided that they are using the same database server)

The SQL Alias has nothing to do with the SQL Sever. It is a server feature where you point all your application to a different SQL Server. Not just SharePoint. What yoo do is that you tell the Server OS that MyOldDBServer from now on is located at MyNewDBServer. You don't have to change anything within applications; SharePoint or any other. SharePoint and other apps, still belive that they are communicating with MyOldDBServer.

Try the following CMD command on your computer:

  • Run CLICONFG (on windows 7)
  • Start Screen type CLICONFG (on Windows 8)

And you see this dialogue:

enter image description here

And you add the alias on the Alias tab:

enter image description here

That's it!

Well almost, backup the databases and then you have to shut down SharePoint through the action of disable services and stop the ISS before adding your SQL Alias. But that part you already know. If not - follow Todds blgg Moving SharePoint to a different SQL server.

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.