Is Report Manager a myth?

I've never been able to get to it. I must admit my first few attempts were before I had properly configured Reporting Services. But after two fresh installs, including a fresh OS install (64 bit Vista Ultimate) I still can't get to Report Manager. The closest I've been able to come is this error message:

Error

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

The service is running and I'm on my local computer which I have admin rights. I'm stumped.

There may be some special things you need to do to see Report Manager on Windows Vista.

Did you try seeing if the virtual directory was created in IIS?

Can you see other web sites on this machine? It could be a Windows firewall or name resolution issue.

Here is a posting on installing with Vista.

http://www.jameskovacs.com/blog/ReportingServicesOnWindowsVista.aspx

Here is another thread with a similar issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=150192&SiteID=1

cheers,

Andrew

|||

Thanks. I'd installed all the IIS componets as per the blog suggestion, I've installed all the SQL Server SP's I can find. I've put both Report Server and Report Manager in the Classic .NET AppPool. The ASP .Net Service Account is "NT Authority\NetworkService". My Windows Service Account is "Local System".

My Log contains the following:

ReportingServicesService!servicecontroller!5!5/8/2007-09:52:25:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
ReportingServicesService!servicecontroller!9!5/8/2007-09:52:25:: i INFO: Recycling the service from default domain
ReportingServicesService!library!f!5/8/2007-09:52:25:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!servicecontroller!9!5/8/2007-09:52:26:: i INFO: New app domain started
ReportingServicesService!crypto!f!5/8/2007-09:53:18:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!f!5/8/2007-09:53:18:: i INFO: Exporting public key
ReportingServicesService!crypto!f!5/8/2007-09:53:18:: i INFO: Performing sku validation
ReportingServicesService!crypto!f!5/8/2007-09:53:18:: i INFO: Importing existing encryption key
ReportingServicesService!servicecontroller!e!5/8/2007-09:53:18:: i INFO: RPC Server stopped
ReportingServicesService!servicecontroller!e!5/8/2007-09:53:18:: i INFO: Service shutting down.

I don't know where to look to see if a virtual directory was created. IN MSSQL.3 there is a Reporting Services directory but no sub named "Reports".

|||

Doesn't look like a virtual directory issue. Possibly an encryption key issue? Did you run the configuration utility for Reporting Services and initialize it?

Virtual directory should be located in IIS Manager.

cheers,

Andrew

|||

My Encryption Keys has a blue exclaimation point. I've run all the initializations I can find in the RS Config Mgr. I've backed up the keys. There doesn't seem to be any initialization on the Encryption Keys screen.

Thanks.

|||

Did you try RSkeymgmt command?

See this article...

http://www.it-jedi.net/2006/02/how-to-change-any-password-in-mom.html

cheers,

Andrew

|||I'll try that. In the mean time I was running SQL area config reporting services & when I selected Windows Integrated Security I got long error message with the entry Access to the path 'C:\...RSReportServer.config' is denied.