We have an environment where one of several admins might be asked to perform administrative tasks on a SQL Server 2008 running WS 2008 R2.
We are running mixed authentication and want admins to log in and administer SQL server and the database using their own admin accounts.
What I would like to do during installation, under "data base engine account provisioning" is add a domain security group to the list of SQL administrators and make sure that the admins who are allowed to administer SQL server and the database are in that
Is there a downside to doing that? for example the admin who runs the initial script to create the database might end up the owner of the DB... Will that be a problem, or is there some other approach we should take on this?
What I'm trying to avoid is having admins share a Windows account for DB administration. We mostly use remote desktop for admin tasks and that gets messy with a shared account.
View Complete Post