locked
After sql 2008R2 cluster SAN env. migration, keeps getting error: SQL Server Agent - [165] ODBC Error: 0, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001] RRS feed

  • Question

  • hi all:

      We did a SAN migration over the weekend and all seems fine  (2008R2 Ent. ). All seems to be fine and all sql jobs are running fine.

      However, in the sql agent error log, I kept getting this error:

    SQL Server Agent - [165] ODBC Error: 0, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]

    

      After searching in this forum, someone suggested it could be related to a job trying to access outside servers. 

    My question here: 

    1.   I could not find any jobs that are in line with the timeline of those error msgs. 

    2.   What to do if say I found those jobs?   

    Before migration, no such errors . After migration, this kind of error happens everyday.

    Thanks


    --Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

    Tuesday, February 27, 2018 10:11 PM

All replies