HI,
I have 4 servers that host multiple databases. I am in process to implement role/user based security to limit QAs and Dev Access. As we have dev,test and stage env too, so it make it more trouble to manage login in in all envs. We don't have domain integration to MSSQl, so I will need to manage sql logins for all users.e.g. create new user,edit role ,edit password etc.
I want to manage them centrally to avoid any inconsistency, create/edit user on one server and it may reflect to all server. By searching google I found I can use CMS(Central Management Server) group to manage MSSQL instances, but it use windows authentication only.
Is this good option to manage logins or I may consider some other tools/factors too ?
Thanks