Named pipes Provider error

Question

Named pipes Provider error

dopydb

SSCertifiable

Points: 6687
More actions
April 7, 2015 at 8:35 am

#316408

hi
i am attempting to setup ssrs on sql 2012
to test i created a simple query that uses a shared data source, this works fine on the server visual studio/sql is installed on, but if i try on a remote server/laptop i get the below error
* An error has occurred during report processing. (rsProcessingAborted)
o Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
+ Named Pipes Provider: Could not open a connection to SQL Server [5].
the data source uses windows authentication, firewall ports 445 have been opened, named pipes is enabled etc to no avail
any ideas for me?
thanks
mal

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

The [5] would suggest that it's an authentication issue (access denied). E.g. The account that you are running SSRS on the remote server does not have rights to that server/DB. That's just my educated guess; you can test this out by creating an embedded connection using your credentials - if you are successful with that then you know it's an authentication issue.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

dopydb SSCertifiable Points: 6687 More actions · Answer 2

hi Alan

could that be the case even if i am using the same account that works locally?

mal

dopydb SSCertifiable Points: 6687 More actions · Answer 3

ahh..

i forgot to change the over write data source and reports to True - hence my changes where not applying

stupid me !

Alan Burstein SSC Guru Points: 61141 More actions · Answer 4

dopydb (4/7/2015)
ahh..
i forgot to change the over write data source and reports to True - hence my changes where not applying
stupid me !

Haha - I do that all the time. 😛

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001