Building Block SQL mirror failover - Event ID:13397
I have installed EV building block set up for MBX and FSA using EV 10.04 on Server 2008 R2 and SQL server 2008. The solution spread across two sites with 3 x EV and a SQL servers in PRI and 3 x EV servers and a SQL server in DR. We have set up database mirrorring bewteen PRI and DR. Each server is using its Alias including SQL servers.
evSQLServer -> sqlserver1.myDomain.com
evserver1 -> myevserver1.myDomain.com
evserver2 -> myevserver2.myDomain.com
TEST 1 -- We failover the SQL server using SQL Manager by making the mirrored copy the PRI copy, change the Alias of evSQLServer -> sqlserver2.myDomain.com, change DNS alias for EV servers (as above) and run USL. USL completed successfully.The below error is noticed on every active EV server priodically.
The connection 'Provider=SQLOLEDB;Server=A-SANIA;Database=EVVSGLASVSG01_1_1;Integrated Security=SSPI' was lost and the system is waiting to reconnect (Thread Id: 8852)
Server=A-SANIA [actual name of PROD SQL server].
When user access the Mailbox archives (VV & VC enabled), archive search and item recall is works OK. When user access the FSA archives, the items either remain in the initialising state (fails eventually) OR error appears saying the file can not be opened. I have notied RPC server not available errors for storage service under EV FSA windows event viewer.
TEST 2 -- Then I failed back the SQL mirrorring to PROD, leaving both the active EV servers in DR, restart the EV services on all active EV servers and accessed File system archives, same failure as above. Mailbox archives works with NO issues.
TEST 3 -- With SQL remain in PROD, I brought back EV FSA only, leaving EV MBX server in DR . Restart the EV services on all active EV servers, access File system archives, all works with no issues.
TEST 4 -- What I have NOT tested is keeping both EV and FSA in PROD with Failover SQL mirrorring (to DR).
I am slightly confused where does the problem lie..on DR SQL box or DR EV FSA server?
Any suggestions and hints are highly appreciated...