Reporting Services 2005 on SQL Server 2000

Hi,

I'm quite new to the Reporting Services 2005 and think I've made a slight(!) mistake. When I was on a training course to learn ASP2, I was told that I could create the Reports in SSRS2005 tool for VS2005 and that would work perfectly well with my copy of SQL Server 2000 - As VS2005 came with a 'runtime' so it could read the data off any objectdatasource.

Do I need SQL Server 2005 installed to run reports created in SSRS2005? We only have SQL Server 2000 and have no plans at present to upgrade.

If anyone has any advice, I'd be grateful, I guess I could always reinstall VS2003 and then recreate the reports in the Reporting Services for SQL Server 2000 and then link the two together.

Thanks,

Barnaby

Hi,

You can not publish SSRS 2005 reports to a SQL Server 2000 server as the RDL schema is changed in SSRS 2005 from SSRS 2000.

Directly from MSDN -

You cannot publish a report that has the SQL Server 2005 report definition namespace to a SQL Server 2000 report server.

Now to change the reports to SSRS 2000 chack this post(doin reverse might help, not sure) -

http://www.developmentnow.com/g/115_2007_4_0_0_964434/Converting-2000-rdl-files-to-2005.htm

Reporting Server replacing IP address with ComputerName

Hello,
I am facing a strange situation with my reports server.
The machine i am testing the server on has no domain name, only IP.
But, of course, it has a computer name.
When i access the report server manager, i get everything as it should
be, and it shows me the links to the reports, but when i want to see
the report, the report manager replaces IP in the report address, with
the computer name - which makes no sense since i am accessing the
server using the internet.
Hence, i am getting an 404 in the report sub-page.
If i copy the url from there, and go to the page after changing the
computer name to the IP, it works, naturally.
Does anybody know how to change this behavior?
Thanks in advance! :-)
ShlomoYes you need to see this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
Scroll down to the section that says "Deploying a Report Server for Internet
Access"
=-Chris
<shlomoid@.gmail.com> wrote in message
news:1108301192.984825.325330@.o13g2000cwo.googlegroups.com...
> Hello,
> I am facing a strange situation with my reports server.
> The machine i am testing the server on has no domain name, only IP.
> But, of course, it has a computer name.
> When i access the report server manager, i get everything as it should
> be, and it shows me the links to the reports, but when i want to see
> the report, the report manager replaces IP in the report address, with
> the computer name - which makes no sense since i am accessing the
> server using the internet.
> Hence, i am getting an 404 in the report sub-page.
> If i copy the url from there, and go to the page after changing the
> computer name to the IP, it works, naturally.
> Does anybody know how to change this behavior?
>
> Thanks in advance! :-)
> Shlomo
>|||Thanks!
Worked perfectly.