Reporting Services 2000 with SQL Server 2005 data sources

All,

I apologize for not doing the legwork to see if i can answer my own question, but I am close to a loosely planned SQL 2005 migration and don't have time and resources to test my own theories.

Is there a way for a Reporting Services 2000 server to connect to SQL server 2005 databases? I've tried creating a new data source and changing a report to this data source, but it seems like the report is still using the old data source. I'm guessing i might need to register new data providers on the 2000 RS server and then change the existsing data sources.

Ideas?

Thx in advance,

-Peter

Yes, a report installed on Reporting Services 2000 (SRS) can source data for a report from SQL 2005 by setting the data source with the correct connection string. There shouldn't be a problem.

Larry

|||

The correct connection string seems to be "Data Source=<SQLServerName>;Initial Catalog=<DBNAme>" using the "Microsoft SQL Server" data source type. Fortunately, this was the same as our SQL 2000 data sources, so we had to change nothing. The 2000 BOL docs just aren't very clear on the details of each data source type.

Also, the gigantic document, SQL2005UpgradeTechRef.doc, doesn't really talk much about the dependencies between upgrading the RDBMS and the RS.

Thanks for the reply,

-Peter

sql

Reporting Services

We have SQL 2000 as our database platform. I can't see any large scale
migration any time soon. However we would like to start using Reporting
Services. What are the options of using 2005 Reporting services and point
them at a 2000 server through e.g. linked servers etc. Is something like
this possible or am I going in the wrong direction."Chris" <nospam@.nospam.com> wrote in message
news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
> We have SQL 2000 as our database platform. I can't see any large scale
> migration any time soon. However we would like to start using Reporting
> Services. What are the options of using 2005 Reporting services and point
> them at a 2000 server through e.g. linked servers etc. Is something like
> this possible or am I going in the wrong direction.
>
You don't even need linked servers. Just install Reporting Services 2005,
and you can build reports that pull data from SQL 2000 databases.
David|||Additional Info:
Besides the database where data for the reports is stored, RS itself also
needs SQL Server to host its meta database, which may or may not be in the
same computer where RS runs. For RS2005, yes, you can use SQL Server2000 to
host RS2005 meta database. However, where the RS meta-database is in the
same computer as the RS or not, you need SQL Server2005 license to use
RS2005 (That is, if the SQL Server is in different computer as RS, you need
two licenses: one for RS (SQL Server2005, in your case); and one for the SQL
Server2000 (SQL Server2005 or 2000 license).
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ucaOUjSTHHA.1200@.TK2MSFTNGP04.phx.gbl...
>
> "Chris" <nospam@.nospam.com> wrote in message
> news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
>> We have SQL 2000 as our database platform. I can't see any large scale
>> migration any time soon. However we would like to start using Reporting
>> Services. What are the options of using 2005 Reporting services and point
>> them at a 2000 server through e.g. linked servers etc. Is something like
>> this possible or am I going in the wrong direction.
> You don't even need linked servers. Just install Reporting Services 2005,
> and you can build reports that pull data from SQL 2000 databases.
> David