I experienced this type of error today in SQL server instance.
 SQLServer Error: 258, Shared Memory Provider: Timeout error . [SQLSTATE 08001]
 SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
 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.