• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

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?
0
adjaddy
Asked:
adjaddy
1 Solution
 
dn0rmCommented:
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!
0
 
adjaddyAuthor Commented:
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.
0
 
lalitgadaCommented:
use windows authentication mode which is full access to database.
0
 
kamindaCommented:
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'
0
 
Amgad_Consulting_CoCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now