DOCUMENT:Q247852 13-MAY-2000 [sms] TITLE :SMS: SQL Monitor Service Does Not Create Notification Files PRODUCT :Microsoft Systems Management Server PROD/VER:winnt:2.0 OPER/SYS: KEYWORDS:kbsms200 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Systems Management Server version 2.0 ------------------------------------------------------------------------------- SYMPTOMS ======== Certain configuration changes that you specify in the Systems Management Server (SMS) Administrator console may take longer to become effective than you expect. For example, when you create a new collection, the collection members may not show up immediately as you expect. When this behavior occurs, the Smsdbmon.log file records the following information and stops logging: CTriggerManager::RouteFiles - waiting on named pipe... $$ CAUSE ===== This behavior can occur if the SMS extended stored procedure on the SQL server does not connect to the SQL Monitor service. WORKAROUND ========== Make sure that the SMS_SQL_MONITOR service is running and that the MSSQLServer service runs under the system account or with an account that has administrative rights on the SQL server. MORE INFORMATION ================ The Trigger Manager thread of the SMS SQL Monitor service component is responsible for notifying other SMS components of database changes. This service allows for an almost instantaneous response to create, update, or delete requests, or to any of a number of other SMS processes such as collection updates. To inform Trigger Manager of specific database events, the xp_SMS_NOTIFICATION SMS extended stored procedure is run by SQL triggers installed by SMS. This extended stored procedure connects to the named pipe that Trigger Manager created. If it cannot connect to the named pipe, SQL Monitor is not informed of database changes and does not create notification files for the various SMS threads. The SMS extended stored procedure runs in the context of the MSSQLServer service. If the service does not have administrative rights on the SQL server, xp_SMS_NOTIFICATION does not connect to the named pipe. Additional query words: prodsms smsxp.dll smsxp70.dll ====================================================================== Keywords : kbsms200 Technology : kbSMSSearch kbSMS200 Version : winnt:2.0 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.