Re: Exceeded Number of Connections

System Operator ( sysop@i-star.net )
Mon, 02 Mar 1998 12:47:48 -0500

Try rebooting the machine, then go right to MSQL.
That's what I did about two weeks ago.

Dean Morris

Michael Whisenant wrote:
>
> I tried that already. It reports first that database has not yet
> recovered. It then recovers and locks me out. Any further
> thoughts/suggestions?
>
> At 09:37 AM 3/2/98 -0800, you wrote:
> >First, restart SQL, this will kill all connections and allow you to get into
> >it, then up the connections to a higher value...
> >
> >HTH,
> >
> >Jeremy Domingue
> >Tehachapi Mountain Internet
> >jer@tminet.com
> >
> >> -----Original Message-----
> >> From: Michael Whisenant [mailto:mwhisen@airnet.net]
> >> Sent: Monday, March 02, 1998 9:28 AM
> >> To: emerald@emerald.iea.com
> >> Subject: Exceeded Number of Connections
> >>
> >>
> >> Another new one for me. I had raised several months ago the max number of
> >> logins to 30. This months call consolidation crashed and burned, yet
> >> again, and now I can not get into the SQL server as it reports that I have
> >> exceeded the number of connections. I can not attach with any SQL, RADIUS
> >> has bombed. I need to know how do I get into SQL so I can Kill some
> >> processes, or something to get back online.
> >>
> >>
> >> ----------------------------------------------------------
> >> Emerald Mailing List listserver@emerald.iea.com
> >>
> >
> >
> > ----------------------------------------------------------
> > Emerald Mailing List listserver@emerald.iea.com
> >
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com

-- SysOp (System Operator)=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-I-STAR ONLINE System Operations ManagementVoice: 517-739-3552  Fax: 517-739-8913Hours: Mon-Fri  10am to 7pm        Saturday 10am to 5pm        Sunday   Closed Web Help: http://www.i-star.com/support/=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-