?
Solved

Login on SQL Server hangs

Posted on 2010-09-23
3
Medium Priority
?
253 Views
Last Modified: 2012-05-10
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
Comment
Question by:monicai
3 Comments
 
LVL 11

Expert Comment

by:JoeNuvo
ID: 33751363
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
 
LVL 4

Accepted Solution

by:
monicai earned 0 total points
ID: 33751377
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
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 33751562
>other than restarting the servicesunless you have some existing connection, this will be difficult up to impossible, I fear ...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question