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 ««12

Error: Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 10:12 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:43 AM
Points: 442, Visits: 620
Thanks Gift Peddie

Mine are enabled, so must be another issue


Jim
Post #1433890
Posted Friday, March 22, 2013 12:46 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
JC-3113 (3/21/2013)
Thanks Gift Peddie

Mine are enabled, so must be another issue


Jim


But 2005 also comes with surface area configuration tool check for remote connection and both Named Pipes and TCP/IP are enabled in the surface area configuration tool. If the problem continues then go to the links I posted and read up on the many known issues and other ways to fix it.


Kind regards,
Gift Peddie
Post #1434478
Posted Friday, March 22, 2013 1:01 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:43 AM
Points: 442, Visits: 620
Hi Gift Peddie


parameters are all okay

This databases are on a Virtual server and the admin made some changes last Thu
Have been having issues ever since so I am not sure just what he did

also seeing these types of msgs:

[382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
[165] ODBC Error: 0, Unable to complete login process due to delay in opening server connection [SQLSTATE 08001]
[298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001]


so I am not sure just what he did at this time
will have to do some more investigating

appreciate your time and expertise

Jim
Post #1434485
Posted Friday, March 22, 2013 1:40 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
JC-3113 (3/22/2013)
Hi Gift Peddie


parameters are all okay

This databases are on a Virtual server and the admin made some changes last Thu
Have been having issues ever since so I am not sure just what he did

also seeing these types of msgs:

[382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
[165] ODBC Error: 0, Unable to complete login process due to delay in opening server connection [SQLSTATE 08001]
[298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001]


so I am not sure just what he did at this time
will have to do some more investigating

appreciate your time and expertise

Jim


Then the changes could be the reasons for your problem, if the server is not busy see if you can stop and restart both the server and SQL Server.


Kind regards,
Gift Peddie
Post #1434503
Posted Monday, March 25, 2013 9:40 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:43 AM
Points: 442, Visits: 620
Hi Gift Peddie

unable to do until Thursday night as that is when maint is.

Jim
Post #1434987
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse