Starting a Report Server in SQL Server 2005 Express

• PookaX

  Grasshopper

  Points: 23

  More actions

  May 26, 2009 at 1:17 pm

  #205275

  I am a fairly new SQL Server user and have generated some reports that I would like to share with my co-workers. I re-installed SQL server 2005 Express to include Report Server/Manager functionality and used default values (it does not install by default). When I open Reporting Services Configuration Manager, I seem to have Green Checks by most of the fields, but I can't seem to access Report Manager, Report Server, nor deploy reports. I think there is some disconnect and and I can't seem to access the Report Server or the Report Manager page. Can anyone tell a beginner how this should be set up, please?

  using the following URLs in a browser, I get:

  http://localhost/ReportServer --> Reporting Services Error: The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

  Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied.

  http://localhost/Reports$SQLExpress/Pages/Folder.aspx --> Error: The report server is not

  responding. Verify that the report server is running and can be accessed from this computer.

  This is the information from Reporting Services Configuration Manager

  Server Status: Instance Name: SQLEXPRESS, Instance ID: MSSQL.2 Initialized: Yes Service Status: Running

  Report Server Virtual Directory: Name: ReportServer$SQLExpress Website: Default

  Report Manager Virtual Directory: Name: Reports$SQLExpress Website: Default

  Windows Service Identity: Service Name: ReportServer$SQLEXPRESS Service Account: NTAuthority\NetworkService (Built-in Account: Network Service)

  Web Service Identity: (myPCname\ASPNET)

  Database Setup: Server Name: myPCname\SQLEXPRESS Database Name: ReportServer$SQLExpress Credentials Type: Service Credentials