SQL Server 2005 Report Service does not start issue

Source: Internet
Author: User
Tags command line sql access

Since the SQL2005 BETA2 version was previously installed and later mounted on the SQL2005 official edition, the report service could not be started and the following information was reported when using the URL address http://localhost/reportserver access:

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
****SQL Server does not exist or access denied.****

After diagnosis, this problem can be resolved by the command line as follows:

rsconfig -c -s 机器名 -a sql -p SQL用户名(如sa) -u SQL用户名密码(如sa) -d 你的
报表服务器数据库名(如reportserver)

Of course, if your SQLSERVER2005 is not a hybrid validation, you can change the parameters above, such as

rsconfig -c -s 机器名 -a windows -p win用户名(如myserveradministrator) -u
用户名密码(如123) -d 你的报表服务器数据库名(如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:

报表服务器 Windows 服务“ReportServer”未运行。必须运行该服务才能使用报表服务器。
(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 failed to start.



Related Article

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.