TomFrancis


I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas

Thanks

Tom




Re: Report Manager Virtual Directory

Jens K. Suessmeyer


Service started


Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---







Re: Report Manager Virtual Directory

TomFrancis

I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!






Re: Report Manager Virtual Directory

William Vaughn

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using






Re: Report Manager Virtual Directory

Jens K. Suessmeyer

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started If yes, whats the Service name

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---






Re: Report Manager Virtual Directory

61Laurentian

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".





Re: Report Manager Virtual Directory

William Vaughn

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth






Re: Report Manager Virtual Directory

TomFrancis

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks


Tom





Re: Report Manager Virtual Directory

William Vaughn

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system Is the service running To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.






Re: Report Manager Virtual Directory

TomFrancis

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom





Re: Report Manager Virtual Directory

HeidiW

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also

It's frustrating!





Re: Report Manager Virtual Directory

TomFrancis

I uninstalled everything to do with SQL and started again!





Re: Report Manager Virtual Directory

HeidiW

Thank you, I will try it.





Re: Report Manager Virtual Directory

Amit kr mishra

other wise check your service pack ,Install latest service pack from Microsoft site and then configure .if still the same problem then you have no option except reinstall.