Welcome to MSDN Blogs Sign in | Join | Help

SQL Server 2005 Express Edition and Reporting Services -- At last!

Yesterday, Microsoft released the CTP of SQL Express with Advanced Services. You can use this distro to get SSRS functionality in Express.

Here's the section of the readme that applies to "us" (bold is mine):

4.2 Creating Reports by Using Reporting Services and Business Intelligence Development Studio

Setup installs Reporting Services. After you install Reporting Services, you can view reports against relational data on the local computer.

Note:
Because Reporting Services in SQL Server Express is supported on a local server only, you must install Reporting Services and the SQL Server Express Database Engine on the same computer.

To create reports by using Reporting Services, you must also install Business Intelligence Development Studio.

Business Intelligence Development Studio is the Microsoft Visual Studio 2005 environment with enhancements that are specific to SQL Server 2005 business intelligence solutions.

Business Intelligence Development Studio is available as part of Microsoft SQL Server 2005 Express Edition Toolkit (SQL Server Express Toolkit). SQL Server Express Toolkit installs the design tools that are used to create reports. SQL Server Express Toolkit is available for download at this Microsoft Web site.

...and here's where you can download it:

http://www.microsoft.com/downloads/details.aspx?familyid=57856CDD-DA9B-4AD0-9A8A-F193AE8410AD&displaylang=en

Published Tuesday, March 21, 2006 8:12 AM by russch

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: SQL Server 2005 Express Edition and Reporting Services -- At last!

Friday, October 13, 2006 4:52 PM by Ian Ornstein

This is what is on the computer

Microsoft SQL Server Management Studio Express 9.00.2047.00

Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Microsoft MSXML 2.6 3.0 4.0 5.0 6.0

Microsoft Internet Explorer 6.0.2900.2180

Microsoft .NET Framework 2.0.50727.42

Operating System 5.1.2600

Which other files do I need to get the report developer for SQL Server 2005 Express?

The download link above is not available

# re: SQL Server 2005 Express Edition and Reporting Services -- At last!

Tuesday, October 17, 2006 12:29 PM by russch

# re: SQL Server 2005 Express Edition and Reporting Services -- At last!

Monday, May 26, 2008 9:43 PM by leiyah

Just curious.. Will I be able to use Reporting Services 2000 without any problem if I used SQL Express as RS 2000's database instance?

# re: SQL Server 2005 Express Edition and Reporting Services -- At last!

Thursday, December 11, 2008 2:37 PM by vinesh

Microsoft SQL Server 2005 Express Edition Toolkit

to install

 SQL Server 2005 Management Studio Expres

 Business Intelligence Development Studio

http://www.microsoft.com/downloads/details.aspx?familyid=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker