What acces should be given to DBA admin in SQL 2005 server?

Hi,

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?

Thanks.

Microsoft SQL Server 2005Windows Server 2003Active Directory

Last Comment

SAM2009

8/22/2022 - Mon

Leon Fester

3/12/2012

The DBA's technically only need access to the SQL database, however they may need to perform server operator or backup operator tasks, so you could consider using those builtin security groups.

They definitely don't need to be Domain Admins...

jogos

3/13/2012

For example ; check eventviewer, perfmon, ...
Does your dba not have to install and configure SQL?
When your database has connection or I/O problems who is supposed to look find that problem?

... if your dba has not access to the server someone else must be given that full responsability and dba cannot even assist.

SAM2009

3/13/2012

ASKER

DBA team will manage all databases on that server then should I give them "sysadmin server role " in SQL security?

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

ASKER CERTIFIED SOLUTION

Leon Fester

3/13/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.