I'm in the process of mirroring the SQL Server back-ends, but I've had a helluva time trying to find the code/procedure for making the web front-end (SP 2013) aware of the SQL Mirroring.

I've recently been handed SharePoint for administration, so I'm pretty much a total new when it comes to SharePoint. Thanks in advance for any help or direction you can provide.

  • What is your current configuration, how you connected with your SQL server from SharePoint( via ALias or server name)? are you going to mirroring or Always-ON?
    – Waqas Sarwar MVP
    Nov 16, 2016 at 19:17
  • We've connected via the server name and it is mirroring, no AO/AG.
    – AKDiscer
    Nov 16, 2016 at 19:24
  • after configuring mirroring, will you create an alias which will point to Mirror or something else...i am little behind on mirror so that's why i asked
    – Waqas Sarwar MVP
    Nov 16, 2016 at 19:27
  • I thought there was a way to configure the WFE through PowerShell or the Central Admin to be aware of both the SQL Servers and the databases that are in the mirrored pair?
    – AKDiscer
    Nov 16, 2016 at 19:55

2 Answers 2


In order to tell sharepoint mirroring, you have to create an alias on the server.

  • Use "C:\Windows\System32\cliconfg.exe" (on all servers in the farm
  • Create an alias with the same name as you are using in the SharePoint( server name) and point it your Mirroring servers.

Check this one for more info or use this one


I found the following after changing my search string in Google for the 7th time!

Make SharePoint Mirroring Aware

@Waqas - Do I still need to create the alias you listed after performing the steps in the aforementioned link?

Your Answer

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

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