connection test successful - login fail

[chengjian.ye]

Hello, there is a user in my company, that connection test was successful, while login failed.
How can I check reason, troubleshooting for him?
Thanks.

Environment: ASG RD 2018, SQL server 2016
Users are organized in AD group, authorization is set on Database permission.


   
   
   
   

[DevOma]

In current versions you should see the reason for that - in 2018 not always - so it's not easy to check...

Try another user from this client to check if it could be a firewall / network problem - if other user could connect - check the permissions on SQL again for that user...

[chengjian.ye]

So, if keep same backend (SQL server 2016 + AD group for permission), can I directly upgrade this user app to current version (ASG RD 2020)?
Thanks.

[DevOma]

The user will not be able to work with the old data source without upgrading - but the connection test should run before - so just try to install version 2020 side by side - and try to connect to the old database - perhaps we can see the detailed error then