AnsweredAssumed Answered

How Do I Use SQL Mirroring in ArcGIS?

Question asked by evtinker on May 1, 2017
Latest reply on Jul 4, 2017 by KMcFarlandesri-ireland-ie-esridist

I am trying to setup a "highly available" ArcGIS database in Microsoft SQL.  I created an 10.3.1 enterprise database on the principal server, populated it with data, and then followed the standard SQL procedures to setup the mirror and witness copies on two other servers.  MSSQL is reporting everything working correctly.  I then setup this connection in ArcCatalog:

 

 

For testing purposes, w63-hydra-m is my principal server and w63-hydra is the mirror server.  The mirrored database is DevTest.

 

With this connection as long as the principal server is up, everything works perfectly.  If the SQL service on principal server is stopped, the connection fails.  If the SQL service on the principal is then restarted, the connect still doesn't work.  The only method I have found to get the connection working again is to stop and restart the service on the mirror so the orignal server is again shown as the principal, then close and reopen ArcCatalog.  This is not exactly a highly available connection.  Obviously I must have done something wrong here.  So what is it?

Outcomes