AS per Micrsoft site at
Microsoft SQL Server 2008 Express is a free edition of SQL Server that is ideal for learning, developing and powering desktop, web and small server applications, and for redistribution by ISVs.
To use SSRS with express one need to install SQL Server 2008 with download for "Database
- Supports stored procedures, triggers, functions, and views
Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial data
Improved performance, usability, visualization, in addition to integration with the Microsoft 2007 Office System in SQL Server Reporting Services
Simplify development efforts by leveraging existing T-SQL skills, ADO.NET Entity Framework and LINQ
Closely integrated with Visual Studio and Visual Web DeveloperEditions
There are Three Editions of SQL Server 2008 Express:
SQL Server 2008 Express with Tools
Core edition of Express that supports development. Includes SQL Server 2008 Database Engine and SQL Server Management Studio Express
SQL Server 2008 Express with Advanced Services
Extends SQL Server 2008 Express with tools to include support for Integrated Full-text Search and Reporting Services
SQL Server 2008 Express (Runtime Only)
Includes the SQL Database Engine only and is designed for deployments and ISV redistribution
SQL Server 2008 Management Studio Express
Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008.
Note: This separate download is designed for customers who have previously installed SQL Server 2008 Express (Runtime Only). If you are looking to download SQL Server Express and SSMSE for the first time, please download the above bundle: SQL Server 2008 Express with Tools.
Its better to install the Service pack after you complete your installation
SQL Server Express SP1
SQL Server 2008 Express Edition Service Pack 1 Now Available
Service Pack 1 (SP1) focus on essential updates only, primarily Hotfixes (Roll-up of Cumulative Update 1 to 3) and fixes to issues reported through the SQL Server community.
How does SSRS with Buisness Intellegnet Development Enviornment gets installed?
with Advanced Services"
For SQL Server 2008 R2 Download
For SQl Server 2008 without R2
Why still their a reason to download without R2 version?
Because the report server where you publish your reports may problem with older schema you upload..
Step by Step Installation for report server and Sql server
Configuring your report server on local machine with Windows XP and problem you may face..
Fixing the ACL and Authentication issues :-
Some of the info are given at this site which can be used for further readings
Rest, most of the issue can be fixed by following the steps below..
Back Up your Config at:-
C:\Program Files\Microsoft SQL Server\MSRS10.SQLEXPRESS\Reporting Services\ReportServer\rsreportserver.config
and try replacing the authentication section with the below..
EnableAuthPersistence true EnableAuthPersistence
Assign proper rights to underlying folder for reportserver and reportmanager folder which are loacted at
C:\Program Files\Microsoft SQL Server\MSRS10.SQLEXPRESS\Reporting Services\\
In some cases you may need to create your virtual directories and host your report server and manager from their..
Will let you know why and how alternative options are required in my other post..