• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Login on SQL Server hangs

Hello guys!

One of my users says that they cannot login to the database system.  

Upon checking the event logs, we discovered something like this:

Process ID 71:12 owns resources that are blocking processes on Scheduler 5.

I found out that we had a batch processes that was running that was running for hours.  When I try to login to the Enterprise manager to find out, I cannot login anymore.  It hangs.   I thought of DAC but it is not available for SQL Server 2000.  

Any bright ideas would help.

Thanks!
0
monicai
Asked:
monicai
2 Solutions
 
JoeNuvoCommented:
try connect using Query Analyser
and see if below link can help you go and kill the trouble process

http://sqlserverplanet.com/dba/using-sp_who2/

note : in order to kill process, be sure that it won't cause you any other problem.
0
 
monicaiAuthor Commented:
the problem is i couldn't even logon to the query analyzer.  the logon hanged for some reason.
anyway, I had no choice but to restart the sql server and agent services.  after that, we are able to log on successfully.

i wonder if there were any other workaround other than restarting the services.  would like to to hear other suggestions for my own benefit.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>other than restarting the servicesunless you have some existing connection, this will be difficult up to impossible, I fear ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now