Can I install SSRS2005 onto SQL SERVER 2000?

Please Help me!
Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
no , then Why not? Is it provide the functionality of SSRS 2005,After
installation?
TIA......To my limited knowledge... Reporting services is a component of sql
server, so installing it is equivalent to installing sql server 2005,
and would require a license for sql 2005 as well as your license for
sql 2000.
given this you may as well upgrade your whole setup to sql server 2005.
assuming that you have some reason not to do this. I don't think the
reporting services database can run on a sql 2000 server, but can't be
sure of this.
ajmera.puneet@.gmail.com wrote:
> Please Help me!
> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
> no , then Why not? Is it provide the functionality of SSRS 2005,After
> installation?
> TIA......|||As far as licensing is concerned. Any box that has RS 2005 installed has to
have a SQL Server 2005 license for that box (remember, the database used for
metadata/object data does not have to reside on the same box as RS 2005). So
that is the important concept, anywhere you install RS 2005 server
components you must have a SQL Server 2005 license.
That being said, you can use SQL Server 2000 as the object/metadata store
for RS 2005 (I have done this, it is fully supported). Some people do this
because databases upgrades tend to be slower/more cautious.
How is easy. Make sure you have IIS running on your box. Get a SQL Server
2005 media, install RS 2005. If on the same machine it is very easy to just
accept defaults. Note that you do need to have dba rights to SQL Server
during the install (it will be installing two databases).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<someone_else_of_course@.hotmail.co.uk> wrote in message
news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> To my limited knowledge... Reporting services is a component of sql
> server, so installing it is equivalent to installing sql server 2005,
> and would require a license for sql 2005 as well as your license for
> sql 2000.
> given this you may as well upgrade your whole setup to sql server 2005.
> assuming that you have some reason not to do this. I don't think the
> reporting services database can run on a sql 2000 server, but can't be
> sure of this.
>
> ajmera.puneet@.gmail.com wrote:
>> Please Help me!
>> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
>> no , then Why not? Is it provide the functionality of SSRS 2005,After
>> installation?
>> TIA......
>|||Bruce L-C [MVP] wrote:
> As far as licensing is concerned. Any box that has RS 2005 installed has to
> have a SQL Server 2005 license for that box (remember, the database used for
> metadata/object data does not have to reside on the same box as RS 2005). So
> that is the important concept, anywhere you install RS 2005 server
> components you must have a SQL Server 2005 license.
> That being said, you can use SQL Server 2000 as the object/metadata store
> for RS 2005 (I have done this, it is fully supported). Some people do this
> because databases upgrades tend to be slower/more cautious.
> How is easy. Make sure you have IIS running on your box. Get a SQL Server
> 2005 media, install RS 2005. If on the same machine it is very easy to just
> accept defaults. Note that you do need to have dba rights to SQL Server
> during the install (it will be installing two databases).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <someone_else_of_course@.hotmail.co.uk> wrote in message
> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> > To my limited knowledge... Reporting services is a component of sql
> > server, so installing it is equivalent to installing sql server 2005,
> > and would require a license for sql 2005 as well as your license for
> > sql 2000.
> >
> > given this you may as well upgrade your whole setup to sql server 2005.
> >
> > assuming that you have some reason not to do this. I don't think the
> > reporting services database can run on a sql 2000 server, but can't be
> > sure of this.
> >
> >
> > ajmera.puneet@.gmail.com wrote:
> >> Please Help me!
> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
> >> no , then Why not? Is it provide the functionality of SSRS 2005,After
> >> installation?
> >> TIA......
> >
Thanks,
One more question that , Is there any need of data migration from 2000
to 2005?
or I can use DB on sql server 2000 as it is with RS2005?
Plz, Help me .If yes then how? No , then Why?|||I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
databases as its data store. If you are licensed then you are good to go.
Just install RS 2005 (the box needs IIS installed already) and do not
install SQL Server 2005 DB. Just do Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ajmera.puneet@.gmail.com> wrote in message
news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
> Bruce L-C [MVP] wrote:
>> As far as licensing is concerned. Any box that has RS 2005 installed has
>> to
>> have a SQL Server 2005 license for that box (remember, the database used
>> for
>> metadata/object data does not have to reside on the same box as RS 2005).
>> So
>> that is the important concept, anywhere you install RS 2005 server
>> components you must have a SQL Server 2005 license.
>> That being said, you can use SQL Server 2000 as the object/metadata store
>> for RS 2005 (I have done this, it is fully supported). Some people do
>> this
>> because databases upgrades tend to be slower/more cautious.
>> How is easy. Make sure you have IIS running on your box. Get a SQL Server
>> 2005 media, install RS 2005. If on the same machine it is very easy to
>> just
>> accept defaults. Note that you do need to have dba rights to SQL Server
>> during the install (it will be installing two databases).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <someone_else_of_course@.hotmail.co.uk> wrote in message
>> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
>> > To my limited knowledge... Reporting services is a component of sql
>> > server, so installing it is equivalent to installing sql server 2005,
>> > and would require a license for sql 2005 as well as your license for
>> > sql 2000.
>> >
>> > given this you may as well upgrade your whole setup to sql server 2005.
>> >
>> > assuming that you have some reason not to do this. I don't think the
>> > reporting services database can run on a sql 2000 server, but can't be
>> > sure of this.
>> >
>> >
>> > ajmera.puneet@.gmail.com wrote:
>> >> Please Help me!
>> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and
>> >> If
>> >> no , then Why not? Is it provide the functionality of SSRS 2005,After
>> >> installation?
>> >> TIA......
>> >
>
> Thanks,
> One more question that , Is there any need of data migration from 2000
> to 2005?
> or I can use DB on sql server 2000 as it is with RS2005?
> Plz, Help me .If yes then how? No , then Why?
>|||There is a useful aticle on this subject at:
https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
my question is, does the SQL Server 2000 installation have to be on the
same box?
What I'd ideally like to do is put SSRS 2005 on our web server box and
use our SQL 2000 box to store the SSRS metadata AND the application
data that SSRS will be reporting on.
Any replies gratefully received!
Bruce L-C [MVP] wrote:
> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
> databases as its data store. If you are licensed then you are good to go.
> Just install RS 2005 (the box needs IIS installed already) and do not
> install SQL Server 2005 DB. Just do Reporting Services.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <ajmera.puneet@.gmail.com> wrote in message
> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
> >
> > Bruce L-C [MVP] wrote:
> >> As far as licensing is concerned. Any box that has RS 2005 installed has
> >> to
> >> have a SQL Server 2005 license for that box (remember, the database used
> >> for
> >> metadata/object data does not have to reside on the same box as RS 2005).
> >> So
> >> that is the important concept, anywhere you install RS 2005 server
> >> components you must have a SQL Server 2005 license.
> >>
> >> That being said, you can use SQL Server 2000 as the object/metadata store
> >> for RS 2005 (I have done this, it is fully supported). Some people do
> >> this
> >> because databases upgrades tend to be slower/more cautious.
> >>
> >> How is easy. Make sure you have IIS running on your box. Get a SQL Server
> >> 2005 media, install RS 2005. If on the same machine it is very easy to
> >> just
> >> accept defaults. Note that you do need to have dba rights to SQL Server
> >> during the install (it will be installing two databases).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> >> > To my limited knowledge... Reporting services is a component of sql
> >> > server, so installing it is equivalent to installing sql server 2005,
> >> > and would require a license for sql 2005 as well as your license for
> >> > sql 2000.
> >> >
> >> > given this you may as well upgrade your whole setup to sql server 2005.
> >> >
> >> > assuming that you have some reason not to do this. I don't think the
> >> > reporting services database can run on a sql 2000 server, but can't be
> >> > sure of this.
> >> >
> >> >
> >> > ajmera.puneet@.gmail.com wrote:
> >> >> Please Help me!
> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and
> >> >> If
> >> >> no , then Why not? Is it provide the functionality of SSRS 2005,After
> >> >> installation?
> >> >> TIA......
> >> >
> >
> >
> > Thanks,
> > One more question that , Is there any need of data migration from 2000
> > to 2005?
> > or I can use DB on sql server 2000 as it is with RS2005?
> > Plz, Help me .If yes then how? No , then Why?
> >|||I've answered you several times. Heck, reading my previous answers I could
come up with the answer to this post.
It is fully supported. Now I say that and you want to know how it is
different. It is not different. Buy a licnese and install RS 2005 exactly as
you would using a SQL Server 2005 database but instead you give it a SQL
Server 2000 server. That is it. NO difference. You have to have a SQL Server
2005 license for the box running RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jonny" <rob.sykes@.virgin.net> wrote in message
news:1156510085.177774.19660@.m73g2000cwd.googlegroups.com...
> There is a useful aticle on this subject at:
> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
> my question is, does the SQL Server 2000 installation have to be on the
> same box?
> What I'd ideally like to do is put SSRS 2005 on our web server box and
> use our SQL 2000 box to store the SSRS metadata AND the application
> data that SSRS will be reporting on.
> Any replies gratefully received!
>
> Bruce L-C [MVP] wrote:
>> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
>> databases as its data store. If you are licensed then you are good to go.
>> Just install RS 2005 (the box needs IIS installed already) and do not
>> install SQL Server 2005 DB. Just do Reporting Services.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <ajmera.puneet@.gmail.com> wrote in message
>> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
>> >
>> > Bruce L-C [MVP] wrote:
>> >> As far as licensing is concerned. Any box that has RS 2005 installed
>> >> has
>> >> to
>> >> have a SQL Server 2005 license for that box (remember, the database
>> >> used
>> >> for
>> >> metadata/object data does not have to reside on the same box as RS
>> >> 2005).
>> >> So
>> >> that is the important concept, anywhere you install RS 2005 server
>> >> components you must have a SQL Server 2005 license.
>> >>
>> >> That being said, you can use SQL Server 2000 as the object/metadata
>> >> store
>> >> for RS 2005 (I have done this, it is fully supported). Some people do
>> >> this
>> >> because databases upgrades tend to be slower/more cautious.
>> >>
>> >> How is easy. Make sure you have IIS running on your box. Get a SQL
>> >> Server
>> >> 2005 media, install RS 2005. If on the same machine it is very easy to
>> >> just
>> >> accept defaults. Note that you do need to have dba rights to SQL
>> >> Server
>> >> during the install (it will be installing two databases).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
>> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
>> >> > To my limited knowledge... Reporting services is a component of sql
>> >> > server, so installing it is equivalent to installing sql server
>> >> > 2005,
>> >> > and would require a license for sql 2005 as well as your license for
>> >> > sql 2000.
>> >> >
>> >> > given this you may as well upgrade your whole setup to sql server
>> >> > 2005.
>> >> >
>> >> > assuming that you have some reason not to do this. I don't think the
>> >> > reporting services database can run on a sql 2000 server, but can't
>> >> > be
>> >> > sure of this.
>> >> >
>> >> >
>> >> > ajmera.puneet@.gmail.com wrote:
>> >> >> Please Help me!
>> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How?
>> >> >> and
>> >> >> If
>> >> >> no , then Why not? Is it provide the functionality of SSRS
>> >> >> 2005,After
>> >> >> installation?
>> >> >> TIA......
>> >> >
>> >
>> >
>> > Thanks,
>> > One more question that , Is there any need of data migration from 2000
>> > to 2005?
>> > or I can use DB on sql server 2000 as it is with RS2005?
>> > Plz, Help me .If yes then how? No , then Why?
>> >
>|||Bruce, thanks for your reply. I did figure out that SSRS 2005 is
compatible with SQL 2000 and that license-wise we would still need to
purchase the full SQL 2005 license.
The main thrust of my question was whether SQL Server has to reside on
the same box as SSRS or can SSRS point to a database on a different box
for its metadata?
Bruce L-C [MVP] wrote:
> I've answered you several times. Heck, reading my previous answers I could
> come up with the answer to this post.
> It is fully supported. Now I say that and you want to know how it is
> different. It is not different. Buy a licnese and install RS 2005 exactly as
> you would using a SQL Server 2005 database but instead you give it a SQL
> Server 2000 server. That is it. NO difference. You have to have a SQL Server
> 2005 license for the box running RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "jonny" <rob.sykes@.virgin.net> wrote in message
> news:1156510085.177774.19660@.m73g2000cwd.googlegroups.com...
> > There is a useful aticle on this subject at:
> >
> > https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> >
> > So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
> > my question is, does the SQL Server 2000 installation have to be on the
> > same box?
> >
> > What I'd ideally like to do is put SSRS 2005 on our web server box and
> > use our SQL 2000 box to store the SSRS metadata AND the application
> > data that SSRS will be reporting on.
> >
> > Any replies gratefully received!
> >
> >
> > Bruce L-C [MVP] wrote:
> >
> >> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
> >> databases as its data store. If you are licensed then you are good to go.
> >> Just install RS 2005 (the box needs IIS installed already) and do not
> >> install SQL Server 2005 DB. Just do Reporting Services.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <ajmera.puneet@.gmail.com> wrote in message
> >> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
> >> >
> >> > Bruce L-C [MVP] wrote:
> >> >> As far as licensing is concerned. Any box that has RS 2005 installed
> >> >> has
> >> >> to
> >> >> have a SQL Server 2005 license for that box (remember, the database
> >> >> used
> >> >> for
> >> >> metadata/object data does not have to reside on the same box as RS
> >> >> 2005).
> >> >> So
> >> >> that is the important concept, anywhere you install RS 2005 server
> >> >> components you must have a SQL Server 2005 license.
> >> >>
> >> >> That being said, you can use SQL Server 2000 as the object/metadata
> >> >> store
> >> >> for RS 2005 (I have done this, it is fully supported). Some people do
> >> >> this
> >> >> because databases upgrades tend to be slower/more cautious.
> >> >>
> >> >> How is easy. Make sure you have IIS running on your box. Get a SQL
> >> >> Server
> >> >> 2005 media, install RS 2005. If on the same machine it is very easy to
> >> >> just
> >> >> accept defaults. Note that you do need to have dba rights to SQL
> >> >> Server
> >> >> during the install (it will be installing two databases).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
> >> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> >> >> > To my limited knowledge... Reporting services is a component of sql
> >> >> > server, so installing it is equivalent to installing sql server
> >> >> > 2005,
> >> >> > and would require a license for sql 2005 as well as your license for
> >> >> > sql 2000.
> >> >> >
> >> >> > given this you may as well upgrade your whole setup to sql server
> >> >> > 2005.
> >> >> >
> >> >> > assuming that you have some reason not to do this. I don't think the
> >> >> > reporting services database can run on a sql 2000 server, but can't
> >> >> > be
> >> >> > sure of this.
> >> >> >
> >> >> >
> >> >> > ajmera.puneet@.gmail.com wrote:
> >> >> >> Please Help me!
> >> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How?
> >> >> >> and
> >> >> >> If
> >> >> >> no , then Why not? Is it provide the functionality of SSRS
> >> >> >> 2005,After
> >> >> >> installation?
> >> >> >> TIA......
> >> >> >
> >> >
> >> >
> >> > Thanks,
> >> > One more question that , Is there any need of data migration from 2000
> >> > to 2005?
> >> > or I can use DB on sql server 2000 as it is with RS2005?
> >> > Plz, Help me .If yes then how? No , then Why?
> >> >
> >|||RS can have it on the same box or on a different box. I haven't installed it
that way but lots of people have. You can also have web farm configuration,
several RS all using the same database. That requires enterprise version.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jonny" <rob.sykes@.virgin.net> wrote in message
news:1156513351.443872.70820@.p79g2000cwp.googlegroups.com...
> Bruce, thanks for your reply. I did figure out that SSRS 2005 is
> compatible with SQL 2000 and that license-wise we would still need to
> purchase the full SQL 2005 license.
> The main thrust of my question was whether SQL Server has to reside on
> the same box as SSRS or can SSRS point to a database on a different box
> for its metadata?
>
> Bruce L-C [MVP] wrote:
>> I've answered you several times. Heck, reading my previous answers I
>> could
>> come up with the answer to this post.
>> It is fully supported. Now I say that and you want to know how it is
>> different. It is not different. Buy a licnese and install RS 2005 exactly
>> as
>> you would using a SQL Server 2005 database but instead you give it a SQL
>> Server 2000 server. That is it. NO difference. You have to have a SQL
>> Server
>> 2005 license for the box running RS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "jonny" <rob.sykes@.virgin.net> wrote in message
>> news:1156510085.177774.19660@.m73g2000cwd.googlegroups.com...
>> > There is a useful aticle on this subject at:
>> >
>> > https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>> >
>> > So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
>> > my question is, does the SQL Server 2000 installation have to be on the
>> > same box?
>> >
>> > What I'd ideally like to do is put SSRS 2005 on our web server box and
>> > use our SQL 2000 box to store the SSRS metadata AND the application
>> > data that SSRS will be reporting on.
>> >
>> > Any replies gratefully received!
>> >
>> >
>> > Bruce L-C [MVP] wrote:
>> >
>> >> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
>> >> databases as its data store. If you are licensed then you are good to
>> >> go.
>> >> Just install RS 2005 (the box needs IIS installed already) and do not
>> >> install SQL Server 2005 DB. Just do Reporting Services.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <ajmera.puneet@.gmail.com> wrote in message
>> >> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
>> >> >
>> >> > Bruce L-C [MVP] wrote:
>> >> >> As far as licensing is concerned. Any box that has RS 2005
>> >> >> installed
>> >> >> has
>> >> >> to
>> >> >> have a SQL Server 2005 license for that box (remember, the database
>> >> >> used
>> >> >> for
>> >> >> metadata/object data does not have to reside on the same box as RS
>> >> >> 2005).
>> >> >> So
>> >> >> that is the important concept, anywhere you install RS 2005 server
>> >> >> components you must have a SQL Server 2005 license.
>> >> >>
>> >> >> That being said, you can use SQL Server 2000 as the object/metadata
>> >> >> store
>> >> >> for RS 2005 (I have done this, it is fully supported). Some people
>> >> >> do
>> >> >> this
>> >> >> because databases upgrades tend to be slower/more cautious.
>> >> >>
>> >> >> How is easy. Make sure you have IIS running on your box. Get a SQL
>> >> >> Server
>> >> >> 2005 media, install RS 2005. If on the same machine it is very easy
>> >> >> to
>> >> >> just
>> >> >> accept defaults. Note that you do need to have dba rights to SQL
>> >> >> Server
>> >> >> during the install (it will be installing two databases).
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
>> >> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
>> >> >> > To my limited knowledge... Reporting services is a component of
>> >> >> > sql
>> >> >> > server, so installing it is equivalent to installing sql server
>> >> >> > 2005,
>> >> >> > and would require a license for sql 2005 as well as your license
>> >> >> > for
>> >> >> > sql 2000.
>> >> >> >
>> >> >> > given this you may as well upgrade your whole setup to sql server
>> >> >> > 2005.
>> >> >> >
>> >> >> > assuming that you have some reason not to do this. I don't think
>> >> >> > the
>> >> >> > reporting services database can run on a sql 2000 server, but
>> >> >> > can't
>> >> >> > be
>> >> >> > sure of this.
>> >> >> >
>> >> >> >
>> >> >> > ajmera.puneet@.gmail.com wrote:
>> >> >> >> Please Help me!
>> >> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How?
>> >> >> >> and
>> >> >> >> If
>> >> >> >> no , then Why not? Is it provide the functionality of SSRS
>> >> >> >> 2005,After
>> >> >> >> installation?
>> >> >> >> TIA......
>> >> >> >
>> >> >
>> >> >
>> >> > Thanks,
>> >> > One more question that , Is there any need of data migration from
>> >> > 2000
>> >> > to 2005?
>> >> > or I can use DB on sql server 2000 as it is with RS2005?
>> >> > Plz, Help me .If yes then how? No , then Why?
>> >> >
>> >
>