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