This article explains what the features supported and unsupported by SSRS with Express Advanced Services are.
IntroductionSQL Server Express is based on SQL Server and supports most of the database engine features. If we design and create a database with SQL Express, we can easily migrate this database to any edition of SQL Server but we will not able to use a database with the Express Edition that was created in a higher version of SQL Server.SQL Server Express with advanced services provide the following features in addition to SQL Server Express.
Features Supported by SSRS with Express advanced servicesSQL Server Express with advanced services provide the following Reporting Services features:
Feature not supported by SSRS with Express advance serviceThe following features are not supported by reporting services with SQL Server Express (with advanced services).
If we are using the User Instance feature (RANU, run as normal user) in SQL Express, the data source will not be available over the remote connections. Remote users who access the report will get the following error when the report data source has been configured for the User Instances feature.
An error has occurred during report processing. Cannot create a connection to data source “<<data source name>>'. For more information about this error, navigate to the report server on the local server machine, or enable remote errors."
Report servers always maintain the log file for the errors. A log file also contains the entry for the preceding error.
Cannot create a connection to data source “<datasourcename>”. ---> System.Data.SqlClient.SqlException: User does not have permission to perform this action.
SummarySQL Server Reporting Services with SQL Express advanced services is a good choice as a reporting tool with no license cost. Every tool has certain limitations and SSRS also has some limitations. In this article, I have explain what the limitations of SSRS are when using Express advanced services.
Building Standalone Data-Driven Applications using SQL Server Compact 4.0