SQL 2005 reports and SQL 2000

Can I run SQL 2005 report on SQL 2000 server?

Thanks

EMartinez
Fri Apr 06 22:11:24 CDT 2007

On Apr 6, 6:22 pm, "Mark Goldin" <markgoldin_2...@yahoo.com> wrote:
> Can I run SQL 2005 report on SQL 2000 server?
>
> Thanks

Yes, you should be able to.

Regards,

Enrique Martinez
Sr. Software Consultant

Radoslaw
Sun Apr 08 10:12:42 CDT 2007

Hello Mark.

Unfortunately you can't deploy automaticaly RDL's from VS2005 to SQL 2000
Reporting Services.
Of course in some cases you can put your SQL2005 RDL's on RS 2000, but then
you might be obliged to manually edit this file to change the namespace and
remove some specific RS 2005 RDL features (such
as fixed headers for table/matrix, interactive sort, multi value or hidden
parameters, the new CustomReportItem & CustomProperties structures, the new
Action structure)

So, it's possible but not quite simple.

I hope this 'll be helpful.

----
Best Regards,
Radoslaw Lebkowski
MCTS SQL 2005 BI



----- Original Message -----
From: "Mark Goldin" <markgoldin_2000@yahoo.com>
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Sent: Saturday, April 07, 2007 1:22 AM
Subject: SQL 2005 reports and SQL 2000


> Can I run SQL 2005 report on SQL 2000 server?
>
> Thanks
>

Bruce
Sun Apr 08 19:02:47 CDT 2007

You have two answers but it depends on exactly what you are asking. If you
are asking if you can install RS 2005 and use SQL 2000 server for the
metadata/object caching the answer is yes. That is fully supported. If you
mean taking a RS 2005 report and deploying to RS 2000 the answer is no for
all practical purposes (yes you could manually edit the RDL file but that is
not a normal type of thing to be doing).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


"Mark Goldin" <markgoldin_2000@yahoo.com> wrote in message
news:OEJ2TKKeHHA.928@TK2MSFTNGP02.phx.gbl...
> Can I run SQL 2005 report on SQL 2000 server?
>
> Thanks
>

Mark
Mon Apr 09 09:54:16 CDT 2007

Here is my scenario:
I want do develop SQL 2005 reports using SQL 2005 server and 2005 Reporitng
Services installed on my development computer.
My client is running SQL 2000. Can I add 2005 Reporing Services to his
environment and run my reports?

Thanks

"Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
news:%234cRrpjeHHA.4772@TK2MSFTNGP05.phx.gbl...
> You have two answers but it depends on exactly what you are asking. If you
> are asking if you can install RS 2005 and use SQL 2000 server for the
> metadata/object caching the answer is yes. That is fully supported. If you
> mean taking a RS 2005 report and deploying to RS 2000 the answer is no for
> all practical purposes (yes you could manually edit the RDL file but that
> is not a normal type of thing to be doing).
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Mark Goldin" <markgoldin_2000@yahoo.com> wrote in message
> news:OEJ2TKKeHHA.928@TK2MSFTNGP02.phx.gbl...
>> Can I run SQL 2005 report on SQL 2000 server?
>>
>> Thanks
>>
>
>

Bruce
Mon Apr 09 10:25:13 CDT 2007

Yes. You need a SQL 2005 license but that is all. SQL Server 2000 does not
have to be upgraded. You can install RS 2005 to use SQL Server 2000 for its
metadata/object caching. This is fully supported and I did this myself for
quite awhile.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services



"Mark Goldin" <mgoldin@ufandd.com> wrote in message
news:%23LWjybreHHA.284@TK2MSFTNGP05.phx.gbl...
> Here is my scenario:
> I want do develop SQL 2005 reports using SQL 2005 server and 2005
> Reporitng Services installed on my development computer.
> My client is running SQL 2000. Can I add 2005 Reporing Services to his
> environment and run my reports?
>
> Thanks
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
> news:%234cRrpjeHHA.4772@TK2MSFTNGP05.phx.gbl...
>> You have two answers but it depends on exactly what you are asking. If
>> you are asking if you can install RS 2005 and use SQL 2000 server for the
>> metadata/object caching the answer is yes. That is fully supported. If
>> you mean taking a RS 2005 report and deploying to RS 2000 the answer is
>> no for all practical purposes (yes you could manually edit the RDL file
>> but that is not a normal type of thing to be doing).
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "Mark Goldin" <markgoldin_2000@yahoo.com> wrote in message
>> news:OEJ2TKKeHHA.928@TK2MSFTNGP02.phx.gbl...
>>> Can I run SQL 2005 report on SQL 2000 server?
>>>
>>> Thanks
>>>
>>
>>
>
>

Mark
Mon Apr 09 10:34:22 CDT 2007

Do I need to license full SQL 2005 server on my client's site or just the
2005 Reporitng Services?

"Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
news:eZgbGtreHHA.4020@TK2MSFTNGP05.phx.gbl...
> Yes. You need a SQL 2005 license but that is all. SQL Server 2000 does not
> have to be upgraded. You can install RS 2005 to use SQL Server 2000 for
> its metadata/object caching. This is fully supported and I did this myself
> for quite awhile.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
>
> "Mark Goldin" <mgoldin@ufandd.com> wrote in message
> news:%23LWjybreHHA.284@TK2MSFTNGP05.phx.gbl...
>> Here is my scenario:
>> I want do develop SQL 2005 reports using SQL 2005 server and 2005
>> Reporitng Services installed on my development computer.
>> My client is running SQL 2000. Can I add 2005 Reporing Services to his
>> environment and run my reports?
>>
>> Thanks
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
>> news:%234cRrpjeHHA.4772@TK2MSFTNGP05.phx.gbl...
>>> You have two answers but it depends on exactly what you are asking. If
>>> you are asking if you can install RS 2005 and use SQL 2000 server for
>>> the metadata/object caching the answer is yes. That is fully supported.
>>> If you mean taking a RS 2005 report and deploying to RS 2000 the answer
>>> is no for all practical purposes (yes you could manually edit the RDL
>>> file but that is not a normal type of thing to be doing).
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>>
>>> "Mark Goldin" <markgoldin_2000@yahoo.com> wrote in message
>>> news:OEJ2TKKeHHA.928@TK2MSFTNGP02.phx.gbl...
>>>> Can I run SQL 2005 report on SQL 2000 server?
>>>>
>>>> Thanks
>>>>
>>>
>>>
>>
>>
>
>

BavaMani
Mon Apr 09 10:42:02 CDT 2007

Hi Mark,
is the client need advanced feature of reports available in RS2005 ? like
interactive sorting,multivalue parameter... If not best way to save time and
cost is to develop the report RDL in RS2000 designer and you can upload in
RS2000 reprot manager or RS2005 report manager to work.

"Mark Goldin" wrote:

> Here is my scenario:
> I want do develop SQL 2005 reports using SQL 2005 server and 2005 Reporitng
> Services installed on my development computer.
> My client is running SQL 2000. Can I add 2005 Reporing Services to his
> environment and run my reports?
>
> Thanks
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
> news:%234cRrpjeHHA.4772@TK2MSFTNGP05.phx.gbl...
> > You have two answers but it depends on exactly what you are asking. If you
> > are asking if you can install RS 2005 and use SQL 2000 server for the
> > metadata/object caching the answer is yes. That is fully supported. If you
> > mean taking a RS 2005 report and deploying to RS 2000 the answer is no for
> > all practical purposes (yes you could manually edit the RDL file but that
> > is not a normal type of thing to be doing).
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Mark Goldin" <markgoldin_2000@yahoo.com> wrote in message
> > news:OEJ2TKKeHHA.928@TK2MSFTNGP02.phx.gbl...
> >> Can I run SQL 2005 report on SQL 2000 server?
> >>
> >> Thanks
> >>
> >
> >
>
>
>

Bruce
Mon Apr 09 12:35:51 CDT 2007

Bava is correct. You can develop RS 2000 reports and deploy to either RS
2000 or RS 2005.

As far as the license there is no such thing as RS 2005 license, the only
license is SQL 2005. Same is true for SSIS, Analysis Servers etc.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


"Mark Goldin" <mgoldin@ufandd.com> wrote in message
news:%23p63MyreHHA.1312@TK2MSFTNGP06.phx.gbl...
> Do I need to license full SQL 2005 server on my client's site or just the
> 2005 Reporitng Services?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
> news:eZgbGtreHHA.4020@TK2MSFTNGP05.phx.gbl...
>> Yes. You need a SQL 2005 license but that is all. SQL Server 2000 does
>> not have to be upgraded. You can install RS 2005 to use SQL Server 2000
>> for its metadata/object caching. This is fully supported and I did this
>> myself for quite awhile.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>>
>> "Mark Goldin" <mgoldin@ufandd.com> wrote in message
>> news:%23LWjybreHHA.284@TK2MSFTNGP05.phx.gbl...
>>> Here is my scenario:
>>> I want do develop SQL 2005 reports using SQL 2005 server and 2005
>>> Reporitng Services installed on my development computer.
>>> My client is running SQL 2000. Can I add 2005 Reporing Services to his
>>> environment and run my reports?
>>>
>>> Thanks
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
>>> news:%234cRrpjeHHA.4772@TK2MSFTNGP05.phx.gbl...
>>>> You have two answers but it depends on exactly what you are asking. If
>>>> you are asking if you can install RS 2005 and use SQL 2000 server for
>>>> the metadata/object caching the answer is yes. That is fully supported.
>>>> If you mean taking a RS 2005 report and deploying to RS 2000 the answer
>>>> is no for all practical purposes (yes you could manually edit the RDL
>>>> file but that is not a normal type of thing to be doing).
>>>>
>>>>
>>>> --
>>>> Bruce Loehle-Conger
>>>> MVP SQL Server Reporting Services
>>>>
>>>>
>>>> "Mark Goldin" <markgoldin_2000@yahoo.com> wrote in message
>>>> news:OEJ2TKKeHHA.928@TK2MSFTNGP02.phx.gbl...
>>>>> Can I run SQL 2005 report on SQL 2000 server?
>>>>>
>>>>> Thanks
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>