Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Shared Memory Provider Error Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 3:02 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:29 PM
Points: 327, Visits: 852

I 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 HYT00




Is this memory issue?

I checked one of the db properties.

it had Size = 151899 MB
Space Available = 75.13 MB
Number of Users = 20

Should 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.
Post #1473240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse