The first thing was Reporting not working - only SCCMReports user has wrong PWD - I deleted and recreated user and everything was fine.
But after restart we are unable to connect to Site server with Console:
I have this from Event viewer:
Transport error; failed to connect, message: 'The SMS Provider reported an error.'\r\nMicrosoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nThe SMS Provider reported an error.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.Connect(String configMgrServerPath)
at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String connectionManagerInstance)\r\nConfigMgr Error Object:
instance of __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'SK1'";
ProviderName = "WinMgmt";
};
Error Code:
ProviderLoadFailure
\r\nSystem.Management.ManagementException\r\nProvider load failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()\r\nManagementException details:
instance of __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'SK1'";
ProviderName = "WinMgmt";
};
\r\n
From SCCM logs:
SMSAdminUI.log and here's the info:
[12, PID:9660][08/24/2017 16:42:20] :Transport error; failed to connect, message: 'The SMS Provider reported an error.'\r\nMicrosoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nThe SMS Provider reported an error.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.Connect(String configMgrServerPath)
at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String connectionManagerInstance)\r\nConfigMgr Error Object:
instance of __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'SK1'";
ProviderName = "WinMgmt";
};
Error Code:
ProviderLoadFailure
\r\nSystem.Management.ManagementException\r\nProvider load failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()\r\nManagementException details:
instance of __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'SK1'";
ProviderName = "WinMgmt";
};
\r\n
[12, PID:9660][08/24/2017 16:42:20] :System.Management.ManagementException\r\nProvider load failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary`2 methodParameters, Boolean traceParameters)\r\nManagementException details:
also checked sitecomp.log:
** Failed to connect to the SQL Server, connection type: SMS ACCESS. $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 10:42:02.677-120><thread=5616 (0x15F0)>
Waiting for changes to the "C:\Program Files\Microsoft Configuration Manager\inboxes\sitectrl.box" or "C:\Program Files\Microsoft Configuration Manager\inboxes\sitecomp.box" directories, servers will be polled in 1 hour... $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 10:42:02.679-120><thread=5616 (0x15F0)>
SMS_SITE_COMPONENT_MANAGER service is stopping... $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.169-120><thread=11372 (0x2C6C)>
*** [IM004][0][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.190-120><thread=11372 (0x2C6C)>
*** Failed to connect to the SQL Server, connection type: SMS ACCESS. $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.192-120><thread=11372 (0x2C6C)>
*** [IM004][0][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.195-120><thread=11372 (0x2C6C)>
*** Failed to connect to the SQL Server, connection type: SMS ACCESS. $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.199-120><thread=11372 (0x2C6C)>
Info: Currently Site SK1 is initializing Site Control Data. Can't get Master SCF from database at this time. Will try later. $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.200-120><thread=11372 (0x2C6C)>
STATMSG: ID=501 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_COMPONENT_MANAGER" SYS=PSK-SCCM.psk.porsche.sk SITE=SK1 PID=5584 TID=11372 GMTDATE=Thu Aug 24 09:10:25.170 2017 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.200-120><thread=11372 (0x2C6C)>
Updating all Operations Management component registry key values.~ $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.203-120><thread=11372 (0x2C6C)>
Updating all Operations Management component registry key values.~ $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.435-120><thread=5616 (0x15F0)>
STATMSG: ID=502 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_COMPONENT_MANAGER" SYS=PSK-SCCM.psk.porsche.sk SITE=SK1 PID=5584 TID=5616 GMTDATE=Thu Aug 24 09:10:25.436 2017 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_SITE_COMPONENT_MANAGER><08-24-2017 11:10:25.436-120><thread=5616 (0x15F0)>
