SQL DB - User setup - intergrated authentication
Is it possible to setup domain groups access and permissions to the RDM database or do all domain accounts have to be added individually?
Currently I am testing with several accounts and can see how security groups allow / deny access to individual groups and connections but for general access to the database it appears that all users have to be setup and assigned rights individually? or is there a way?
potentially I need to have 60+ users attached so management on an individual basis is a bit of a pain!
All Comments (9)
Hi,
This is the role base management. It's only possible with Remote Desktop Manager Server.
David Hervieux
when creating users in rdm enterprise, sql, there is an option to create sql user, is this required to gain access to the db? what does this provide if integrated security is used?
With SQL Server, the login needs to exists if you don't use the Integrated Security. However it must always exists in RDM. So it's possible to add a user only in RDM if you use the Integrated Security and it's already configured correctly.
David Hervieux
sorry but I cannot find much information on "correct configuration" of the sql/rdm,
currently I have a sql server with a database created by rdm, and use integrated security.
do I need to tick "create sql user" when I add users to rdm via administraton.
after changing the db security I no longer need to create sql accounts while using integrated but I have been unable to find any instructions showing the correct process for setup of rdm with sql indicating this requirement. I had to give domain users explicit select and connect access to the db to allow it to work.
Is this correct?
It's correct but you need to create the user in RDM. This allows them to save their own User Settings.
David Hervieux
David is correct, not a good idea to manually create the SQL User within SSMS as you might lose some functionality.
-Brendan
let me explain, I have had to provide group rights to the sql for the db, not specifically adding users to smss . what I am looking for is the CORRECTsetup of sql
I think that you have the good setup, Just make sure to add the users in RDM and you unchecked "Create SQL Server and Login". It's not needed since you have given the access with the AD group in SQL Server.
David Hervieux