Bagikan melalui

Using SQL 2000 for SSRS 2005 metadata storage

  • Artikel

When setting up SQL Server Reporting Services 2005, can you use SQL 2000 as the host for the reportserver database? Yes, you can (with an obvious caveat in one scenario).

 

How?

 

Scenario 1:

 

 

SQL Server 2000 currently is not running SSRS, so it does not host the ReportServer database.

 

1. Run SQL Server 2005 setup, including the Reporting Services component.

 

2. Don't choose to go with the "install default configuration" option of SSRS. Instead,

    choose the second option to manually configure SSRS after setup has completed.

 

3. Finish setup

 

4. Launch the Reporting Services Configuration tool, and choose the Databases Setup task.

 

5. Provide the name of your 2000 server and click the New button. When prompted, provide

   credentials necessary to create a database on SQL 2000...you'll also need to provide the

   name of the database (ReportServer).

 

6. After the database has been created, use the lower portion of hte Database Setup screen to

   specify the credentials SSRS should use when connecting to the database in the future.

 

I used these steps with SQL Server 2000 SP3, and had no problems.

 

Scenario 2:

 

SQL Server 2000 is already hosting SSRS 2000 and/or is managing a ReportServer database created for SSRS 2000

 

Warning: Following these steps will "break" your SSRS 2000 report servers as we'll upgrade the ReportServer database to a schema 2000 doesn't undersand.

 

1. Repeat steps 1-4 as above.

 

2. Type in the name of the 2000 server and click Connect. Choose the ReportServer database

   from the drop-down list (or just click the Upgrade button).

 

3. When prompted whether you want to upgrade, choose Yes.

 

4. After the upgrade process has finished, complete step 6 as above. If you have upgraded a

   database that another SSRS server used to use, you may get warning messages around the

   fact that other encryption keys were detected in the database. Since our 2000 report servers

   can't use this database now anyway, feel free to delete the existing keys.

 

Reminder: If/when you launch Report Manager from an SSRS 2000 server which used to use this database, you'll get an exception which looks like this:

 

"The version of the report server database is either in a format that is not vaid, or it cannot be read. The found version is 'C.0.8.40'. The expected version is 'C.9.6.54.'. To continue, upgrade the version of the report server database and verify access rights"

Comments

  • Anonymous
    June 07, 2006
    The comment has been removed

  • Anonymous
    June 29, 2006
    Finally, from your notes, I've found out how to upgrade my RS2000 to RS2005 with my SQL Server 2000.  My concern is, I own SQL Server 2000 but I do not own SQL Server 2005.  When I use the SQL Server 2005 setup, I won't have to go out and purchase SQL Server 2005 will I?

  • Anonymous
    July 17, 2006
    Yes, you need SQL 2005.

  • Anonymous
    July 27, 2006
    Will this also install SQL Server 2005 on the machine?  Will this try to upgrade a SQL Server 2000 instalnce if this is on the same machine as SSRS 2000?

    Thanks!

    Mike
    mlohss@gmail.com

  • Anonymous
    July 29, 2006
    Yes, it will install 2005. That's the point :)

  • Anonymous
    August 05, 2006
    How can I ulitize the dataset in the code window in RSS 2000? I need to bring in the dataset and put into list and then have a function pass in data to run against this.
    Thanks,
    Don
    donstickle@fastmail.fm

  • Anonymous
    August 22, 2006
    The comment has been removed

  • Anonymous
    August 23, 2006
    Error: The Remote Procedure Call (RPC) service failed to start.

  • Anonymous
    August 24, 2006
    You probably have a firewall issue which is blocking RPC traffic. If you have firewalls installed on either machine, turn them off and see if the messsage goes away.

  • Anonymous
    August 24, 2006
    Can I have SQL Reporting 2000 running on a 2000 instance & SQL Reporting 2005 running on a 2005 instance ON the SAME Server?

  • Anonymous
    August 26, 2006
    Sure, but you're going to need quite a bit of RAM on that machine.

  • Anonymous
    August 29, 2006
    The comment has been removed

  • Anonymous
    September 07, 2006
    Is it possible to set up a SQL 2005 server with SSRS 2005 on it and then link it to data from a SQL 2000 server?  I do have an SSRS 2000 setup on my SQL 2000, but I don't want to upgrade and break the reports on there.  I'd rather be able to migrate them to the new server w/o taking down the current setup.

  • Anonymous
    September 11, 2006
    John, I'm not 100% sure I understand your question, but I think you're asking "Can I get SSRS 2005 to use my SSRS 2000 metadata database running on SQL 2000". The answer is No. You certainly CAN report against SQL 2000 data from a SSRS 2005, that's no problem at all.

  • Anonymous
    September 12, 2006
    When trying to create the database i get an error that says remote connections is not allowed for SQL Server...but I checked and it is.  Any ideas?

    THank you.

  • Anonymous
    September 14, 2006
    The comment has been removed

  • Anonymous
    September 20, 2006
    You should not attempt to copy meta data between copies of the ReportServer database. This probably won't work anyway since the db schema has changed a bit between 2000 and 2005. I'd try upgrading again.

  • Anonymous
    December 04, 2006
    i have been a while trying to know if i can run SQL reporting services 2005 over SQL server 2000 and...

  • Anonymous
    January 05, 2007
    I have a server running SQL 2000 and a separate web-server with IIS on it for my application. I want to install SSRS 2005. Do i need to install it on the web server and then point it at the SQL Server database or do i install RS directly on to the SQL server (which doesn't have IIS on it)?Thanks

  • Anonymous
    January 08, 2007
    Install on the web server, then point to the instance of SQL 2000

  • Anonymous
    January 17, 2007
    The comment has been removed

  • Anonymous
    January 22, 2007
    The comment has been removed

  • Anonymous
    January 25, 2008
    I have SQL Server 2000 in one server SSRS2005 to be installed on another server.  SQL Server 2000 will eventually be upgraded to SQL 2005.  For now, we are planning to use SSRS2005/VS2005 to create reports from data in the SQL 2000 server.  During installation, where should the ReportServer and ReportServerTemp databases be created, on the 2000 server or the 2005 server?  Does 1 have setup have more advantages than the other?  Any insight would help, thank you very much.

  • Anonymous
    January 21, 2009
    PingBack from http://www.hilpers.it/2535191-uso-di-reporting-services-2005-a

  • Anonymous
    January 21, 2009
    PingBack from http://www.keyongtech.com/2194469-rs2005-on-sql-server-2000-a

  • Anonymous
    February 04, 2009
    Does this works with Reporting Services in SQL Server 2005 Express Edition with Advanced Services.We are trying to use this Reporting Services to generate reports from SQL 2000 database with no success. Is get an error Connection to Data Source in Report Manager.

  • Anonymous
    May 21, 2009
    Do I need the license (I have the license for SQL 2000) of SQL 2005 to use SSRS 2005 Express Edition with Advanced Services?

  • Anonymous
    June 19, 2009
    PingBack from http://edebtsettlementprogram.info/story.php?id=24116