question

Rod avatar image
Rod asked

SQL 2008 and SQL 2005 Reporting Services

Once I re-image my machine and put on Windows 7, then I'll install either SQL 2005 Developer Edition, or SQL 2008 Developer Edition. I'd rather go with SQL 2008, but one thought just occurred to me, how about SQL Server Reporting Services? If I put on SQL 2008, then can I still develop SSRS reports in SQL 2008 for SQL 2005? (We've only got SQL 2005 on our production server, and that really isn't likely to change anytime soon.)

sql-server-2008sql-server-2005ssrs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

You can install the BIDS tools from the SQL 2005 installer as well as the 2008 SQL management tools. I install SQL 2008 as I want it and then run through the 2005 installer and add the BIDS tools to the PCs in our company. Use 2005 BIDS for reports deployed to a 2005 report server and 2008 BIDS for the 2008 server. Weirdly, you can build a 2008 report builder project and deploy that to a 2005 server, if you need to prove the report builder option to you users.

SSMS 2008 will manage any SQL Server from 2000 onwards.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image
Rob Farley answered

I'm going to add to Jack's comment that the data source for reports can be any OLEDB compliant system. So if you have SSRS 2008 somewhere, but need to run reports against a SQL 2005 box, this is fine. I know it's not really what your system needs, but it's worth considering. I have plenty of systems that have upgraded SSRS for a number of reasons, but still need to report against older databases.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.