SharePoint 2010 Failover - Central Admin works but sites do not? RRS feed

  • Question

  • Hi, I use SP 2010.

    The DB Admin has properly configured mirroring.
    I have used powershell to add failover server to all appropriate databases in SharePoint.
    Now when I test by bringing my principal SQL server down, I can see the central admin is the only site that still works but other sites do not work.

    The ULS logs have entries like this:
    01/07/2013 16:44:58.84 OWSTIMER.EXE (0x148C)                   0x03BC SharePoint Foundation         Database                       85t4 High     An error occured while attempting to verify that the database is read only for database WSS_Content_MySites_FromSP2010. The error contained the following message: Cannot open database "WSS_Content_MySites_FromSP2010" requested by the login. The login failed.  Login failed for user 'Domain\svc-dv-dbfarm'. 50db787e-c99c-45d1-88d2-3e97b3d8d2a7

    Any clues?

    Thanks so much.

    • Edited by ran009 Tuesday, January 8, 2013 1:07 AM
    Tuesday, January 8, 2013 12:51 AM


  • Hi,

    have you created all user and given permission to your secondary database server as you given at your primary database server.

    Check for this account access and permission on both DB server.  Domain\svc-dv-dbfarm



    • Marked as answer by ran009 Tuesday, January 8, 2013 11:54 PM
    Tuesday, January 8, 2013 5:08 AM