RE: Exceeded Number of Connections

Michael Whisenant ( mwhisen@airnet.net )
Mon, 02 Mar 1998 11:47:36 -0600

I am back in with a single connection right now. I look under the activity
window and see several processes that I am almost sure are not running. It
shows logins as probe (??), radius (several processes under this single
login, yet no radius is running), sa(my current login) and system with 4
processes running. How do I find exactly the number of connections, then
how do I terminate them cleanly? Dale??? Kurt????

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
>