I work for a web development/web hosting company and we are currently
developing a site in CF MX7 (residing on our CF7 server) that connects to a
client's Microsoft SQL Server. However, this site is only in development and
never has more than one person accessing it at a time.

We keep this Connection Reset error on various pages that try to execute
cfquery statements:
[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to
contact the server (Server returned: Connection reset). Please ensure that the
server parameters passed to the driver are correct and that the server is
running. Also ensure that the maximum number of connections have not been
exceeded for this server.

This error happens about 20-25% of the time.

We also have a CF5 server that connects to this same client's SQL server for
dozens of web sites without much trouble (considering that the connection is
remote and has to go through 2 firewalls, and the packets have to be re-written
at some point). The only time we have trouble with this server is if the remote
server is actually offline.

It seems that the number of connections are being exceeded, but I can't figure
it out, as the other server has never run into this issue and this server is
hardly connecting to this database server.

Are there any problems with JDBC connecting to remote servers vs ODBC (CF5)?

Anyone have any ideas? There's no way we can launch a site that can't even
handle a single user.