troubleshooting Question

Unable to access Report Manager page URL

Avatar of Kenny Placido
Kenny Placido asked on
Microsoft SQL ServerDB Reporting ToolsSSRSSQL
1 Comment1 Solution455 ViewsLast Modified:
User come up to me this morning and told me that he can access http://server/ReportManager. When you got the webpage, you get the following error
The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version

I logged into the server and tried to access the reporting services from SSRS and get the error below:
Unable to connect to the server at Server. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)


I tried the following to fix:
1)      Reboot – didn’t do anything
2)      Restart services – did nothing
3)      Log files showed an error: library!DefaultDomain!5ac!05/04/2018-08:43:12:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "Report_Server" requested by the login. The login failed. Login failed for user 'Domain\ssrs'.
      a.      I fixed this by using password to XXX123 and it worked. The Error went away but I still can’t get to the page.
4)      After a reboot, I now get this error in the logfile
      a.      ui!ReportManager_0-2!5f4!05/04/2018-08:59:25:: e ERROR: Microsoft.SqlServer.ReportingServices2010.RSConnection2010+MissingEndpointException: The attempt to connect
      to the report server failed.  Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP
      status 404: Not Found.
      b.      I looked up the issues and it mentioned about adding the URL to URLRoot and ReportServerURL in the rsreportserver.config. I made both the changes but still get the same
      error. I changed the rsreporting.config back to its original config.

At this time, I’m stumped on how to fix this. The server does not have IIS so even if i made the changes the rsreporting config, I can not restart the app pool. Not sure what to do.

Server:
Windows 2012 R2
SQL 2014
ASKER CERTIFIED SOLUTION
Kenny PlacidoSr System Administrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros