Migrating an install from server to server. First time I have heard of this application.

It appears that login accounts are SQL server login accounts. I have migrated the accounts to the new SQL server. Reset a users password to try logging into the application with their account to test but it fails to login.

The SQL SA account is able to login without issues. What security rights are correct or what allows a user to log into GP?

  • How did you migrate the SQL logins to the new server? – joeqwerty May 7 '15 at 15:43
  • sp_help_revlogin – Tsukasa May 7 '15 at 15:46

Ok so I don't know the exact issue but here is my work around.

Reset the System Password

UPDATE DYNAMICS..SY02400 SET PASSWORD = 0x00202020202020202020202020202020

Access the users

Create a dummy user and copy the access from the target user

delete and recreate the target user and copy access from the dummy user

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.