May 26, 2011 at 8:52 am
Hi
I want to give myself (my ntlogin) sysadmin rights on my local host
do you know how i would do that?
thanks in advance
May 26, 2011 at 9:13 am
If I read your question right. You have a local SQL server but your normal domain login does not have sysadmin rights?
Just add a login in SQL with your domain\user and add it to the sysadmin server role. Done.
CEWII
May 26, 2011 at 9:38 am
dunne.neal (5/26/2011)
I want to give myself (my ntlogin) sysadmin rights on my local host
Another Option to adding you to the Fixed Server Role would be to add you as an Local Administrator (Windows) to you Machine.
You will automatically become a sysadmin and that option will give you full NT permissions to that box.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 26, 2011 at 9:45 am
On a local machine I could go for that. On a server, nope, I would prefer the OS admins NOT have access to SQL..
CEWII
May 26, 2011 at 10:03 am
Elliott Whitlow (5/26/2011)
On a local machine I could go for that. On a server, nope, I would prefer the OS admins NOT have access to SQL..CEWII
I agree but usually the OS Admins are Domain Admins and therefore they automatically inherit the Fixed Server Role SysAdmin on every SQL Server Machine in the Domain.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 26, 2011 at 10:06 am
In 2008 unless you are running it in single user mode the internal security config is in play, and builtin\administrators is not added by default, which means they don't have access.. This was a big deal because it was a common complaint that OS admins had sysadmin rights to SQL by default.. Am I wrong?
CEWII
May 26, 2011 at 10:10 am
Elliott,
I did not know that this issue was addressed in 2008.
Unfortunately I would assume that they could still stop the services and accidently wack or move the Data files, etc.
Thanks.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 26, 2011 at 10:45 am
That they absolutely can do.. But at least somebody would likely notice that.. just loging in is much more transparent.
CEWII
May 26, 2011 at 11:10 am
Elliott Whitlow (5/26/2011)
If I read your question right. You have a local SQL server but your normal domain login does not have sysadmin rights?Just add a login in SQL with your domain\user and add it to the sysadmin server role. Done.
CEWII
i tried but dont have access to do it
May 26, 2011 at 11:13 am
Hold up..
You have to do this with an account that has sufficient rights, you can't just add yourself as an administrator if you don't have another account. If that is what you are trying to do then I bid you adieu.
CEWII
May 26, 2011 at 11:15 am
dunne.neal (5/26/2011)
Elliott Whitlow (5/26/2011)
Just add a login in SQL with your domain\user and add it to the sysadmin server role. Done.CEWII
i tried but dont have access to do it
How did you go about it? What do you mean you tried?
What step by step actions did you take?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 27, 2011 at 1:18 am
Elliott Whitlow (5/26/2011)
Hold up..You have to do this with an account that has sufficient rights, you can't just add yourself as an administrator if you don't have another account. If that is what you are trying to do then I bid you adieu.
CEWII
how do i give myself access to my localhost?
i only want access to the sql server on my own computer, there must be a way?
i dont even have access to create a database
May 27, 2011 at 7:04 am
dunne.neal (5/27/2011)
Elliott Whitlow (5/26/2011)
Hold up..You have to do this with an account that has sufficient rights, you can't just add yourself as an administrator if you don't have another account. If that is what you are trying to do then I bid you adieu.
CEWII
how do i give myself access to my localhost?
i only want access to the sql server on my own computer, there must be a way?
i dont even have access to create a database
Did you install SQL Server on your PC? If not who ever installed SQL Server on your machine or on the PC that image was based on.
You need to logon to SQL Server using a Windows Account that is a member of the SysAdmin Fixed Role or as the SQL Server Account SA.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply