SQLServerCentral.com / Administering / SQL Server 2005 / Shared Memory Provider Error / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 12:43:44 GMT20RE: Shared Memory Provider Errorhttp://www.sqlservercentral.com/Forums/Topic1473240-146-1.aspxOkay! :cool: Thanks for replying back.Thu, 07 May 2015 15:21:11 GMTPatti JohnsonRE: Shared Memory Provider Errorhttp://www.sqlservercentral.com/Forums/Topic1473240-146-1.aspxIt happens randomly. May be once in 2-3 months. I'm just putting up with it.Thu, 07 May 2015 15:19:19 GMTSQL_SurferRE: Shared Memory Provider Errorhttp://www.sqlservercentral.com/Forums/Topic1473240-146-1.aspxDid it ever go away or did you just put up with it? We have transaction log backups that run every 15 mins when it happens. 10 backups will fail all at the same time and some of them will go to success.Thu, 07 May 2015 15:17:44 GMTPatti JohnsonRE: Shared Memory Provider Errorhttp://www.sqlservercentral.com/Forums/Topic1473240-146-1.aspxNo. But it seems like too much processing going on the server during that time. So, could be CPU pressure as well. But I'm not sure exactly to be honest.Thu, 07 May 2015 15:15:06 GMTSQL_SurferRE: Shared Memory Provider Errorhttp://www.sqlservercentral.com/Forums/Topic1473240-146-1.aspxDid you ever get an answer to your problem? I have the same problem right now.Thu, 07 May 2015 15:12:59 GMTPatti JohnsonShared Memory Provider Errorhttp://www.sqlservercentral.com/Forums/Topic1473240-146-1.aspxI experienced this type of error today in SQL server instance.[298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001] [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001][165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00Is this memory issue?I checked one of the db properties.it had Size = 151899 MBSpace Available = 75.13 MBNumber of Users = 20Should this of concern?Anybody can shed some light on this as where to start? SQL instance didn't accept any connections for about 20 minutes and after that it was fine. I am on SQL server 2005.Fri, 12 Jul 2013 15:02:53 GMTSQL_Surfer