locked
Critical SMS_Executive SQL Login failed for user 'NT AUTHORITY\SYSTEM'. RRS feed

  • Question

  • I am getting sql login errors on my sms executive log that i believe is stopping me from pxe booting. I have tried finding where to enter the credentials but i cannot find it.

    ******************************************************************************** SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Starting SMS_EXECUTIVE... SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Microsoft System Center 2012 Configuration Manager v5.00 (Build 7958) SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Copyright (C) 2011 Microsoft Corp. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Running as a Win32 service. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Process ID: 2368 SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Worker thread ID: 2412 SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Certificate (0x610450) is Exportable SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Initialize COM Security. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    InitializeCOMSecurity: RegOpenKeyEx for appid key Succeeded. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    InitializeCOMSecurity: RegQueryInfoKey for appid key Succeeded. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    InitializeCOMSecurity: RegQueryValueEx for AccessPermission Succeeded. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    InitializeCOMSecurity: IsValidSecurityDescriptor() Succeeded. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    InitializeCOMSecurity: MakeAbsoluteSD() Succeeded. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    InitializeCOMSecurity: CoInitializeEx() Succeeded. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    InitializeCOMSecurity() Succeeded. SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Installation directory: E:\Program Files\Microsoft Configuration Manager SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    This server: E076SCCM SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Site server: sccmserver.org SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Site code: 076 SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Site type: 1 SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    CSMSExecService::RegisterDBConnection: Register a DB connection... SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
    Initializing the status message reporting system... SMS_EXECUTIVE 4/10/2014 3:13:12 PM 2412 (0x096C)
        The path to the "Status Manager" inbox is "E:\Program Files\Microsoft Configuration Manager\inboxes\statmgr.box\statmsgs". SMS_EXECUTIVE 4/10/2014 3:13:13 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:14 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:14 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:14 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:14 PM 2412 (0x096C)
    *** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS_EXECUTIVE 4/10/2014 3:13:14 PM 2412 (0x096C)
    CSiteControlEx::GetCurrentSiteInfo: Failed to get SQL connection SMS_EXECUTIVE 4/10/2014 3:13:14 PM 2412 (0x096C)
    CSiteControlEx::GetMasterSCF:Failed to read site information from database, retry in 5 seconds ... SMS_EXECUTIVE 4/10/2014 3:13:14 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:19 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:19 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:19 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:19 PM 2412 (0x096C)
    *** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS_EXECUTIVE 4/10/2014 3:13:19 PM 2412 (0x096C)
    CSiteControlEx::GetCurrentSiteInfo: Failed to get SQL connection SMS_EXECUTIVE 4/10/2014 3:13:19 PM 2412 (0x096C)
    CSiteControlEx::GetMasterSCF:Failed to read site information from database, retry in 5 seconds ... SMS_EXECUTIVE 4/10/2014 3:13:19 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:24 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:24 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:24 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:24 PM 2412 (0x096C)
    *** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS_EXECUTIVE 4/10/2014 3:13:24 PM 2412 (0x096C)
    CSiteControlEx::GetCurrentSiteInfo: Failed to get SQL connection SMS_EXECUTIVE 4/10/2014 3:13:24 PM 2412 (0x096C)
    CSiteControlEx::GetMasterSCF:Failed to read site information from database, retry in 5 seconds ... SMS_EXECUTIVE 4/10/2014 3:13:24 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:31 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:31 PM 2412 (0x096C)
    *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. SMS_EXECUTIVE 4/10/2014 3:13:31 PM 2412 (0x096C)
    *** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_076" requested by the login. The login failed. SMS_EXECUTIVE 4/10/2014 3:13:31 PM 2412 (0x096C)
    *** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS_EXECUTIVE 4/10/2014 3:13:31 PM 2412 (0x096C)
    CSiteControlEx::GetCurrentSiteInfo: Failed to get SQL connection SMS_EXECUTIVE 4/10/2014 3:13:31 PM 2412 (0x096C)
    CSiteControlEx::GetMasterSCF:Failed to read site information from database, retry in 5 seconds ... SMS_EXECUTIVE 4/10/2014 3:13:31 PM 2412 (0x096C)
        SMS_STATUS_MANAGER is not running as part of this process, the SMS_EXECUTIVE to SMS_STATUS_MANAGER in-memory status message queue will not be used. SMS_EXECUTIVE 4/10/2014 3:13:47 PM 2412 (0x096C)
    Registered this process as a source of "SMS Server" events. SMS_EXECUTIVE 4/10/2014 3:13:47 PM 2412 (0x096C)
    Registered this process as a source of "SMS Client" events. SMS_EXECUTIVE 4/10/2014 3:13:47 PM 2412 (0x096C)
    Registered this process as a source of "SMS Provider" events. SMS_EXECUTIVE 4/10/2014 3:13:47 PM 2412 (0x096C)
    Status message reporting system initialized successfully. SMS_EXECUTIVE 4/10/2014 3:13:47 PM 2412 (0x096C)
    STATMSG: ID=500 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_EXECUTIVE" SYS=sccmserver.org SITE=076 PID=2368 TID=2412 GMTDATE=Thu Apr 10 19:13:47.950 2014 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_EXECUTIVE 4/10/2014 3:13:47 PM 2412 (0x096C)
    Certificate maintenance interval is every 1800 seconds SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_AD_FOREST_DISCOVERY_MANAGER initialized, DLL = "\bin\x64\ADForestDisc.dll", startup type = "Scheduled", current state = "Stopped", requested operation = "None", next start time = "Sun Apr 13 00:00:00 2014 Eastern Daylight Time". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    STATMSG: ID=1105 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_AD_FOREST_DISCOVERY_MANAGER" SYS=sccmserver.org SITE=076 PID=2368 TID=2412 GMTDATE=Thu Apr 10 19:13:48.119 2014 ISTR0="2014 04 0 13 04 00 00 000" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT initialized, DLL = "\bin\x64\adsgdis.dll", startup type = "Scheduled", current state = "Stopped", requested operation = "None", next start time = "Thu Apr 10 15:15:00 2014 Eastern Daylight Time". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    STATMSG: ID=1105 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT" SYS=sccmserver.org SITE=076 PID=2368 TID=2412 GMTDATE=Thu Apr 10 19:13:48.120 2014 ISTR0="2014 04 4 10 19 15 00 000" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_AD_SYSTEM_DISCOVERY_AGENT initialized, DLL = "\bin\x64\adsysdis.dll", startup type = "Scheduled", current state = "Stopped", requested operation = "None", next start time = "Thu Apr 10 15:15:00 2014 Eastern Daylight Time". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    STATMSG: ID=1105 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_AD_SYSTEM_DISCOVERY_AGENT" SYS=sccmserver.org SITE=076 PID=2368 TID=2412 GMTDATE=Thu Apr 10 19:13:48.157 2014 ISTR0="2014 04 4 10 19 15 00 000" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_AD_USER_DISCOVERY_AGENT initialized, DLL = "\bin\x64\adusrdis.dll", startup type = "Scheduled", current state = "Stopped", requested operation = "None", next start time = "Thu Apr 10 15:15:00 2014 Eastern Daylight Time". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    STATMSG: ID=1105 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_AD_USER_DISCOVERY_AGENT" SYS=sccmserver.org SITE=076 PID=2368 TID=2412 GMTDATE=Thu Apr 10 19:13:48.158 2014 ISTR0="2014 04 4 10 19 15 00 000" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_AI_KB_MANAGER initialized, DLL = "\bin\x64\aikbmgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_ALERT_NOTIFICATION initialized, DLL = "\bin\x64\NotiCtrl.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_AMT_PROXY_COMPONENT initialized, DLL = "\bin\x64\amtproxymgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_CERTIFICATE_MANAGER initialized, DLL = "\bin\x64\CertMgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_CLIENT_CONFIG_MANAGER initialized, DLL = "\bin\x64\ccm.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_CLIENT_HEALTH initialized, DLL = "\bin\x64\chmgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_CLOUD_SERVICES_MANAGER initialized, DLL = "\bin\x64\CloudMgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_COLLECTION_EVALUATOR initialized, DLL = "\bin\x64\colleval.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_COMPONENT_MONITOR initialized, DLL = "\bin\x64\compmon.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_COMPONENT_STATUS_SUMMARIZER initialized, DLL = "\bin\x64\compsumm.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_DATABASE_NOTIFICATION_MONITOR initialized, DLL = "\bin\x64\smsdbmon.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_DESPOOLER initialized, DLL = "\bin\x64\despool.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_DISCOVERY_DATA_MANAGER initialized, DLL = "\bin\x64\ddm.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_DISTRIBUTION_MANAGER initialized, DLL = "\bin\x64\distmgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_ENDPOINT_PROTECTION_CONTROL_MANAGER initialized, DLL = "\bin\x64\EPCtrlMgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_ENDPOINT_PROTECTION_MANAGER initialized, DLL = "\bin\x64\EPMgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_EN_ADSERVICE_MONITOR initialized, DLL = "\bin\x64\adctrl.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_FALLBACK_STATUS_POINT initialized, DLL = "\bin\x64\fspmgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_HIERARCHY_MANAGER initialized, DLL = "\bin\x64\hman.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_INBOX_MANAGER initialized, DLL = "\bin\x64\inboxmgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_INBOX_MONITOR initialized, DLL = "\bin\x64\inboxmon.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_INVENTORY_DATA_LOADER initialized, DLL = "\bin\x64\dataldr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_INVENTORY_PROCESSOR initialized, DLL = "\bin\x64\invproc.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_LAN_SENDER initialized, DLL = "\bin\x64\sender.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_LICENSE_MANAGER initialized, DLL = "\bin\x64\licensemgr.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_MIGRATION_MANAGER initialized, DLL = "\bin\x64\migmctrl.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_MP_CONTROL_MANAGER initialized, DLL = "\bin\x64\mpcontrol.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_MP_FILE_DISPATCH_MANAGER initialized, DLL = "\bin\x64\mpfdm.dll", startup type = "Automatic", current state = "Starting", requested operation = "Start". SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    SMS_NETWORK_DISCOVERY initialized, DLL = "\bin\x64\netdisc.dll", startup type = "Scheduled", current state = "Stopped", requested operation = "None", not scheduled to start again. SMS_EXECUTIVE 4/10/2014 3:13:48 PM 2412 (0x096C)
    STATMSG: ID=1106 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_NETWORK_DISCOVERY" SYS=sccmserver.org SITE=076 P

    Thursday, April 10, 2014 7:45 PM

All replies

  • First, if your site server is having problems logging into the DB, which it clearly is, you've got bigger issues than just PXE.

    Have you verified the permissions in your SQL Server instance for the local System account (I'm assuming at this point that it is local to the site server)?


    Jason | http://blog.configmgrftw.com

    Thursday, April 10, 2014 11:34 PM
  • My NT Authority\System is part of the SYSadmin server role. Its also listed as a login under my SCCM database with the db_owner, smsdbrole_MP, smsdbrole_siteprovider, smsdbrole_siteserver, and smsdbrole_SUP role memberships.
    Friday, April 11, 2014 2:52 PM
  • So, do these errors persist in the logs?

    Is your MP on the site server or is it remote?


    Jason | http://blog.configmgrftw.com

    Friday, April 11, 2014 9:25 PM
  • Yes the error continue and the MP is on the site server
    Monday, April 14, 2014 12:22 PM