SqlClient connection to SQL 2005 creates 5000 tcp connections!

From: John Rivers <first10@xxxxxxxxxxxxxx>
Date: Tue, 30 Oct 2007 08:07:09 -0700

Hello

Connecting to SQL 2005 Developer Edition with .NET 1.1 SqlClient

If I attempt to connect using TCP/IP all is well

but if I try and use shared memory (Server='.' and remove
Net='dbmssocn')

cpu usage goes to 100% for about 30 seconds

netstat -an

produces a list of exactly 5000 failed tcp connection attempts to port
1433

Has anyone else experience this bizarre behaviour ?

John

.

Prev by Date: Re: CONTAINS and wildcard
Next by Date: Re: Open SQL 2005 database question
Previous by thread: some error in table definition
Next by thread: get some rows into one column
Index(es):
- Date
- Thread

Relevant Pages

Re: Crossover cable problem
... I am connecting two computers (both ... Enable NetBIOS Over TCP/IP ... To enable NetBIOS Over TCP/IP: ...
(microsoft.public.windowsxp.network_web)
Strange One - TCP 1052
... difficulty connecting to SQL services using TCP/IP. ... 1052 on the Rightfax server, even after stopping the Rightfax services. ... traffic on port 1052. ...
(NT-Bugtraq)
RE: MSDE 2000 sp3a microsoft JDBC & W98
... Are you sure the MSDE instance is listening on TCP/IP? ... That tells you which IPs and port the server is listening on. ... connect dialog to force connecting with TCP/IP. ...
(microsoft.public.sqlserver.jdbcdriver)
Re: Can connect VISTA BUSINESS to SBS 2003
... In the end I just uninstalled Vista ... I hope you consider looking into your DNS setup and fixing those issues. ... i've had problems with vista biz connecting to sbs too. ... NetBIOS over TCP/IP in advanced TCP/IP settings on TCP/IPv4 and everything ...
(microsoft.public.windows.server.sbs)
Re: JDBC and Virtual Machines
... it is connecting with NTLM instead of TCP/IP and try to verify TCP/IP was ... but this one isn't running inside a virtual server. ... connect with NTLM but JDBC drivers only support TCP/IP. ...
(microsoft.public.sqlserver.jdbcdriver)