Wednesday, March 28, 2012

Reporting Services 2005 requires which SQL Server version?

Very quick question - as our customers have mission critical databases and
will not allow us to upgrade right after Yukon is released, can Reporting
Services 2005 use SQL Server 2000 to hold it's databases? If so then I can
upgrade the non-critical report servers and leave the databases alone for
the moment.
Thanks in advance,
James SnapeJames Snape wrote:
> Very quick question - as our customers have mission critical
databases and
> will not allow us to upgrade right after Yukon is released, can
Reporting
> Services 2005 use SQL Server 2000 to hold it's databases? If so then
I can
> upgrade the non-critical report servers and leave the databases alone
for
> the moment.
> Thanks in advance,
> James Snape
I presume Reporting Services will allow databases to be in SQLServer
2000 because thinking real time most of the operational data will be in
SS 2000 when Yukon is released.
However, The Microsoft guys are the right people to answer this
Question
Anand Sagar|||My understanding is that RS 2005 can use SQL Server 2000 for its databases.
Obviously reporting off of other databases is no problem. My understanding
is also that you will require the SQL Server 2005 license but that the DB
can stay as 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"James Snape" <jim_snape.at.hotmail@.online.nospam> wrote in message
news:%23rJb1d5VFHA.2516@.TK2MSFTNGP10.phx.gbl...
> Very quick question - as our customers have mission critical databases and
> will not allow us to upgrade right after Yukon is released, can Reporting
> Services 2005 use SQL Server 2000 to hold it's databases? If so then I can
> upgrade the non-critical report servers and leave the databases alone for
> the moment.
> Thanks in advance,
> James Snape
>

No comments:

Post a Comment