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
>
Showing posts with label released. Show all posts
Showing posts with label released. Show all posts
Wednesday, March 28, 2012
Reporting Services 2005 beta on SQL Server 2000
We would like to upgrade to Reporting Services to 2005 as soon as it is
released this fall. However, we don't plan to go to SQL Server 2005 for at
least another year. I'm a bit worried about this configuration (RS 2005 on
SQL 2000). Does anyone have any experience running RS 2005 beta on SQL 2000
and would you recommend this setup?We haven't done this ourselves yet, but our plan is to install SQL Server
2005 and RS 2005 on one server, and set the data source for the reports to
our production data on a different box running SQL Server 2000. We do it
with separate servers now except that SQL 2000 is running on both.
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:289D532F-670A-40E4-A8F6-B89B76B934AB@.microsoft.com...
> We would like to upgrade to Reporting Services to 2005 as soon as it is
> released this fall. However, we don't plan to go to SQL Server 2005 for at
> least another year. I'm a bit worried about this configuration (RS 2005 on
> SQL 2000). Does anyone have any experience running RS 2005 beta on SQL
> 2000
> and would you recommend this setup?
released this fall. However, we don't plan to go to SQL Server 2005 for at
least another year. I'm a bit worried about this configuration (RS 2005 on
SQL 2000). Does anyone have any experience running RS 2005 beta on SQL 2000
and would you recommend this setup?We haven't done this ourselves yet, but our plan is to install SQL Server
2005 and RS 2005 on one server, and set the data source for the reports to
our production data on a different box running SQL Server 2000. We do it
with separate servers now except that SQL 2000 is running on both.
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:289D532F-670A-40E4-A8F6-B89B76B934AB@.microsoft.com...
> We would like to upgrade to Reporting Services to 2005 as soon as it is
> released this fall. However, we don't plan to go to SQL Server 2005 for at
> least another year. I'm a bit worried about this configuration (RS 2005 on
> SQL 2000). Does anyone have any experience running RS 2005 beta on SQL
> 2000
> and would you recommend this setup?
Subscribe to:
Posts (Atom)