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

'No process is on the other end of the pipe' Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 8:17 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:56 AM
Points: 451, Visits: 1,665
When I try to log in to one instance of SQL Server as anything other than sa*, I get the following error message (hopefully attached). Short version is

a connection was successfully established with the server, but then an error occurred during the login process. No process is on the other end of the pipe.

I've Googled it but haven't found much.

SQL Server 2008 Standard Edition.

Mixed authentication mode is ON.

Max user connections is set to 0 (unlimited)

The password is correct.

Shared Memory is enabled

Named Pipes is enabled

TCP/IP is enabled

VIA is disabled

Any ideas please?


* edit: Windows authentication works fine. It's just SQL Server authentication that seems to cause this.


  Post Attachments 
Error 233.png (7 views, 11.49 KB)
Post #1467183
Posted Tuesday, June 25, 2013 8:47 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 10:27 AM
Points: 137, Visits: 590
Is this a remote connection? It sounds like a named instance, so have you got the SQL Server Browser service running?

Have you checked that Named Pipes is enabled for the Network Configuration?

http://msdn.microsoft.com/en-us/library/ms175496(v=sql.105).aspx
Post #1467208
Posted Wednesday, June 26, 2013 2:54 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:56 AM
Points: 451, Visits: 1,665
Weirdly it's not a remote connection, but I can see why you're asking. Thanks though. It seems to be puzzling people all over the internet because I haven't found an answer yet! (It's not urgent, I have a workaround, but it's bugging me.)
Post #1467517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse