QUESTION POSED ON: 08 July 2004
We are receiving "Max Connections has reached" error message while logging
on to SQL Server database through applications. Then the application quits.
Server Config.: SQL 7 with SP7 on NT 4 with SP5.
Workstations - Win 95 and 98.
Default Client connectivity Protocol - TCP/IP
and connecting through - ODBC.
Note:
- We never set any connection limit on the SQL Server Properties.
- License configuration - Per Seat
- We have 70 client access licenses, but less than 50 users are using
the application at a time.
- Once the user logs on to the application, SQL Server creates more than five
connections for each user. Sometimes it exceeds more than 10. I can see this
through current activity in the Enterprise Manager.
Whenever we face this problem we have to go to License Manager and revoke
the license connections under SQL Server. Then we can logon to our
application.
How do I solve this problem?
|
