SQL 2000: How to set idle connection time out?

[leo_b]

HEELLP

I have a sql server that serving about 200 client. We also have application that running under windows 2000 server connecting to SQL server.

At the begining transaction the server still working well. But after half of an hour the connection in the server size up, i use server performance monitoring to check SQL server connection. Last time i saw it was 780.000 connection. What happen with the server? please help. I am really in deep trouble.




NB:
My SQL SERVER has SP3 running with 4 Gig RDRAM.

[skhanal]

From the profile try to find out what application or client is making that many connections.

If you use middle tier component, then it may not be using connection pooling or not disconnecting after finishing its job

There is no setting for idle timeout in sql server.

[leo_b]

Thanks a lot. But for your information we used crystal report to our custom made web application. We used 8.1 version. Is there any documentation or reference other than seagate website?

I really need this problem to be solved soon.

TIA