Will SSRS 2005 work with SQL Server 2000 database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Stroope - 28 Feb 2007 21:19 GMT

Hi,

My manager wants to upgrade from SSRS-2000 to SSRS-2005, but he doesn't want
to upgrade to SQL Server-2005 yet. Can we do this? Will SSRS-2005 work with
a SQL Server 2000 Reporting Services database/Report Catalog?

Signature

Thanks,

Jeff

Reply to this Message

Bruce L-C [MVP] - 28 Feb 2007 22:00 GMT

Yes. It is a 100% supported (and this is how I first worked as well).

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hi,
>
[quoted text clipped - 3 lines]
> with
> a SQL Server 2000 Reporting Services database/Report Catalog?

Reply to this Message

Jeff Stroope - 28 Feb 2007 22:12 GMT

Thanks Bruce! Can I bother you with one more question? I know that with
SSRS-2005, the report designer is actually part of reporting services and
visual studio is not required. Right now, I build the reports by using VS
2003. How does that work when you upgrade to SSRS-2005? Will we get the new
report designer, too?

Signature

Thanks,

Jeff

> Yes. It is a 100% supported (and this is how I first worked as well).
>
[quoted text clipped - 5 lines]
> > with
> > a SQL Server 2000 Reporting Services database/Report Catalog?

Reply to this Message

Bruce L-C [MVP] - 28 Feb 2007 22:41 GMT

When you install the new business intelligence tools it will install a
version of VS 2005 side by side with VS 2003. What you should do is copy
your directories with your source files to new directories. As you open up
the project in RS 2005 and then each individual report in the designer it
will convert them. It does not convert them until you open the report in the
designer. When you upgrade the server the existing reports are left in RS
2000 format. My suggestion is to open up all your reports and convert them
and redeploy. I had a variety of weird small problems when I upgraded that
went away once I did this.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Thanks Bruce! Can I bother you with one more question? I know that with
> SSRS-2005, the report designer is actually part of reporting services and
[quoted text clipped - 13 lines]
>> > with
>> > a SQL Server 2000 Reporting Services database/Report Catalog?

Reply to this Message

Jeff Stroope - 28 Feb 2007 23:44 GMT

Thanks Bruce.

Signature

Thanks,

Jeff

> When you install the new business intelligence tools it will install a
> version of VS 2005 side by side with VS 2003. What you should do is copy
[quoted text clipped - 23 lines]
> >> > with
> >> > a SQL Server 2000 Reporting Services database/Report Catalog?

Reply to this Message