Posts: 52
Threads: 24
Joined: Jan 2018
Reputation:
0
Hello, I upgraded ASG RD to 2018 with SQL server 2016 in my company.
After upgrade, there are some users cannot connect to database environment.
The authorization is by AD group, set in "Security Groups".
I have checked that user's AD account in "User account"
Could you give me a hand, how to trouble shooting this problem?
Thank you.
Posts: 11,101
Threads: 100
Joined: Aug 2006
Reputation:
202
Which error message the users get?
Regards/Gruss
Oliver
Posts: 11,101
Threads: 100
Joined: Aug 2006
Reputation:
202
It's the permission in SQL server - see help file for necessary permissions on SQL Server
Working with environments=>Working in database mode=>Necessary permissions on SQL server instance
Regards/Gruss
Oliver
Posts: 11,101
Threads: 100
Joined: Aug 2006
Reputation:
202
Yes - now you have to check if the user is assigned to this group and have access to the server
Regards/Gruss
Oliver
Posts: 11,101
Threads: 100
Joined: Aug 2006
Reputation:
202
Check the permissions on "Connections" - goto Properties => Security
Regards/Gruss
Oliver
Posts: 11,101
Threads: 100
Joined: Aug 2006
Reputation:
202
Yes - you need to add security groups or add your users to Administrator group
If "Test connection" fails the user can't access the sql server / database - it's network / security related!
Regards/Gruss
Oliver
Posts: 52
Threads: 24
Joined: Jan 2018
Reputation:
0
Sorry, Oliver.
You mean if i enable "Security Groups" by "active user permissions", then only users in "Administrators" can work normally?
Posts: 11,101
Threads: 100
Joined: Aug 2006
Reputation:
202
In your screenshot there is only the Administrators group assigned - so only assigned users to this group are allowed on this item (and sub items) - you can Add security groups and set permissions on each object (or inherit to child objects by default) - you need to login as Admin to set these permissions on object level...
Regards/Gruss
Oliver