Re: Exceeded Number of Connections

Dale E. Reed Jr. ( (no email) )
Mon, 02 Mar 1998 12:31:00 -0800

Michael Whisenant wrote:
>
> 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????

If you just restarted SQL Server, the connections it lists are
real. probe is the replication user. system is most likely SQL
executive. Why do you want to kill them?

If SQL Server is recovering your Emerlad database, you might have
to wait until its done before using the database. It may take a
while.

Also, you should always try to stop SQL Server before rebooting
a machine. It will gurantee that it goes down cleanly.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com