I would do two things:   1) Go to %APPDATA%\SAS and rename the SAS-Folder. Then try again. 2) Go to Excel --> Options --> AddIns --> COM AddIns and delete the SAS AddIn. Then go to the Installationdirectory of your Add-In and execute the SwitcherUtility.exe to reinstall the COM-Addin. Then try again. ... View more

Alright, then @AnandVyas and @Kurt_Bremser gave you the right information! ... View more

Hi @Madhan_cog1, if a thirdparty tool is an option for you, have a look at Metacoda (https://www.metacoda.com/en/products/utility-plug-ins/). They offer several tools to observe and manage your metadata. One of it functionalities is to sync your metadata Users with the Active Directory. I am pretty sure @MichelleHomes could help you with further information or an evalution license.  We are absolutely happy with metacoda. We have about 10 SAS-Environments with up to 600 AD-Users, that are synced as often, as we want (right now, each night). Users that have left an AD-group (cause they left our company or do something else and no longer have the rights to use SAS  - since they dont have the AD-Group anymore) loose their rights automatically, but stay in the metadata - marked as "DELETED". Kind Regards Daniel ... View more

We did something similar. We create a "snapshot" each Weekend and compare it with the "snapshot" of the last week. Pretty easy via a cronjob. We use the Batch interface of the Metacoda Security Plugin. The plugin creates a report, that lists every (wished) difference. For example Objects, that got a new ACT, new Users, deleted Users, Capabilities per User that are gone or new,... Looks like this: # Test Reason 1 ACTs/ACT('Server ACT - TS Server')/PermissionPattern/Group('BI Web Services Users')/permissions Mismatched permission pattern found. Expected <"MCM unspecified"> but got <"+MCM">. 2 ACTs/ACT('Private User Folder ACT')/Objects/complete The test specifies a COMPLETE set of protected objects for the Access Control Template (ACT) 'Private User Folder ACT'. The test has failed because the ACT was actually found to be applied to an additional 3 unspecified objects. Additional test failures will occur for each unspecified object. I am pretty sure @PaulHomes or @MichelleHomes can help you. ... View more

If the newer PFS has the same Version as your SMC Installation - this could work. However i would recommend reinstalling both... ... View more