SQL Server bouncing connections

Hello Folks,

Our web based application accesses our SQL Server 2k database using a
connection pool of about 150 connections through a BEA JDBC driver.

We recently had a situation where one of our app servers lost
connectivity to the database server (the BEA error logs indicated the
following:

java.sql.SQLException: [BEA][SQLServer JDBC Driver]A problem occurre
d
when attempting to contact the server (Server returned: Connection
reset by peer.)

We're trying to eliminate possibilities  and I was wondering under
which circumstances would SQL Server close one of these pooled
connections. Any ideas?

Thanks in advance...

Joe

Hi

You may want to read
http://support.microsoft.com/defaul...kb;en-us;109787 which implies
that this is most likely a network issue.

John

"ceadtinneh" <sulla33@yahoo.com> wrote in message
news:1126799546.347327.125860@g43g2000cwa.googlegroups.com...
> Hello Folks,
>
> Our web based application accesses our SQL Server 2k database using a
> connection pool of about 150 connections through a BEA JDBC driver.
>
> We recently had a situation where one of our app servers lost
> connectivity to the database server (the BEA error logs indicated the
> following:
>
> java.sql.SQLException: [BEA][SQLServer JDBC Driver]A problem occur
red
> when attempting to contact the server (Server returned: Connection
> reset by peer.)
>
> We're trying to eliminate possibilities  and I was wondering under
> which circumstances would SQL Server close one of these pooled
> connections. Any ideas?
>
> Thanks in advance...
>
> Joe
>

i would start with making sure you're connecting based on IP and sql
authentication; not windows authentication