Solved SQL Express problem with SSRS when using an expression based connection string
-
Situation: I have a fully working system running on Server 2008 with SQL Server 2008 that I am migrating to Server 2012 R2 VM with SQL Server Express with Advanced Services (in order to get the Reporting Services component).
Problem: Here is the Microsoft error message
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Dynamic'. (rsErrorOpeningConnection)
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services. (rsOperationNotSupported)Pretty straight forward, but to be 100% clear, is this telling me that I cannot use an expression based data source? Instead, I am required to use a local data source?
-
Are you coming from a Licensed SQL Server and switching to Express?
-
@dafyre said:
Are you coming from a Licensed SQL Server and switching to Express?
I was hoping to, yes. The application is extremely light and the fact that Express can now handle a DB up to 10GB is more than enough.
The problem seems to be that Express only allows you to communicate with itself or a localdb file. While the expression string is still only connecting to the SQLEXPRESS instance, you could in theory tell it to connect to anything there so MS seems to simply have disabled the entire feature there instead of do something else to ensure the connections stay local.
-
That is what I was thinking. SQL Server 2008 should install just fine on Server 2012 IIRC.
-
@dafyre said:
That is what I was thinking. SQL Server 2008 should install just fine on Server 2012 IIRC.
That is not what I am trying to do. We want 2014. We will purchase it if required, but that is $3000-$6000 that could be saved if not needed.
-
@JaredBusch Ah, cool. Then it looks like you may have to pay it.
-
To the best of my knowledge, the Express Editions do not have an Agent. You might also encounter another issue if you rely on report subscriptions.
