Problem
- When you try to get SharePoint sites, anyway which account is used, you get access denied
- In logs :
SPWindowsTokenCacheServiceApplication.CacheHandle() call to OpenProcess() failed for '0#.w|mydomainmylogin': PID=2956, ErrorCode=5, Exception=System.ComponentModel.Win32Exception: Access is denied
The Secure Store Service application Secure Store Service is not accessible. The full exception text is: Cannot open database "Secure_Store_Service_DB_guid" requested by the login. The login failed. Login failed for user 'mydomainmyaccount'
Solution
Security Token Service Application must run with the farm admin account