?
Solved

Problem with SQL Server when Query Analyzer is run at the actual SQL server

Posted on 2011-09-20
8
Medium Priority
?
397 Views
Last Modified: 2012-05-12
We have a very peculiar situation.  

At the actual SQL Server when we run the Query Analyzer we found that it doesnt connect, it stays idle.  ALso no users can connect to thier apps.  Finally, the Entreprose Manager didnt also respond.

We have SQL 2000 server with the latest service pack 4 running under Windows Server 2003.

What can be causing this?
0
Comment
Question by:rayluvs
[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
  • 5
  • 3
8 Comments
 

Author Comment

by:rayluvs
ID: 36568796
Here are the error messages that was the result of our problems:

After a while trying to start Query Analyzer:

        [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
        or access denied

At the Event Viewer:

        Level:            Información
        Source:         MSSQLSERVER
        Event ID:       17052
        Description:   Error: 17883, Severity: 1, State: 0
        Process 10:0 (770) UMS Context 0x002FA090 appears to be non-yielding on Scheduler 1

0
 
LVL 5

Assisted Solution

by:Eduardo Goicovich
Eduardo Goicovich earned 2000 total points
ID: 36568814
be sure that tcp/ip protocol is enabled and the server not to be in single user (emergency) mode
0
 

Author Comment

by:rayluvs
ID: 36568931
All is working now and we think we know what possibilly fixed the problem.  We would like to know EE expierenxe advise on what happened.  Here is the info:

- Prior the problem the user was trying to restart the server
   and at the first try, it said it had an update to install
-  User kept trying restart but couldn't so he press the on/off
    server button until it turned off
-  Also prior shutting down, the server had 1 gb disk space
    and was optiniE to 3 gb available (server is 2gb ram)
-  Finally, the server paging settings was modified to
    Custom size of initial 3072 and max 3072 and also
     Adjusted for best performance, "background services"
     selected

We think it was the last restart that permited to dix the problem.

Please, your opinions.
0
Technology Partners: 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!

 
LVL 5

Accepted Solution

by:
Eduardo Goicovich earned 2000 total points
ID: 36569129
some security updates (OS or database engine) need a server restart to working properly, because shared libraries need to be free from memory to load the new ones (after reboot). In some cases, a database security update needs to change server access to make wide changes and drop any existing client connection. If for any case, after updates get applied, database server doesn't get online again, force a reboot can be the cure. But, any update procedure on producction server must carry out a previous system and user database backup
0
 

Author Comment

by:rayluvs
ID: 36569637
So you think that it may have  been update that it has to have a reboot done?
0
 
LVL 5

Assisted Solution

by:Eduardo Goicovich
Eduardo Goicovich earned 2000 total points
ID: 36569692
the windows update log register all activities performed (default dir %windir%\Windowsupdate.log)
to see the description of this, you can review to the next link
http://support.microsoft.com/kb/902093/en-us

you can check if reboot needed by the update (example line)

2005-06-02      12:11:01      3348      70c      Handler        : Command line install completed. Return code = 0x00000000, Result = Succeeded, Reboot required = true


for hotfixes is %windir%

http://uekb.shavlik.com/updateexpert/troubleshooting/Tasks/UE0212.htm

other logs

http://www.hsc.fr/ressources/articles/win_log_files/index.html.en


0
 

Author Comment

by:rayluvs
ID: 36578463
Thank you very much.  This last post helped a lot!
0
 

Author Closing Comment

by:rayluvs
ID: 36583006
Thanx
0

Featured Post

Technology Partners: 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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

762 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