Hi All,
My Report Server works find but after apply SQL Server 2005 Service Pack2. I can't connect to ReportServer Database. When Trying to connect from SQL Server Management Studio i get following Page.
TITLE: Connect to Server
Cannot connect to VISTA.
ADDITIONAL INFORMATION:
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.3054.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<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![[:#]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vwcjYin2KkPef-6Vsd-UAJL4QoAtUa4TU2Y8dKDTqr51vEV161RmXvRMODEf3wJcpFCUqUqrLwEoL5axkXzZNks_Nj1W3pWiYwpz0BGwGJyXp22Kcw0ZfcLnyJrt0wvlVMGATUZD_H2f0ggoYhurL4ZLmxomz0Bw=s0-d)
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color
</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. The logon failed. (rsReportServerDatabaseLogonFailed) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDatabaseLogonFailed&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00" target="_blank">Get Online Help</a></li><ul>
<li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</ul>
</body>
--. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
Colud anyone help me to resolve this issue please?
Thank you very much.
Regards,
Balwant Patel
Try using the Reporting Services Configuration Utility (Database tab) to generate a database script and apply this script manually to your ReportServer database.|||Did you just put on SP2? I had the same error very shortly after I put either SP2 or a hotfix (can't remember which), and it was fixed after a complete system restart and hasn't returned.
|||Make sure that the Service Accoutn the Reporting Server is running under has appropiate permissions to access the Report Server Database.Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
Hi Teo,
Thank you very much for your response... I tried with Database script but it doesn't work.
Regards,
Balwant Patel.
|||Hi gnieboer,
Thank you very much for response...I also restarted my system after apply SQL Server 2005 SP2 but I can't get rid of the problem.
Regards,
Balwant Patel
|||Hi Suessmeyer,
I check permission on Report Server Database...It is fine
Regards,
Balwant Patel
|||Which account has been granted access to the Report Server database, the ReportService Account (Windows Service) or the ASP_Net Worker process ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Hi suessmeyer,
I m using Windows Service Account
Regards,
Balwant Patel
|||Make sure that the the ASPNET account is a member of the SQLServer2005ReportingServicesWebServiceUser$<computername> $MSSQLSERVER Windows group and NT Authority\System is a member of the SQLServer2005ReportServerUser$<computername>$MSSQLSERVER group.|||Hi Teo,
Yes, ASPNET Account & Authority\System are members of above groups...
I dont know what's the problem with it...
Regards,
Balwant Patel.
