Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adminn rites

Status
Not open for further replies.

Erics44

Programmer
Oct 7, 2004
133
GB
Hi
I cannot administer the databases on my sql server unless I have and admin log on.

can anyone help?
Thanks
 
You already know that you need admin rights to administer databases, so what help do you want?

-SQLBill

Posting advice: FAQ481-4875
 
perhaps he talking about a network admin login vs a database admin login.
 
yes, that is what I am talking about

sorry for not making myself clear

is there a difference?
 
yes there is. basically what you need to do is assign sys admin rights to your account. since you have an account that can do that from you should be fine.

have a admin login. Go to security/logins in enterprise manager. there should be a bunch of names there, one of which should be your account that you use to login to the system. its proably your domain account. right click on it and click properties. under server roles, the top one is system administrators. click that box. and click ok. you should now have sysadm privilages with that account.

logout with the admin account and login with your and test it out.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top