Microsoft KB Archive/256950

= SMS: Cannot Schedule Crystal Report on Windows 2000 Server =

Article ID: 256950

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition
 * Microsoft Systems Management Server 2.0 Service Pack 1

-



This article was previously published under Q256950



SYMPTOMS
When you are scheduling Crystal Reports on a Microsoft Windows 2000-based Systems Management Server (SMS) 2.0 site server, the following error message may be displayed:

Can't open SQL server



CAUSE
The WMI ODBC driver does not connect to WMI because Crystal Reports always passes credentials, even if it is running locally. It incorrectly passes explicit credentials to Windows 2000, which rejects the request because explicit credentials are being supplied on the local computer.



RESOLUTION
To resolve this problem, obtain the latest service pack for Systems Management Server version 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

236325 How to Obtain the Latest Systems Management Server 2.0 Service Pack



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0. This problem was first corrected in Systems Management Server version 2.0 Service Pack 2. This problem was first corrected in Systems Management Server version 2.0 Service Pack 2.

Additional query words: prodsms

Keywords: kbbug kbfix kbsms200sp2fix KB256950

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.