Hello:
Back when I was a consultant, I moved GP data to new SQL servers many times. I'm familiar with the steps involved.
Also, I know that when you move data to a new server, you have to change the password of every GP user.
The policy at my company is to "Enforce Password Policy", including the use of complex SQL passwords for GP and to have users change their passwords at their initial login session.
We are testing the move of data. Although the installation of GP 2013 R2 (12.00.1920) and its integrating apps went well, I cannot successfully change GP user passwords.
Specifically, in the GP User Setup window, I will change a password to something complex and have the three Advanced SQL Server checkboxes at the bottom of the window checked.
When I try to login to the main GP screen with this new password, GP accepts it and prompts me to change it. That's good.
But, no matter what I change it to, I get the message saying that the "login failed for an unknown reason and to contact your administrator".
I tried this with two GP user IDs, in this test environment.
I have tried every remedy that I have found in my own arsenal of technical documents and those online but to no effect.
Now, some of the IT people that I work with do not believe in using the steps for the "Capture_Logins.sql" script. I have no doubt that those steps were not taken.
In any case, the only user that can successfully login to GP in this test environment is "sa".
Does anyone have any ideas?
Thanks!
John
