SQL Server 2005 Reporting Services SSRS – Fixing Connection Error
I was completely stumped on this error that I was getting on the report manager web page after I uploaded an RDL file and set it use a shared connection I had already set up:
An error has occurred during report processing.
Cannot create a connection to data source 'TWO'.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
It turns out I had simply mistyped my connection string when I was setting up the shared connection. So that’s something you should check first.