• 1. Make sure you are closing the connection after each request made to server. You can check the open connections using below T-SQL.

    SELECT

    DB_NAME(dbid) as DBName, status,

    COUNT(dbid) as NumberOfConnections,

    loginame as LoginName

    FROM

    sys.sysprocesses

    WHERE

    dbid > 0

    GROUP BY

    dbid, loginame, status

    2. Increase the time out of connection object, default is 30 seconds.