What acces should be given to DBA admin in SQL 2005 server?
I need to give rights acces to a DBA admin group to SQL 2005 server on Windows 2003. I'm not familiar with this kind of acces.
Which rights should I give to let them able to manage the databases? Should I give them also acces on server?
What's the usual system admin does for this kind of request? Is there any proceadure that I can follow?
Microsoft SQL Server 2005Windows Server 2003Active Directory
They definitely don't need to be Domain Admins...