Solved

Login on SQL Server hangs

Posted on 2010-09-23
3
243 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 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
best counters for cpu high usage 3 33
SQL Replication question 9 43
sql server insert 12 30
What's wrong with this T-SQL Foreign Key? 7 46
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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
Viewers will learn how the fundamental information of how to create a table.

803 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