Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Query execution failed for data set DataSet1

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2013-12-18 : 12:05:15
I have an issue with a report, the error message is:

Query execution failed for data set 'DataSet1'
Named Pipes Provider: Could not open a connection to SQL Server [53]


I get this issue in Visual Studio as well and not just on Report manager.

My data source is fine, I can test the connection without any issues, I'm connecting using the sa password so I doubt this is a permissions issue.

Any help would be appreciated.

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-19 : 04:56:22
are you storing credentials in report server?


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -