SQL Server Reporting Services Problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

SQL Server Reporting Services Problem

Author

Topic

jassimmunir
Starting Member

9 Posts

Posted - 2010-01-06 : 03:43:26

hi all
i have installe Sql server 2005 with Reporting Services.Reporting Services are running, but when i connect Reporting Services through sql server management studio and to try to exapnd "home" folder i get following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Response is not well-formed XML. (System.Web.Services)

------------------------------

Unexpected end of file has occurred. The following elements are not closed: faultstring, soap:Fault, soap:Body, soap:Envelope. Line 1, position 65537. (System.Xml)

And in Event Viewer i found following Error:
"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."

Please can any body tell me how to solve this problem..

Best Regards,
Jassim Munir

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-06 : 03:57:49

http://msdn.microsoft.com/en-us/library/aa337324.aspx

kishore_pen
Starting Member

49 Posts

Posted - 2010-01-06 : 04:47:23

check the URL: http://technotes.towardsjob.com/sql-server/troubleshooting-ssrs-error-the-report-server-is-not-responding/
you may get the solution

jassimmunir
Starting Member

9 Posts

Posted - 2010-01-07 : 01:29:39

quote:
Originally posted by kishore_pen

check the URL: http://technotes.towardsjob.com/sql-server/troubleshooting-ssrs-error-the-report-server-is-not-responding/
you may get the solution

thank you kishore_pen. i went through above article step by step. now when i reach to "Initialization" tab in "Reporting Services Configuration" i get following Error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)

Can any body tell me how to solve this issue now

Best Regards,
Jassim Munir

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-07 : 01:38:53

http://support.microsoft.com/kb/842421

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources