RE: [SQLDownUnder] Cannot connect to SQL Server 2005 at all (even locally)

[Ekasenna Tjhauw]

Hi Greg,

 

Thanks for the prompt reply.

 

Yes, I did.

 

I have tried to disable the remote connection and then tried to connect locally from the console.

But it still did not work (I have tried all possible combination of the 3 protocols, shared memory, named pipes & tcp/ip).

 

When I cannot connect locally, that was the thing that confused me, what's going on here.

 

It was working perfectly on the weekend until my administrator update the server (2003) with the following patches:

1. Vulnerability in Web Client Service Could Allow Remote Code Execution (911927)

2. Vulnerability in TCP/IP Could Allow Denial of Service (913446)

3. Australian daylight saving time 2006 update (912475)

 

I also did uninstall those patches but still having no luck to connect locally.

 

I have tried to google as well, but still no luck.

 

Aaarrrrrggggghhhhh,

 

Eka

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Greg Low
Sent: Monday, 27 March 2006 1:56 PM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [SQLDownUnder] Cannot connect to SQL Server 2005 at all (even locally)

Hi Ekasenna,

 

Have you run the Surface Area Configuration Tool and looked at the state of the network protocols?

 

Regards,

 

Greg

 

Dr Greg Low

Readify - Senior Consultant

M: +61 419 201 410

 

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Ekasenna Tjhauw
Sent: Monday, 27 March 2006 12:19 PM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: [SQLDownUnder] Cannot connect to SQL Server 2005 at all (even locally)
Importance: High

Dear all,

 

I had a connection issue today where I cannot connect to the sql server 2005 at all, even locally.

 

Here is the error:

Exception Message: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (type SqlException)
SQL Exception Class: 20
SQL Exception Number: 233
SQL Exception Procedure:
SQL Exception Line Number: 0
SQL Exception Server: SQL05

SQL Exception State: 0
SQL Error(s):

 

I have tried all the combination protocol, all gave the same error.

 

Please help me.

 

Eka

to unsubscribe to this list, please send a message 
back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - 
List managed by http://www.readify.net to unsubscribe to this list, please send 
a message back to the list with 'unsubscribe' as the subject. Powered by 
mailenable.com - List managed by http://www.readify.net 



to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net