Solved

SSRS using SQL Server 2005 standard

Posted on 2008-06-23
2
188 Views
Last Modified: 2010-03-19
Can SQL Server 2005 standard work with SSRS and open BI project in VS2008/2005? Thanks.
0
Comment
Question by:ksfok
2 Comments
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 250 total points
ID: 21849318
Yes, SSRS can target SQL 2005 Standard as the database server.  The BI Project can be opened by the tools in SQL 2005 (Business Intelligence Studio).
0
 
LVL 13

Assisted Solution

by:rickchild
rickchild earned 250 total points
ID: 21849831
Note that the Business Intelligence Development Studio which comes with SQL2005 cannot work with SSRS2008 reports.  This is because the .RDL files are now different, and MS have xpanded the Report Development software in 2008.  You can still open SSRS2005 files in 2008.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trigger for audit 26 71
MS SQL page split per second is high 19 77
How to query LOCK_ESCALATION 4 40
How to import SQL 2000 database to SQL 2014 5 100
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now