x

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.)

more ▼

asked Mar 10, 2010 at 06:14 PM in Default

Rod gravatar image

Rod
801 47 50 52

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Mar 10, 2010 at 06:27 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 75 78 108

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 10, 2010 at 09:22 PM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1944
x1834
x547

asked: Mar 10, 2010 at 06:14 PM

Seen: 1139 times

Last Updated: Mar 10, 2010 at 06:14 PM