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.Manag
ement.UI.R
SClient)
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.ReportingService
s.Library.
ReportServ
erDatabase
Unavailabl
eException
: , Microsoft.ReportingService
s.Library.
ReportServ
erDatabase
Unavailabl
eException
: 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.SqlE
xception: 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!0
5/04/2018-
08:59:25::
e ERROR: Microsoft.SqlServer.Report
ingService
s2010.RSCo
nnection20
10+Missing
EndpointEx
ception: 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
Our community of experts have been thoroughly vetted for their expertise and industry experience.