Microsoft KB Archive/295157

= SMS: The Preinst.exe and Delgrp.exe Utilities May Return Errors When They Are Run on SQL Server 2000 =

Article ID: 295157

Article Last Modified on 10/27/2006

-

APPLIES TO


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

-



This article was previously published under Q295157



SYMPTOMS
The Microsoft BackOffice Server 4.5 Resource Kit utilities, Preinst.exe and Delgrp.exe, may return errors when they are run on Systems Management Server (SMS) running Microsoft SQL Server 2000.

When you attempt to run the Delgrp.exe utility with a SQL Server 2000 database, you may receive the following error message:

Cannot get SQL connection.

When you attempt to run the Preinst.exe utility (which is included with SMS 2.0 Support Tools), you may receive the following error message:

Cannot connect to the SQL server.

If you have enabled the Failure Auditing feature for SQL Server 2000, you may receive the following SQL event in the Application event log:

18452 : Login failed for user '(null)'. Reason: Not associated with a trusted SQL server connection.



CAUSE
This problem can occur because the default client network protocol has been changed from &quot;Named Pipes&quot; in Microsoft SQL Server 7.0 (and earlier) to &quot;TCP/IP&quot; in SQL Server 2000.



WORKAROUND
To work around this problem, change the default SQL network library to &quot;Named Pipes.&quot; For example, start the SQL Server Client Network Utility (from SQL Server 2000) on the site server from which you are attempting to run either the Preinst.exe or Delgrp.exe utility.

On the General tab, ensure that &quot;Named Pipes&quot; is listed in the &quot;Enabled protocols by order&quot; list. Use the arrows that are displayed to move &quot;Named Pipes&quot; so that it is first in the list.

If you cannot set &quot;Named Pipes&quot; as the primary protocol, make the following configurations to the SQL Server 2000 and SMS security settings:
 * 1) Configure SMS so that it does not use integrated security.
 * 2) Configure SQL Server 2000 to use &quot;SQL Server and Windows&quot; security.



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0.

Additional query words: prodsms

Keywords: kbbug kbconfig kbinterop kbnofix kbserver kbsmsutil KB295157

-

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

© Microsoft Corporation. All rights reserved.