Avatar of adjaddy
adjaddy
 asked on

MS SQL 2005 Access

hi
I'm a newbie with MS SQL 2005. Could someone tell me how to grant FULL Admin access to a domain account?
Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
Amgad_Consulting_Co

8/22/2022 - Mon
dn0rm

you want full admin access to the database server?  is that correct?

if you could let us know exactly what you are attempting to do that would help us point you in the right direction

let us know, thanks!
adjaddy

ASKER
dn0rm
Nothing really. I have to install MS SQL 2005 for this guy who needs to do some work. He claims he does not have full admin access to the database. FYI, MS SQL 2005 is running on a Window 2008 server and all i want to do is to ensure his domain account which is a member of the local admin group has full admin access. SQL was installed with the local admin account.
lalitgada

use windows authentication mode which is full access to database.
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
kaminda

You can use below sp to assign sysadmin server role to your desired account. The user will have all the admin rights.

sp_addsrvrolemember 'youruserhere', 'sysadmin'
ASKER CERTIFIED SOLUTION
Amgad_Consulting_Co

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question