Report Server Connection Problem
Dear All,
I have a Problem in Connecting the Report server. I have 2 folders of Report that reports are working well and we are accessing the reports by URL through Report manager from the past 6 months
Yesterday we have a problem found that the reports are not displaying in the Report manager and it says a error :"The report server is not responding. Verify that the report server is running and can be accessed
from this computer ."
* I verified the Report manager
* I Checked the Services are running Properly.
* The reports can be able to run in the back end (Visual studio)
* I did not set any security credential to access the Reports.
But i could not able to connect the Report server. when i connect to report server by widows authentication mode the follwoing error message are displaying.
===================================
Cannot connect to sapserver.
===================================
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.4035.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.Global.get_SharePointIntegratedFlagFromCatalog()
at Microsoft.ReportingServices.WebServer.Global.RunOnlyOnceStartReportServer()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) <a
href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDatabaseUnavailable&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.4035.00"
target="_blank">Get Online Help</a></li><ul>
<li>Login failed for user 'USHAFIRE/Administrator'.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Dear all Please Kindly Reply favour,
Thanks,
Vasanthapraba.
June 14th, 2010 9:34am
One of the Error states SSRS is not able to access the Report Server DB.
Can you check wehther you are able to access the Report Server DB thru SSMS with the SSRS service account?
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2010 10:34am
Thanks for u r reply suresh,
I checked to access the SSRS through Sql Server Management Studio that time only i mentioned the above error occurs.
But i can view the Report Server database when I log in SSMS Database engine.
Any Idea..?
June 14th, 2010 11:10am
I understand that you are able to access the REport Server Db (Query some tables).
If so try this if you have not done already.
(1) Restart the Reporting Services.
(2) Using Report Configuration tool & remap the Report server dbs to the Report Servcies
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2010 12:03pm
I tried the these above two points but i could not get the solution yet.
I could not understand that Report server DB is there but why i could not able to log in. And i did not set any security credential then why i could not log in. i can able to configure the Report server but i can't access it When i try to access it by the
URL
Http://localhost/Reportserver
Error:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)
Get Online Help
Login failed for user 'USHAFIRE/Administrator'.
Http://localhost/Reports
Error:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
And all other services of SSMS like Analysis Services,Integration Services can be able to log in.
June 14th, 2010 1:02pm
I am bit confused. The error message clearly says that the account dont have access to the ReportServer dbs.
Can you pls confirm whether you are able to access the report server dbs with this account( pls query some table in this DBs).
Also pls ensure that the account has both "Public & RSExecRole" for these databases. You can check this in the server --> security--> Logins --> <LoginId>-->User mapping.
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2010 2:25pm
Dear Suresh,
I checked the Problem is Solved now.
Thanks alot ma.
June 14th, 2010 3:48pm
I have just experienced this problem on our production server that turned out to be some kind of disk corruption. We had a dead disk in a RAID 5 array. When it was replaced and rebuilt SSRS still didn't work, even after a restart of SQL Server, but did
work when the server was rebooted.DBA
Free Windows Admin Tool Kit Click here and download it now
March 8th, 2011 8:38pm
This topic is archived. No further replies will be accepted.
Other recent topics
