[dba-SQLServer] SQL 2005 Express v. SQL 2005 Express withAdvancedServices

Gustav Brock Gustav at cactus.dk
Sun Feb 24 16:10:51 CST 2008


Hi Susan

That seems to be so:

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx 

<quote>
Reporting Services

Like MSDE, SQL Server 2005 Express does not possess business intelligence (BI) features such as Analysis Services, Integration Services, or data mining. However, SQL Server 2005 Express does provide support for Reporting Services. While the initial version of SQL Server 2005 Express did not include support for Reporting Services, it is now available via separate downloads. SQL Server 2005 Express Edition with Advanced Services provides the Report Server. The SQL Server 2005 Express Toolkit provides the Business Intelligence Development Studio.

SQL Server 2005 Express can act as a data source for relational data that is on your local server for Reporting Services. Plus, Reporting Services in SQL Server 2005 Express can render reports in Excel, PDF, Image, Print, and DHTML formats. The Report Manager utility in SQL Server 2005 Express manages reports. Reporting Services reports used in SQL Server 2005 Express are completely compatible with the Reporting Services in the other SQL Server 2005 editions.
</quote>


>>> ssharkins at gmail.com 24-02-2008 22:04 >>>
When we wrote the book on Express, it didn't support Reporting Services. We 
were working with the beta (what a royal pia -- worst betas ever). It's 
possible that once it was released they got so many requests/complaints that 
they added it, but I really don't know Arthur -- I haven't kept up with 
Express as I should've. I really thought that would be my last tech book and 
I had planned to give up tech articles too -- so much for best laid plans. 
:(

Susan H.


> Puzzling thing. In the chart Dan pointed to, it appears that the basic
> edition doesn't contain Reporting Services. But I just installed it and it
> appears to. Maybe that chart predates some revised version of the basic
> express edition.






More information about the dba-SQLServer mailing list