SMS_SiteSystemToSQLConnection failing to access database on primary site
SMS_SiteSystemToSQLConnection_P04 The group contains over 270 hosts Management Points started failing at Secondary Sites Please see logs below. Not all sites are failing and configuration is identical for all sites. We are in the process of upgrading from SMS 2003 SP2 to SCCM. Mpcontrol.log STATMSG: ID=5436 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_MP_CONTROL_MANAGER" SYS=HOSTMANESECSITE SITE=987 PID=804 TID=848 GMTDATE=Wed Jan 28 19:53:39.800 2009 ISTR0="Internal Server Error" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_MP_CONTROL_MANAGER 1/28/2009 1:53:39 PM 848 (0x0350) Http verification .sms_aut (port 80) failed with status code 500, Internal Server Error SMS_MP_CONTROL_MANAGER 1/28/2009 2:02:35 PM 848 (0x0350) MP_GetAuth.log MP IP Number of MPs in the Site "P04" = 274 MP_GetAuth_ISAPI 1/26/2009 1:03:13 PM 2848 (0x0B20) MP GA Number of MPs in the Site = 274 MP_GetAuth_ISAPI 1/26/2009 1:03:13 PM 3152 (0x0C50) MP IP Number of MPs in the Site "P04" = 274 MP_GetAuth_ISAPI 1/26/2009 1:13:13 PM 2848 (0x0B20) MP GA Number of MPs in the Site = 274 MP_GetAuth_ISAPI 1/26/2009 1:13:13 PM 3152 (0x0C50) CMPDBConnection::Init(): IDBInitialize::Initialize() failed with 0x80004005 MP_GetAuth_ISAPI 1/26/2009 1:24:16 PM 3304 (0x0CE8) MPDB ERROR - CONNECTION PARAMETERS SQL Server Name : HOSTNAME SQL Database Name : SMS_P04 Integrated Auth : True MPDB ERROR - EXTENDED INFORMATION MPDB Method : Init() MPDB Method HRESULT : 0x80004005 Error Description : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. OLEDB IID : {0C733A8B-2A1C-11CE-ADE5-00AA0044773D} ProgID : Microsoft OLE DB Provider for SQL Server MPDB ERROR - INFORMATION FROM DRIVER Native Error no. : 17 Error State : 1 Class (Severity) : 16 MP_GetAuth_ISAPI 1/26/2009 1:24:16 PM 3304 (0x0CE8)
January 28th, 2009 11:53pm

This must still be SMS 2003, as Configuration Manager no longer creates or uses that group. It now relies on SQL roles to provide database access. For SMS 2003, you'd have to post the question in the public newsgroups or contact CSS. The forums are for Configuration Manager.Wally Mead
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2009 1:21am

Please post here http://social.technet.microsoft.com/Forums/en-US/sms/threads
January 24th, 2012 5:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics