June 25, 2013 at 8:17 am
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.
June 25, 2013 at 8:47 am
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
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
June 26, 2013 at 2:55 am
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.)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply