Intermittent errors on 2005

[beechill4]

Hi,

I'm getting a number of strange errors which we cannot diagnose on a SQL 2005 server.

Date 6/20/2008 11:00:31 AM
Log SQL Agent (Current - 6/20/2008 11:00:00 AM)

Message
[298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001]

Date 6/20/2008 11:00:31 AM
Log SQL Agent (Current - 6/20/2008 11:00:00 AM)

Message
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]


Date 6/20/2008 11:00:31 AM
Log SQL Agent (Current - 6/20/2008 11:00:00 AM)

Message
[298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001]


We are using tcp/ip and named pipes. There is a sql server mirror also. It shows up as (Mirror, Synchronised, Restoring)

The errors above are in the sql agent logs.

Can anyone help as a number of jobs fail when this happens.

Thanks

 

[mrdenny]

The SQL Agent is having problems logging into the SQL Server. Are there other login failures from client applications at this same time?

Are there any high CPU or high IO processes running at this same time?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog