MS SQL Server - Sql Server Connection Problem (existing connection forcibly closed

Author

Sql Server Connection Problem (existing connection forcibly closed

Shailen Sukul

2006-11-09, 7:14 pm

A few days ago, my dev Sql Server 2005 database instance started rejecting
connections. I have created a dump of the error message below.

So far I have tried the following to no avail.
1. Used the surface area configuration tool to allow named pipes and tcp
connections.
2. Used the sql configuation tool to allow tcp connections to come before
named pipes.

This is really strange as my database was working fine until a couple of
days ago. The only thing I did diferrent was to create a Web application on
the same dev machine a few days ago, and it had a Sql Server EXPRESS
database. I have since deleted that web application but it did not fix my Sql
Server login issues.

Any help will be greatly appreciated.

--
Many Thanks.

Shailen Sukul
Architect
(BSc MCTS, MCSD.Net MCSD MCAD)
Ashlen Consulting Service P/L
(http://www.ashlen.net.au)
Error Message from Sql Management Window:

A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.)(Microsoft SQL
Server, Error: 10054)

Dump of Application Log from my Event Viewer:

Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 1000
Date: 9/11/2006
Time: 8:45:37 PM
User: N/A
Computer: ASHDEV01
Description:
Faulting application w3wp.exe, version 6.0.3790.1830, stamp 42435be1,
faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault
address 0x01b55f80.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 77 00 33 00 77 00 .w.3.w.
0030: 70 00 2e 00 65 00 78 00 p...e.x.
0038: 65 00 20 00 36 00 2e 00 e. .6...
0040: 30 00 2e 00 33 00 37 00 0...3.7.
0048: 39 00 30 00 2e 00 31 00 9.0...1.
0050: 38 00 33 00 30 00 20 00 8.3.0. .
0058: 34 00 32 00 34 00 33 00 4.2.4.3.
0060: 35 00 62 00 65 00 31 00 5.b.e.1.
0068: 20 00 69 00 6e 00 20 00 .i.n. .
0070: 75 00 6e 00 6b 00 6e 00 u.n.k.n.
0078: 6f 00 77 00 6e 00 20 00 o.w.n. .
0080: 30 00 2e 00 30 00 2e 00 0...0...
0088: 30 00 2e 00 30 00 20 00 0...0. .
0090: 30 00 30 00 30 00 30 00 0.0.0.0.
0098: 30 00 30 00 30 00 30 00 0.0.0.0.
00a0: 20 00 66 00 44 00 65 00 .f.D.e.
00a8: 62 00 75 00 67 00 20 00 b.u.g. .
00b0: 30 00 20 00 61 00 74 00 0. .a.t.
00b8: 20 00 6f 00 66 00 66 00 .o.f.f.
00c0: 73 00 65 00 74 00 20 00 s.e.t. .
00c8: 30 00 31 00 62 00 35 00 0.1.b.5.
00d0: 35 00 66 00 38 00 30 00 5.f.8.0.
00d8: 0d 00 0a 00 ....

RBC

2006-11-09, 7:14 pm

Try this...

http://support.microsoft.com/defaul...bEN-US%3b914277

"Shailen Sukul" wrote:

> A few days ago, my dev Sql Server 2005 database instance started rejecting
> connections. I have created a dump of the error message below.
>
> So far I have tried the following to no avail.
> 1. Used the surface area configuration tool to allow named pipes and tcp
> connections.
> 2. Used the sql configuation tool to allow tcp connections to come before
> named pipes.
>
> This is really strange as my database was working fine until a couple of
> days ago. The only thing I did diferrent was to create a Web application on
> the same dev machine a few days ago, and it had a Sql Server EXPRESS
> database. I have since deleted that web application but it did not fix my Sql
> Server login issues.
>
> Any help will be greatly appreciated.
>
> --
> Many Thanks.
>
> Shailen Sukul
> Architect
> (BSc MCTS, MCSD.Net MCSD MCAD)
> Ashlen Consulting Service P/L
> (http://www.ashlen.net.au)
> Error Message from Sql Management Window:
>
> A connection was successfully established with the server, but then an error
> occurred during the pre-login handshake. (provider: TCP Provider, error: 0 -
> An existing connection was forcibly closed by the remote host.)(Microsoft SQL
> Server, Error: 10054)
>
> Dump of Application Log from my Event Viewer:
>
>
> Event Type: Error
> Event Source: .NET Runtime 2.0 Error Reporting
> Event Category: None
> Event ID: 1000
> Date: 9/11/2006
> Time: 8:45:37 PM
> User: N/A
> Computer: ASHDEV01
> Description:
> Faulting application w3wp.exe, version 6.0.3790.1830, stamp 42435be1,
> faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault
> address 0x01b55f80.
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
> 0008: 69 00 63 00 61 00 74 00 i.c.a.t.
> 0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
> 0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
> 0020: 75 00 72 00 65 00 20 00 u.r.e. .
> 0028: 20 00 77 00 33 00 77 00 .w.3.w.
> 0030: 70 00 2e 00 65 00 78 00 p...e.x.
> 0038: 65 00 20 00 36 00 2e 00 e. .6...
> 0040: 30 00 2e 00 33 00 37 00 0...3.7.
> 0048: 39 00 30 00 2e 00 31 00 9.0...1.
> 0050: 38 00 33 00 30 00 20 00 8.3.0. .
> 0058: 34 00 32 00 34 00 33 00 4.2.4.3.
> 0060: 35 00 62 00 65 00 31 00 5.b.e.1.
> 0068: 20 00 69 00 6e 00 20 00 .i.n. .
> 0070: 75 00 6e 00 6b 00 6e 00 u.n.k.n.
> 0078: 6f 00 77 00 6e 00 20 00 o.w.n. .
> 0080: 30 00 2e 00 30 00 2e 00 0...0...
> 0088: 30 00 2e 00 30 00 20 00 0...0. .
> 0090: 30 00 30 00 30 00 30 00 0.0.0.0.
> 0098: 30 00 30 00 30 00 30 00 0.0.0.0.
> 00a0: 20 00 66 00 44 00 65 00 .f.D.e.
> 00a8: 62 00 75 00 67 00 20 00 b.u.g. .
> 00b0: 30 00 20 00 61 00 74 00 0. .a.t.
> 00b8: 20 00 6f 00 66 00 66 00 .o.f.f.
> 00c0: 73 00 65 00 74 00 20 00 s.e.t. .
> 00c8: 30 00 31 00 62 00 35 00 0.1.b.5.
> 00d0: 35 00 66 00 38 00 30 00 5.f.8.0.
> 00d8: 0d 00 0a 00 ....
>
>
>
>

Sponsored Links