SQL2005 Report Service does not start problem summary report

Source: Internet
Author: User
Tags command line config key sql string version domain access
sql2005| problem

SQL2005 Report service cannot be started problem summary report

The report service could not be started because the SQL2005 BETA2 version was previously installed and later mounted on the SQL2005 official edition
The following information is reported using the URL address http://localhost/reportserver access:
The server cannot open a connection to the server database. A connection to the "database is" required for all requests and processing. (rsreportserverdatabaseunavailable) Get Online Help
SQL Server does not exist or access denied.****
After diagnosis, this problem can be resolved by the command line as follows:
RSCONFIG-C-S machine name-a sql-p SQL user name (such as SA)-U SQL username password (for example, SA)-D your report server database name (such as ReportServer)
Of course, if your SQLSERVER2005 is not a hybrid validation, you can change the parameters above, such as
RSCONFIG-C-S machine name-a windows-p win username (such as myserver\administrator)-u username password (such as 123)-D your report server database name (for example, ReportServer)

In this way, if the above command does not report an error, you should not be able to connect to the SQL Server database problem by Http://localhost/reportserver access.

However, my visit through Http://localhost/reportserver is, reporting the following information:
The Report Server Windows service "ReportServer" is not running. You must run the service to use the report server. (rsreportserverserviceunavailable)

Really injustice, then I will start the report service, but when the start of the error, said it does not open up, I go to the incident to see, this does not play me?
I went to the incident to see, I found 3 big Red Fork, the contents are as follows:
Red Fork 1:
The Remote Procedure Call (RPC) service is failed to start.
Red Fork 2:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user name or group name "LocalSystem" is not recognized.
At Microsoft.ReportingServices.Library.Native.NameToSid (String name)
At Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer (Boolean firsttime)
At Microsoft.ReportingServices.Library.ServiceAppDomainController.Start (Boolean firsttime)
At Microsoft.ReportingServices.NTService.ReportService.OnStart (string[] args)
At System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback (Object State)
Red Fork 3:
The server cannot decrypt the symmetric key. Most likely, the service account or password has changed. To continue, run Rsconfig.exe to update the "Server account information.\r\n"

Red Fork 1 Momin wonderful, RPC service startup failure, this SQL2005 menopause put, obviously RPC service good Kai
Red Fork 2 reported more strange, nothing to do with this LocalSystem broken sign, I did not set you, unrecognized,
The Red Fork 3 unexpectedly provided a solution, said that wants me to use rsconfig.exe to try, how can the trick be so? Rsconfig.exe A total of only a few parameters, I have played hundreds of times, but also I play, will Ah, is a brain-crazy, do not know what to give a suggestion why, lead me astray Ah

However, Microsoft is very real, I put the Red Fork 2 of the content to Google, found that Microsoft's official website has the solution to the problem, the Web site is as follows:
Http://support.microsoft.com/kb/911846/en-us

The article is to the effect that:
This problem does exist, The reason for this is that the WebServiceAccount attribute in the RSReportServer.config file does not mean that it will use the account that the ASPNET uses when the attribute is not indicated, but the account currently used by ASPNET does not exist on the domain controller, by default this The account that ASPNET uses is supposed to be on a domain controller, such as using the IWAM_computername account
Hey, look at the above words is not blame I changed the use of the ASPNET account, so the report service can not start up, obviously shirking responsibility
Don't say much, look at Microsoft Solution put, in fact very simple, open RSReportServer.config file, this file is in the directory below:
Drive:\Program Files\Microsoft SQL Server\mssql.x\reporting Services\ReportManager
and find the sign below.
<WebServiceAccount></WebServiceAccount>
Change it to the following way:
<WebServiceAccount>IWAM_ComputerName</WebServiceAccount>
All right, save the disk.
Restart the report service, which lasted 3 hours, 16 minutes, 16 seconds, and the report service startup was finally successful.

But that does not mean that you can successfully access it, the following error occurred when I visited http://localhost/reportserver/:
The report server could not open a connection to the report server database. All requests and processing require a connection to the database. (rsreportserverdatabaseunavailable) Get online Help
Login failed for user ' crserver\iwam_crserver '.

This problem is reported to be very real, that is, the current user does not have access to the SQL Server database, the line, I set up a SQL login for this user
but found that the user can not build a login, meaning that it is not a domain account, hey, forgot to say, My time WIN2003 system, Microsoft above that article is about 2000 of the
good, anyway know the problem, first ASP.net run account to NT Authority\Local SERVICE, and then in the file in the
< webserviceaccount></webserviceaccount>  
Change to the following information
<webserviceaccount>nt AUTHORITY\LOCAL Service</webserviceaccount>
This should be right to put, but depressed is still wrong, the last error did not, the next error came out, as follows:
  The report server cannot decrypt the symmetric key used to access sensitive data or encrypted data in the report server database. You must restore the backup key or delete all encrypted content. For more information, consult the documentation. (rsreportserverdisabled) (rsrpcerror) Get the online Help
  incorrect data. (Exception from hresult:0x80090005)

God, who will save me now, how many brain cells I have died of suffocation, and discouraged ah, hard to write so much but eventually did not solve?
Not reconciled, and then toss one, remember SQL2005 have a report Configuration Manager, go inside to play
Found that there is an encrypted column, regardless of, it is not to say can not decrypt it, then I first delete it, delete succeeded, and then change a little bit to generate a new, OK
In the re-use http://localhost/reportserver visit, Shushi mad Ah, nothing wrong
The IE return interface is as follows:
Localhost/reportserver-/
--------------------------------------------------------------------------------
----------------------
Microsoft SQL Server Reporting Services version 9.00.1399.00

Done!



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.