Post reply

Reporting Services 2005 over a SQL 2000 database

  • February 22, 2006 at 10:16 am

    #112004

    I'm guessing there shouldn't be a restriction but can I run a 2005 server to take advantage of the new features, particularly Report Builder for the users, over a SQL 2000 database on another server?

    I'm pretty sure the answer's yes but can someone confirm please?

    Thanks

    Dave

  • February 23, 2006 at 9:08 am

    #622983

    I don't think you can actually.  I think that RS 2005 is licensed via SQL server 2005, so you have to have a licensed version of SQL 2005 in order to take advantage of the new features in RS 2005.

    Someone please correct me if I'm wrong.

    -Megan

  • February 23, 2006 at 10:12 am

    #623004

    Thanks Megan. Do you think that applies if I'm running Report Builder on a server running SQL 2005 but using a SQL 2000 database on a different server as the data source?

  • February 23, 2006 at 1:26 pm

    #623052

    You need SQL 2005 for running RS 2005 server, but for the data source you can access SQL 2000 with no problems.

  • February 23, 2006 at 1:31 pm

    #623053

    Ahh, lucky duck, Dave, I'm still stuck with 2000.

  • February 24, 2006 at 2:03 am

    #623135

    Thanks for your help

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply