Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learningsql00
Starting Member
28 Posts |
 Posted - 2012-02-10 : 09:21:41
|
| I have installed SQL Server 2008 R2...I was logged in as a user who is assigned as local admin (in the list of local admin).But still I don't have all the admin privileges, why ?I installed the sql server as mixed mode...I am able to login as sa...but I need this specific user to work like sa...any advise ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 11:00:12
|
| connect to management studio using windows login and check if sa login is enabled by clicking its properties------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-02-10 : 11:41:05
|
quote:
Originally posted by visakh16
connect to management studio using windows login and check if sa login is enabled by clicking its properties------------------------------------------------------------------------
It is enabled, like I mentioned ,I installed the SQL Server with mixed mode. Yes right click gives me the info that is is enables and grant all the privileges.Same for the other user that I am talking about.I am just thinking that sql server doesn't work for local admin and only work for domain admin - it that correct or no ?what to look and where to look ? please advise... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 11:56:11
|
| is your account part of local admin group in machine? then it should have admin provildeges in sql server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-02-10 : 12:43:32
|
| What was your login when you were installing SQL server.If you had logged in as a domain user then the domain user will get admin rights for the sql on the local machine and sql will have only those rights on the network which your domain login has.If you had looged in as a local machine user then that user would get the admin rights for sql server.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-02-10 : 15:08:52
|
quote:
Originally posted by Sachin.Nand
What was your login when you were installing SQL server.If you had logged in as a domain user then the domain user will get admin rights for the sql on the local machine and sql will have only those rights on the network which your domain login has.If you had looged in as a local machine user then that user would get the admin rights for sql server.After Monday and Tuesday even the calendar says W T F ....
It was this login / user that I am talking about....Installed the sql server 2008 when this user was logged in..but this this other program that I am using is telling me that I don't have enough permission.... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-10 : 15:52:09
|
| What other program?Enough permission to do what? |
|
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-02-10 : 16:15:01
|
quote:
Originally posted by russell
What other program?Enough permission to do what?
The problem I am talking about is "System Center Configuration Manager"For installing that problem, SQL Server 2008 is required.So as a prerequisite, it is checking the sql server and telling me that I don't have enough permission. |
|
|
|
|
|
|
Need help with SQL Server 2008 R2