Report Server problem

I am using SQL Server 2000 reporting services.I created a report in VS.net 2003.Report is showing in preview pane properly.But when i press start it gives a messege "No Reprot Server was found at http://localhost/ReprotServer".
Is reprot server required for the reprot.whats other alternative to show the report on web browser?

Hi,

By default, the reportserver's URL is http://localhost/reportserver.
When installing reporting services on a named instance this will be http://localhost/reportserver$instancename.

First check in your IIS what the exact name of the reportserver is. Also check that IIS is started. Try to open the reportservice.asmx file.

If this works, check the reportserver path in the Project Properties. Make sure it is the same as in your IIS.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Thanks! for your reply..

Here the problem is that report server component is not installed on my computer.Also

during installation this component is not showing in the list, only client component is showing and get

installed.Although I have IIS, SqlServer 2000 and framework 1.1 installed properly.I am unable to find how to install report server

and report manager.

pls help me out...

Thanks again!!

|||

Hi,

Wich Service Pack does your SQL Server has? In able to run Reporting Services on SQL Server 2000, you must at least have SP3 installed.

Also, the reporting server must be installed separately. Although, it is licensed with your existing SQL Server.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Thanks! for the support...

Now the server component is showing with report server.But after installation it gives error messege

'The ReportServer windows service can not start.You do not have sufficient privilege'. ans the it rollback the installation.

Although i am logged in as local system account.

i also read somewhere on net that Use of the Local Service account for the ReportServer Windows service is not supported.

i am not on any domain.pls suggest me what to do.

thanks

|||

Hi,

The account that you specified in the setup must have the rights to run a service (Logon as a service permission). This can be set in the windows policy. Maybe that this is not set. I know that for 2005, the setup gives the necessary permissions but for 2000 it can be that you need to do this manually.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Thanks Geert!!.. its installed successfully...