DOCUMENT:Q231266  07-MAY-2000  [sms]
TITLE   :"Cannot Open SQL Server" Error Message and Report Does Not Run
PRODUCT :Microsoft Systems Management Server
PROD/VER:winnt:2.0,2.0 SP1
OPER/SYS:
KEYWORDS:kberrmsg kbtool kbsms200 kbsms200bug

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

 - Microsoft Systems Management Server versions 2.0, 2.0 SP1 
-------------------------------------------------------------------------------

SYMPTOMS
========

Systems Management Server (SMS) 2.0 includes a version of Crystal Reports. You
can use this tool to collate information about how SMS is operating in your
organization and to prepare administrative information in an easy-to-read report
format.

When you try to schedule a report to run on an SMS 2.0 site server that is
running on a Microsoft Windows NT Member server, the report may not run, and you
may receive the following error message in the report properties:

   Cannot open SQL server

CAUSE
=====

This issue can occur if the SMS Service account does not have the "Act as a part
of the Operating System" advanced user right on the SMS site server. Note that
this may occur even if the SMS Service account is not being used to run the
report.

RESOLUTION
==========

To resolve this issue:

1. Start User Manager for domains, click User, click Select Domain, and then
   enter the local computer name.

2. Click Policies, and then click User rights.

3. In the User Rights Policy dialog box, click to select the "Show Advanced User
   Rights" check box.

4. On the right-sice drop down list box, click "Act as part of the operating
   system".

5. Click Add, enter the siteserverdomain\smsserviceaccount in the Add Names box,
   and then click OK.

6. Click OK on User Rights Policy dialog box.

7. Stop and then restart all of the following Crystal services:

 - Info Agent
 - Info APS
 - Info Sentinel

Additional query words: prodsms 2.00

======================================================================
Keywords          : kberrmsg kbtool kbsms200 kbsms200bug 
Technology        : kbSMSSearch kbSMS200 kbSMS200SP1
Version           : winnt:2.0,2.0 SP1
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 2000.