| Author |
SQL Server bouncing connections
|
|
| ceadtinneh 2005-09-15, 1:23 pm |
| 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 occurred
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
| |
| John Bell 2005-09-15, 1:23 pm |
| 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 occurred
> 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
>
| |
| dbahooker@hotmail.com 2005-09-28, 11:23 am |
| i would start with making sure you're connecting based on IP and sql
authentication; not windows authentication
|
|
|
|