Hello,

I upgraded my environnment from SCCM 2012 R2 to SCCM 2012 R2 SP1.
I didn't notice any issues during the deployment but when I checked the logs I noticed those error messages in the ConfigMgrSetup.log.

Info: Try Load resource from C:\Program Files\Microsoft Configuration Manager\bin\x64\00000409\AppRestrictionSettings.en.resx.
WARNING: Failed to find default package file C:\Program Files\Microsoft Configuration Manager\bin\x64\00000409\AppRestrictionSettings.en.resx. LastError=2
ERROR: Failed to convert LCID to name. Error 0x000003e5.
...

I checked and the file AppRestrictionSettings.en.resx doesn't exist.

I also have a management point/sup in DMZ and I noticed those error messages in the ConfigMgrSetup.log:

Adding  DOMAIN\DMZSCCM$ to smsdbrole_MP
INFO: Assigning server DMZSCCM.DOMAIN.COM to role SMS Management Point 
***  IF NOT EXISTS(SELECT * FROM sys.database_principals dp   JOIN sys.server_principals sp ON dp.sid=sp.sid AND dp.name=N'dbo' AND sp.name=N' DOMAIN\DMZSCCM$')  BEGIN IF NOT EXISTS(SELECT * FROM master.sys.server_principals where name=N' DOMAIN\DMZSCCM$') CREATE LOGIN [ DOMAIN\DMZSCCM$] FROM WINDOWS IF NOT EXISTS(SELECT * FROM sys.database_principals where name=N' DOMAIN\DMZSCCM$') CREATE USER [ DOMAIN\DMZSCCM$] EXEC sp_addrolemember N'smsdbrole_MP', N' DOMAIN\DMZSCCM$' END
*** [42000][15401][Microsoft][SQL Server Native Client 11.0][SQL Server]Windows NT user or group ' DOMAIN\DMZSCCM$' not found. Check the name again.
ERROR: SQL Server error: [42000][15401][Microsoft][SQL Server Native Client 11.0][SQL Server]Windows NT user or group ' DOMAIN\DMZSCCM$' not found. Check the name again.
INFO: Executing SQL Server command: < IF NOT EXISTS(SELECT * FROM sys.database_principals dp   JOIN sys.server_principals sp ON dp.sid=sp.sid AND dp.name=N'dbo' AND sp.name=N' DOMAIN\DMZSCCM$')  BEGIN IF NOT EXISTS(SELECT * FROM master.sys.server_principals where name=N' DOMAIN\DMZSCCM$') CREATE LOGIN [ DOMAIN\DMZSCCM$] FROM WINDOWS IF NOT EXISTS(SELECT * FROM sys.database_principals where name=N' DOMAIN\DMZSCCM$') CREATE USER [ DOMAIN\DMZSCCM$] EXEC sp_addrolemember N'smsdbrole_MP', N' DOMAIN\DMZSCCM$' END > 
WARNING: Cannot add server DMZSCCM.DOMAIN.COM to role SMS Management Point
INFO: NetWkstaGetInfo server:<DMZSCCM.DOMAIN.COM>, NetBios:<DMZSCCM>, Domain:<DOMAIN>
Adding  DOMAIN\DMZSCCM$ to smsdbrole_SUP
INFO: Assigning server DMZSCCM.DOMAIN.COM to role SMS Software Update Point
***  IF NOT EXISTS(SELECT * FROM sys.database_principals dp   JOIN sys.server_principals sp ON dp.sid=sp.sid AND dp.name=N'dbo' AND sp.name=N' DOMAIN\DMZSCCM$')  BEGIN IF NOT EXISTS(SELECT * FROM master.sys.server_principals where name=N' DOMAIN\DMZSCCM$') CREATE LOGIN [ DOMAIN\DMZSCCM$] FROM WINDOWS IF NOT EXISTS(SELECT * FROM sys.database_principals where name=N' DOMAIN\DMZSCCM$') CREATE USER [ DOMAIN\DMZSCCM$] EXEC sp_addrolemember N'smsdbrole_SUP', N' DOMAIN\DMZSCCM$' END 
*** [24000][0][Microsoft][SQL Server Native Client 11.0]Invalid cursor state
ERROR: SQL Server error: [24000][0][Microsoft][SQL Server Native Client 11.0]Invalid cursor state
INFO: Executing SQL Server command: < IF NOT EXISTS(SELECT * FROM sys.database_principals dp   JOIN sys.server_principals sp ON dp.sid=sp.sid AND dp.name=N'dbo' AND sp.name=N' DOMAIN\DMZSCCM$')  BEGIN IF NOT EXISTS(SELECT * FROM master.sys.server_principals where name=N' DOMAIN\DMZSCCM$') CREATE LOGIN [ DOMAIN\DMZSCCM$] FROM WINDOWS IF NOT EXISTS(SELECT * FROM sys.database_principals where name=N' DOMAIN\DMZSCCM$') CREATE USER [ DOMAIN\DMZSCCM$] EXEC sp_addrolemember N'smsdbrole_SUP', N' DOMAIN\DMZSCCM$' END > 
WARNING: Cannot add server DMZSCCM.DOMAIN.COM to role SMS Software Update Point 
INFO: Updating SMSData Table

However, when I check the component status, everything is green and according to the messages, the components were succesfully reinstalled. Is it because there is only a one-way communication between my primary site and this site in DMZ ?

How can I make sure that everything is ok ?
Should I rollback ?

Thanks,

That's hard to tell without sitting in front of the system, but just knowing some lines from a log that are taken out of context. The first one can most likely being ignored. 

Thanks.

Is there any way to run a check to make sure the entire environment is healthy and up to date or should I see something "red" in monitoring if something was broken ?

Also, is there any simple way to rollback ?

Thanks,

• Edited by LiveBTW83 14 hours 20 minutes ago add another question

Thanks.

Is there any way to run a check to make sure the entire environment is healthy and up to date or should I see something "red" in monitoring if something was broken ?

Also, is there any simple way to rollback ?

Thanks,

• Edited by LiveBTW83 Thursday, August 27, 2015 5:29 PM add another question

Hi,

If something was broken, you should see something "red" in the Monitoring workspace.