To start working with the management side of SQL Server Reporting Services 2008, I decided to set up a report server and report manager. Unfortunately, I made a mistake while setting up my configuration that left me a little perplexed. Here are the steps I took to cause, track down, and solve the issue.
Problem:
I began by opening the Reporting Services Configuration Manager from the Start Menu. I clicked through each of the menu options and accepted the defaults for any question with a warning symbol, since warning symbol typically designate an action item. After two minutes, all of the warning symbols had disappeared, and I was ready to begin managing my report server. Unfortunately, opening up a browser and trying to open up the report manager resulted in the dreaded "The report server has encountered a configuration error. (rsServerConfigurationError)" message.
Sherlock-ing it:
I put on my sleuthing hat and went to the log file directory: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles. Under the latest ReportServerService*.log, there was the following error: "Message: No DSN present in configuration file". Looking at the file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config proved the error message true, as right at the top of my log file was the empty Dsn tag.
Looking in Books Online under the RSReportServer Configuration article, I discovered that the Dsn property contains a connection to the report server database. That's odd, I don't remember creating that connection...
Solution:
I returned to the scene of the crime, the Configuration Manager. Sure enough, the third warning-less menu option allows you to set up the connection to either an existing report server database or create a new one for this instance. I filled in the appropriate information, and took a look back at the configuration file. This time, the Dsn tag contains a beautifully encrypted blob of information. The report manager works, and I am ready to manage my reports! The moral of this story is to read the directions before clicking through configuration managers, don't trust warning icons or lack thereof, and don't forget that Reporting Services needs to know what database to use. :)
Version: SQL Server 2008 RC0
Problem:
I began by opening the Reporting Services Configuration Manager from the Start Menu. I clicked through each of the menu options and accepted the defaults for any question with a warning symbol, since warning symbol typically designate an action item. After two minutes, all of the warning symbols had disappeared, and I was ready to begin managing my report server. Unfortunately, opening up a browser and trying to open up the report manager resulted in the dreaded "The report server has encountered a configuration error. (rsServerConfigurationError)" message.
Sherlock-ing it:
I put on my sleuthing hat and went to the log file directory: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles. Under the latest ReportServerService*.log, there was the following error: "Message: No DSN present in configuration file". Looking at the file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config proved the error message true, as right at the top of my log file was the empty Dsn tag.
Looking in Books Online under the RSReportServer Configuration article, I discovered that the Dsn property contains a connection to the report server database. That's odd, I don't remember creating that connection...
Solution:
I returned to the scene of the crime, the Configuration Manager. Sure enough, the third warning-less menu option allows you to set up the connection to either an existing report server database or create a new one for this instance. I filled in the appropriate information, and took a look back at the configuration file. This time, the Dsn tag contains a beautifully encrypted blob of information. The report manager works, and I am ready to manage my reports! The moral of this story is to read the directions before clicking through configuration managers, don't trust warning icons or lack thereof, and don't forget that Reporting Services needs to know what database to use. :)
Version: SQL Server 2008 RC0
Comments
Thanks again.
I went to the SQL Server Configuration Manager on the Server and found the Reporting Services and on the 'Log On' tab the accounts has a grayed out button stating 'Not Installed'. I stopped the services for Reporting Services in hopes this would un-gray the button, but no luck. Help! :)
I think we may be talking about different programs, as the configuration manager doesn't have a Log On tab. You can find the Configuration Manager by going to your Start Menu > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager.
Hope that helps,
Jessica
This is really helpful. I found it at last on this blog.
Thanks,
Tejas Shah
www.SQLYoga.com
I am working on sqlserver reporting services 2008. I m getting a reporting services Login screen Problem when i m deploying a report. and after inserting username and password then it appear again and again.
if anyone know the solution please reply
Thanks a lot
I just did an reinstall of SQL Server Reporting Services 2008 and am getting the same error as Anon above when trying to hit the report server page from the report server "The report server has encountered a configuration error. (rsServerConfigurationError)"
Trying to hit this page from any other server repeatedly prompts me for a username and password.
Looking in the ReportServer Logfile though I see the following error:
************************
runningjobs!ReportServer_0-5!1984!11/19/2009-08:41:09:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
runningjobs!ReportServer_0-5!1984!11/19/2009-08:41:09:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
library!ReportServer_0-5!1984!11/19/2009-08:41:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
library!ReportServer_0-5!4b4!11/19/2009-08:41:10:: Unhandled exception was caught: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER_0-5-129031152285275000. No corrective action is required. An error code has been submitted to ASP.NET to release the connection. The error code is 800708CA. ---> System.Runtime.InteropServices.COMException (0x800708CA): This network connection does not exist. (Exception from HRESULT: 0x800708CA)
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.GetAuthType()
at ReportingServicesHttpRuntime.RsWorkerRequest.GetUserToken()
--- End of inner exception stack trace ---
at ReportingServicesHttpRuntime.BaseWorkerRequest.FilterAndThrowException(Exception e, String message)
at ReportingServicesHttpRuntime.RsWorkerRequest.GetUserToken()
at System.Web.HttpContext.get_ClientIdentityToken()
at System.Web.HttpContext.get_ImpersonationToken()
at System.Web.ClientImpersonationContext.Start(HttpContext context, Boolean throwOnError)
at System.Web.HttpApplication.ThreadContext.SetImpersonationContext()
at System.Web.HttpApplication.ThreadContext.Enter(Boolean setImpersonationContext)
at System.Web.HttpApplication.OnThreadEnterPrivate(Boolean setImpersonationContext)
at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
************************
Currently there are no Application event logs popping up.
This server used to be part of a farm. It was originally working until I started playing with uninstalling/reinstalling some msp files to fix another problem. Since then I've uninstalled reporting services and MOSS, and done the reinstall according to this page:
http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html#Step-6:-Installation-of-SQL-Server-Reporting-Services-2008-Add-In
I'm currently stumped at step 3.6 - Step 6: Installation of SQL Server Reporting Services 2008 Add in.
I installed the Add-in to see if that would make a diff but no go.
Currently I am running WSS and MOSS SP2 and Reporting Services 10.0.2734.0 Enterprise. (According to the Reporting Services Configuration Mgr Startup screen)
I think I'm looking for ideas on how else to diagnose this problem or if I'm lucky a solution. I've been banging my head against this for a couple days now. Any help is appreciated.
Dale
http://technet.microsoft.com/en-us/library/ms159704.aspx
On the computer that hosts the report server, continue to run the Report Server service as NetworkService and add the built-in account, such as NT_AUTHORITY\NetworkService to the WSS_WPG Windows group.
Once we added the NT_AUTHORITY\NetworkService account to wss_wpg, the report website started working on the report server. There are still some other things we need to cleanup but at least we're on the right path.
I linked to it from my small blog where a coworker and I post issues we've run into. I hope that's okay, if not, please let me know.
My Link to your post
I'm so glad I could help, and linking to the post is perfectly fine by me!
Jessica
Eric
If I go under SQL Server Configuration Manager I just get a list of the services and protocols etc. Not sure where this 3rd screen is you speak of.
Any help would be appreciated. Thanks!
Be sure that you have full admin access when running the Reporting Services Configuration Manager. I've seen odd behavior when you only have read access.
HTH,
Jessica
KarthikShanth
Save me lots time, You are Sherlock re-incarnate.
I cant beleive this is the only article of its kind. I struggled to find any other. Also that M$ failed to point out this seemingly obvious place to look too.
Jude
John
India's business landscape is undergoing a rapid digital transformation. Companies are adopting digital transformation services to optimize operations, enhance customer experience and gain a competitive edge. These services encompass a wide range of solutions ranging from cloud migration and data analytics to mobile app development and automation.