After restoring the sql server db and ran the upgrade, the following error occur when trying to connect to the stat windows client:
1. Run the following statements against the sql server db:
exec sp_change_users_login 'Update_One', 'STATLOGIN', 'STATLOGIN'
exec sp_change_users_login 'Update_One', 'STAT', 'STAT'
GRANT SELECT ON STAT.STAT_LOGIN TO STATLOGIN;
GRANT EXECUTE ON STAT.STAT_STORE TO STATLOGIN;
2. Take a look at the STAT_LOGIN table. Make sure the LoginID is STAT and not JcS
3. If the STAT_LOGIN got the correct LoginID and still have a problem, then run these two queries:
SELECT * FROM STAT_STORE_VW
SELECT * FROM STAT_LOGIN
Make sure to export the data into excel sheet with headers. Create an SR with support. Let Support know what the STAT password should be. Dev will need to see if the encrypted password in the STAT_LOGIN table matches what you are telling us.