Connection Problem accessing a SQL server

Hello,
I have a PC with an application using SQL on a  SBS 2003 server and the SQL
database is on a SBS 2000 server.  I get from the SBS 2003 server to the SBS
2000 server through a router.  The IP address are non-routable so it does
not go out over the internet.  When I execute the application on the SBS
2003 the first couple of screens that access the database work just fine and
the response time is good.  I then try another transaction and I get the
Connection failed: SQLState '01000' SQL Server Error: 10060  followed by
Connection failed: SQLState '08001' SQL Server Error: 17.  I do not have a
clue what is causing this problem nor can I find a reason.  If  I reply
'yes' to the connection boxes that come up on the screen eventually the
connection is re-instated and I can do a couple more transactions before the
failure occurs again.  I am using ODBC to connect  any help would be
appreciated.  I am wondering if the topology of the network is an issue.
The sequence of events is PC --> Switch --> SBS 2003 Server --> Router -->
SBS 2000 Server -->  SQL 2000.  I do not think this is the problem but I
thought I mention it.  I also thought about ISA but I can do the
transactions initially that must mean the ports are opened.  If I direct
connect the PC to the SBS 2000 server I do not have a problem with the
transactions timing out..
Thank You,

Joe

Hi

You may want to look at SQL profiler to see what statements are being
executed by the SQL Server and if the statements complete after the client
has timed out. You may also want to look for blocking.

If you are getting timeout errors, have you configured the timeout? What
time does it take to timeout?

You may also want to look at the protocols you are using and try a different
one.

John

"Joe Bucar" <jbucar@hotmail.com> wrote in message
news:uLVa%234HlFHA.1148@TK2MSFTNGP12.phx.gbl...
> Hello,
> I have a PC with an application using SQL on a  SBS 2003 server and the
> SQL database is on a SBS 2000 server.  I get from the SBS 2003 server to
> the SBS 2000 server through a router.  The IP address are non-routable so
> it does not go out over the internet.  When I execute the application on
> the SBS 2003 the first couple of screens that access the database work
> just fine and the response time is good.  I then try another transaction
> and I get the Connection failed: SQLState '01000' SQL Server Error: 10060
> followed by Connection failed: SQLState '08001' SQL Server Error: 17.  I
> do not have a clue what is causing this problem nor can I find a reason.
> If  I reply 'yes' to the connection boxes that come up on the screen
> eventually the connection is re-instated and I can do a couple more
> transactions before the failure occurs again.  I am using ODBC to connect
> any help would be appreciated.  I am wondering if the topology of the
> network is an issue. The sequence of events is PC --> Switch --> SBS 2003
> Server --> Router --> SBS 2000 Server -->  SQL 2000.  I do not think this
> is the problem but I thought I mention it.  I also thought about ISA but I
> can do the transactions initially that must mean the ports are opened.  If
> I direct connect the PC to the SBS 2000 server I do not have a problem
> with the transactions timing out..
> Thank You,
>
> Joe
>