Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login Failure due to Mirroring for Report Server Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 11:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:46 AM
Points: 67, Visits: 301
I have set up two SQL Server 2012 (Standard Edition) boxes running Report Server. I configured the two Servers (Server A and Server B) to be mirrored. All working just fine. I have failed over and failed back still everything working fine. What I have noticed that in the Server Log errors on Server B (mirror server) that I keep getting the error : "Login failed for user 'Service Login Account'. Reason: Failed to open the explicitly specified database 'ReportServer'. [CLIENT: <local machine>]." I can understand why this would happen as the Report Server is not available for connection but was wondering if this could somehow be turned off as it fills up the error log without any useful information. I tried stopping Report Server Services, while that stopped the error, it also dissconnected mirroring and I had to go back and start mirroring from scratch. I know mirroring for Report Server is a bit different than normal User databases but I would think there should be some way to mirror the Database without generating all these errors. Any insight or workaround would be greatly appreciated...

Thanks in Advance...



Post #1462290
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse