Re: sqlclient: existing connection was forcibly closed

I saw that post regarding flipping off Shared Memory. I tried it and it
seems to work.

I wonder:
-does Microsoft know about this?
and
-Why aren't more people seeing it?

The box that runs my SQL Server instance also runs a series of processes
that access the db, these processes might automatically use the shared memory
model vs. TCP (although I am not changing the connectstr, I still specify
TCP). Perhaps my situation is more stressful than others causing this bug to
appear.


"Andrew J. Kelly" wrote:

Some associated links:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=134053&SiteID=17

http://channel9.msdn.com/ShowPost.aspx?PostID=239593


This is what someone else who had this issue did:

I went into the Sql Server Configuration Manager, Sql Native Client
Configuration -> Protocols and disabled Shared Memory and made the TCP/IP
protocol #1 in order. Then just restarted the Sql Service and it all
started
working!
<<

--
Andrew J. Kelly SQL MVP

"pb" <pb@xxxxxxxxxxxxxxxxx> wrote in message
news:1CF8C7D3-F472-46CF-8F8F-467545DA869F@xxxxxxxxxxxxxxxx

i just made the switch from OLEDB to SqlClient in my .Net apps.

now with SqlClient often my db calls throw the following exception:

System.Data.SqlClient.SqlException: A transport-level error has occurred
when sending the request to the server. (provider: TCP Provider, error:
0 -
An existing connection was forcibly closed by the remote host.) at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean
breakConnection) at...

this happens when the load (or call rate) increases. I don't think its
anything I am doing unless I am missing a connect option.

my production environment is:
client side
Windows Server 2003 sp2
.net 2.0

server side
Windows Server 2003 sp2
Sql Server 2005 sp2

Also, on my development machine running Vista, it does not appear that
this
happens.






.

Relevant Pages

  • Re: SQL 2005 update auf SP2 geht nicht
    ... Am WE habe ich versucht das aktuelle SP2 9.0.3042 einzuspielen. ... Gebit es eine Möglichkeit das korrekte SP2 auf den Server zu bekommen, oder muss der SQL Server neu installiert werden; da laufen Replikationen und desshalb möchte ich ungern den Weg der Neuinstallation gehen. ... Ist das Setup bereits mittels Administrator erfolgt, ...
    (microsoft.public.de.sqlserver)
  • Re: sqlclient: existing connection was forcibly closed
    ... Andrew J. Kelly SQL MVP ... The box that runs my SQL Server instance also runs a series of processes ... Configuration -> Protocols and disabled Shared Memory and made the TCP/IP ... Windows Server 2003 sp2 ...
    (microsoft.public.sqlserver.clients)
  • Re: Public role not in server role
    ... I have verified that engine and management studio are to the RTM version. ... As your original premiss was that the server was on SP2 and the client ... The SQL Server 2005 RTM is onto a production server and it will be hard ...
    (microsoft.public.sqlserver.server)
  • Re: Problem Connecting to Sql Server 2005 locally by Name
    ... When you connect locally by name, SQL Server Native Client uses shared memory. ... there and the test connection worked. ...
    (microsoft.public.sqlserver.connect)
  • Re: Public role not in server role
    ... "John Bell" wrote: ... The SQL Server 2005 RTM is onto a production server and it will be hard to ... obtain the authorization for an upgrade to SP2. ...
    (microsoft.public.sqlserver.server)