Microsoft KB Archive/298033

= SMS: Remote Control May Not Work with Unsupported Database Collation =

Article ID: 298033

Article Last Modified on 2/25/2007

-

APPLIES TO


 * Microsoft Systems Management Server 2003
 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q298033



SYMPTOMS
When you have appropriate Microsoft Systems Management Server (SMS) security rights and try to remotely control an SMS client, you may be unable to do so. The following error message may be generated:

Remote Tools

Security rights to run remote tools on this client have been denied.

Note that this issue may also occur when you run the Remote.exe command from a command prompt.



CAUSE
This issue can occur if the SMS database is located on a Microsoft SQL Server 2000 computer on which the database is configured to use SQL_SwedishStd_Pref_CP1_CI_AS collation. Unless this configuration is specified manually, either on database or server level, this issue occurs when you upgrade the database server from SQL Server 7.0 configured with ISO character set (ID=1) and Swedish/Finnish (Std) dict order, case insensitive, uppercase pref sort order (ID=185). To determine whether this is the configured database collation, right-click the SMS database in SQL Server Enterprise Manager, and then click Properties. You can view the configured collation under Collation Name.



MORE INFORMATION
Microsoft does not recommend or support the use of this collation in conjunction with SMS. If you are already running this database configuration, you may want to contact Microsoft Product Support Services (PSS) for assistance transferring the data in the SMS database to a server that is running a different collation. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, view the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Additional query words: prodsms SQL Error: Cannot resolve collation conflict for equal to operation.

Keywords: kbconfig kbdatabase kbhelpdesk kbinterop kbprb kbremoteprog kbserver KB298033

-

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

© Microsoft Corporation. All rights reserved.