1

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.

Improve this question
4
  • 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? Commented Nov 16, 2016 at 19:17
  • We've connected via the server name and it is mirroring, no AO/AG. Commented 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 Commented 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? Commented Nov 16, 2016 at 19:55

2 Answers 2

Reset to default
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

Improve this answer
0

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?

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.