We are connecting to sql server with Java and jsp as front end for our application. We are almost 10 people connecting to same machine regularly. earlier, we were just 4 or 5 connecting to one machine, now all are connecting to same machine, coz of some policy reasons.
Now it stops responding to queries from application after ever few minutes or can say abt half hour, requires to restart.
is the reason be number of users connected. if so, i dont believe it should, as servers connect to hundreds of users at a time. PLease help to rectify this issue or to make it available for more users.
thanx in advance