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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 6:22 AM
Points: 510, Visits: 1,894
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: Wednesday, December 10, 2014 2:52 AM
Points: 154, Visits: 678
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 6:22 AM
Points: 510, Visits: 1,894
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