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

Comments (4)

  1. Anonymous says:

    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

  2. Anonymous says:

    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?

  3. Anonymous says:

    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