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.