January 24, 2013 at 1:13 pm
I have a 2-part question.
I have a data source called LMSCustomDataSource that appears on the Home page of the Report Manager (LMSCustomDataSource has the yellow database icon with 4 arrows next to it). I therefore in my .rdl file have the <DataReference> as /LMSCustomDataSource. Does that sound correct?
I ask because whereas I can View the report just fine, when I create a Standard Subscription for the report, it doesn't work, failing with an error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
BUT Subscriptions for other reports, created with the Report Builder, put their data sources in a folder called Data Sources that appears on the Home page, and these Subscriptions work just fine.
So I am wondering if Subscriptions looks in Data Sources only for a data source, possibly not respecting the <DataReference>. Anyone know?
Thanks.
January 31, 2013 at 2:13 pm
Usually data sources are kept in the Data Sources directory. When you say that you can run it fine, do you mean from Visual Studio on your development machine? If so make sure that the data source in your project matches what is on the server. Common practice is to Not deploy your datasource every time you deploy a report. So it is conceivable that your data source in VS does not match what is on the server.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply