October 23, 2005 at 9:04 pm
I have just installed Reporting Services and after it completed the Install I got an error that says "Failed to start the report server, you must manually start the report server".
So, the question is, how do I start the report Server manually? Why did I get this error in the first place?
October 24, 2005 at 8:20 am
Its a known issue, the only problem with the Reporting Services installation is that it did not activate properly at the end of the setup process.
To manually activate Reporting Services, do the following:
In Command window, type the following on C drive root and then press ENTER:
cd \Program Files\Microsoft SQL Server\80\Tools\binn
Type the following on one line, where {username} and {password} represent a login account that has administrative rights, and then press ENTER:
RSActivate –c "c:\Program Fields\Microsoft SQL
Server\MSSQL\Reporting Services\Report
Server\RSReportServer.config" –u {username} –p {password}
The RSActivate utility program will attempt to activate the Reporting Services installation specified by the RSReportServer.config file.
October 24, 2005 at 5:08 pm
Ok. I did that and that worked. Now when I try to access the report manager i get the following error;
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
October 25, 2005 at 8:08 am
Check, and if not, manually grant impersonate privilege to ASPNET user by following this:
In administrative tools, click security settings, click local policies and click user right assignment. In the right pane, double click "Impersonate a client after authentication". Make sure ASPNET user is there, if not, use "Add" to add it. Then, click Ok to exit.
Then, you might need to restart IIS.
I hope you have already registered ASP.NET, if not, or you might need to re-register ASP.NET since you reconfigure RS. Follow these steps:
From a command prompt, run "..\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i "
(Note: You might have different version than v1.1.4322, use the latest here)
Hope this will help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply