AD Login and Permission
Hello,
little help please:
1. I create the SQL Connection to the Server with Login Mode set to Integrated security
2. Under User and Security Management I add a User: check Integrated Security AD, select my Domain-Admin and set User type to Administrator.
3. Under Options/Security I check "User Windows credentials as application password"
4. I log in into RDM as the above Domain-Admin
... and I have no Admin-Rights, for instance cannot manage users, don't see some groups which are filtered by security groups (although in the user settings for domain\admin under Permissions it says "Groups are only available if the user is not an administrator"
In essence, it seems like the user is not being given Admin rights.
RDM is at version 13.0.6.0. I still didn't update, as I still didn't finalize how I want my security handled (currently based on non-AD users in RDM, and different deployments for each set of users). But I want to go away from that, use one deployment and handle the security based on AD-users.
Is there a bug? Do I need a newer version?
Thank you
All Comments (4)
Hello,
As I understand, you are creating an administrator in RDM, but you don't have the administrator right. Am I correct?
If this is the case, I suspect that you are not connected with the proper user on the database.
Could you go in File -> My Data Source Information and send us a screenshot of that report.
Best regards,
Jeff Dagenais
OK, that might be the case - so question: is it enough to log in into RDM with another user to be connected with that user into the database?
I just now checked it, and even if I log into RDM using domain\admin for instance, in SQL I am still logged in as my own user.
Is there a way to change the user in RDM without having to log with that user into windows?
Hello,
If you want to use the Integrated Security feature, but that you don't want to connect on the computer using this user, you would need to use the Run As command to accomplish.
For more details, please consult https://help.remotedesktopmanager.com/tipsandtricks_runas_rdm.htm
Best regards,
Jeff Dagenais
Ah, very good, thank you! Didn't think of that ;)