Named Pipes Provider: Could not open a connection to SQL Server [53]
Submitted by manjunathcbhat on Fri, 04/11/2014 - 05:32
Today I had a series of Job Failures and the only common error I could see in my logs was "Named Pipes Provider: Could not open a connection to SQL Server [53]"
After investigating, it was discovered that, there was a network connectivity breakdown. Re-Running all of my Job was successful. In general, this error is issued when you are running a SSIS Package or a SQL Server Agent Job, and during execution, the connectivity to server is lost.