One Database cannot login

[chengjian.ye]

Environment: ASG RD 2018 + SQL server 2016

Situation: user report that cannot login, I tried with admin account, also failed.

Error: "The used account has no permission to start the program. Please contact your administrator."

"User with name 'myadminaccount' and SID 'xxxxxxxxxxxxxxxxxx' has no access to login."


PS. other databases works fine.


       

[DevOma]

In your database the "Permissions" are activated and the account that you tried to logon is not granted. If you do not know the right account you can manually remove the setting in the database with the following sql statement

DELETE FROM ItemProperties WHERE ItemId = '1BF121C1-EFC4-4851-9407-D652D3B7C5BF' and RolePropertyId = '2924F6D4-8AB0-4EA4-8FE7-1BB078EC86B7'

[chengjian.ye]

Dear Oliver, thanks. It works fine now

[Benton]

In your database the "Permissions" are activated and the account that you tried to logon is not granted. If you do not know the right account you can manually remove the setting in the database with the following sql statement

DELETE FROM ItemProperties WHERE ItemId = '1BF121C1-EFC4-4851-9407-D652D3B7C5BF' and RolePropertyId = '2924F6D4-8AB0-4EA4-8FE7-1BB078EC86B7'

right answer