DOCUMENT:Q151757  14-FEB-2002  [sms]
TITLE   :Causes of Error Message "Couldn't Retrieve All Machines..."
PRODUCT :Microsoft Systems Management Server
PROD/VER::1.0,1.1,1.2
OPER/SYS:
KEYWORDS:kbsmsAdmin smsadmin

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Systems Management Server versions 1.0, 1.1, 1.2 
-------------------------------------------------------------------------------

IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, make sure you understand how to restore it if
a problem occurs. For information about how to do this, view the "Restoring
the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key"
Help topic in Regedt32.exe.

SYMPTOMS
========

When you start the Systems Management Server Administrator program, you may
receive the following error message:

   Couldn't retrieve all machines. SMS administrator has encountered a problem
   attempting to load machines from the database.

After you click OK, most or all workstations show up in the Sites window. You
receive the following error message when you execute a query:

   Couldn't execute the specified query.

CAUSE
=====

These errors are general and can occur in any of the following situations:

 - The SMS Security rights for the database user, stored in
   SMS.SecurityObjAccessList are corrupted. To correct this, set the rights for
   this database user to No Access, then reset them to the desired privilege.

   -or-

 - TEMPDB is in single user mode.

   -or-

 - TEMPDB is full.


   -or-

 - The Transaction log is full. For more information, please see the following
   article in the Microsoft Knowledge Base:

   Q125487 SMS Administrator Unable to Retrieve Machine List

   -or-

 - The stored procedure sp_GetSubSite, created by the Systems Management Server
   setup program, may be missing or corrupted. To reload the Systems Management
   Server stored procedures, sp_site.sql can be rerun in the Query Window.

   -or-


 - One or more tables in the SMS database has been dropped.

   This also can occur if DBCLEAN is run to delete an architecture.

MORE INFORMATION
================

Enabling SQL Tracing may help narrow down the problem, and will log errors to
the SMS\LOGS\UI.LOG on the site server when the SMS Administrator is run at the
site server.

WARNING: Using Registry Editor incorrectly can cause serious, system-wide
problems that may require you to reinstall Windows NT to correct them. Microsoft
cannot guarantee that any problems resulting from the use of Registry Editor can
be solved. Use this tool at your own risk.

To enable SQL Tracing, complete the following steps:

1. Start Registry Editor (Rededt32.exe).

2. Locate the following registry key:

   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\

3. Set the parameter SQLEnabled to 1.

4. Restart the Systems Management Server Administrator program and re-create the
   error.

5. Check the Sms\Logs\Ui.log using SMSTrace or Notepad.

Additional query words: prodsms

======================================================================
Keywords          : kbsmsAdmin smsadmin 
Technology        : kbSMSSearch kbSMS100 kbSMS110 kbSMS120
Version           : :1.0,1.1,1.2
Issue type        : kbprb

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2002.