Solved

Login on SQL Server hangs

Posted on 2010-09-23
3
245 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

756 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