Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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