Microsoft KB Archive/886142

= The site server's computer account is not added to the SMS_SiteSystemToSQLConnection_ group after you configure a Server Locator Point in Systems Management Server 2003 =

Article ID: 886142

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-





SYMPTOMS
After you add the Server Locator Point system role to a Microsoft Systems Management Server (SMS) 2003 site, the site server's computer account may not be added to the SMS_SiteSystemToSQLConnection_ group. The following entries appear in the SMS\Logs\Sitecomp.log file:

Machine account  could not be added to the SQL Access Group  \SMS_SiteSystemToSQLConnection_  on Machine.

STATMSG: ID=4908 SEV=E LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_COMPONENT_MANAGER&quot; SYS= SITE=  PID=1116 TID=804 GMTDATE=Mon May 17 16:37:48.611 2004 ISTR0=&quot; &quot; ISTR1=&quot;computer name\SMS_SiteSystemToSQLConnection_ &quot; ISTR2=&quot; &quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0

Note In this log entry,  is the name of the site server, and   is the site code.



CAUSE
This problem may occur if all the following conditions are true:
 * The site server is a primary child site.
 * You configure the Server Locator Point system role properties to use the database on a different primary site. For example, you configure the properties to use the database of the parent site.

The SMS Site Component Manager process tries to add the Server Locator Point computer account to the SMS_SiteSystemToSQLConnection_ group on the database server. However, the component uses the local site code instead of the database server site code.

For example, if your Server Locator Point site code is XXX, and your database server site code is YYY, the SMS Site Component Manager component tries to add the computer account to the SMS_SiteSystemToSQLConnection_XXX group on the YYY database server. The group on the YYY database server is SMS_SiteSystemToSQLConnection_YYY. This problem occurs because the SMS_SiteSystemToSQLConnection_XXX group does not exist on the YYY database server.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



WORKAROUND
To work around this problem, you must manually add the child site's computer account to the SMS_SiteSystemToSQLConnection_ group. To do this, follow these steps:
 * 1) Click Start, point to Administrative Tools, and then click Computer Management.
 * 2) Expand Local Users and Groups, and then click Groups.
 * 3) Double-click SMS_SiteSystemToSQLConnection_ . (  is the SMS site code that is used by the database server.)
 * 4) Click Add, click Object Types, make sure that the Computers check box is selected, and then click OK.
 * 5) Type  \ for the Server Locator Point computer, and then click OK two times.

Additional query words: SLP

Keywords: kbsms2003bug kbtshoot kbdatabase kberrmsg kbsecurity KB886142

-

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

© Microsoft Corporation. All rights reserved.