Monday, March 12, 2012

Reporting Services in SQL Server Express

The SQL Server Express can be downloaded with Advanced Services and thereby Reporting Services are included. I wonder if this is the same Reporting Services as in SQL Server 2005 Standard?

I have heard something that it is a stripped version that is included in the Express download.

Is it so? And if so, what are the differences?

That is correct, it is a stripped down version. You might want to check out this document, you can get what is different between the editions.

http://download.microsoft.com/download/E/8/B/E8B42814-6A0C-40EB-911F-E7ADEC87F5D5/UpgrExptoWkgStd.doc

Jarret

|||

This is a good description of what you do and do not get with Reporting Services in Express Edition with Advanced Services
http://msdn2.microsoft.com/en-us/library/ms365166.aspx

Specifically, these are the features you do not get:

Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.|||

Is it possible to install SQL Express and RS (for SQL Express) on a windows 2003 server and then host an asp.net application on the same server. I am just wondering if the reporting will work from any machine that is running the asp.net app?

I understand RS (Express) must be installed on the same server and it can only access local data on the server but I assume the url report can be accessed and run from any machine that can connect to the server?

No comments:

Post a Comment