sysadmin

Question

sysadmin

Tara-1044200

SSCoach

Points: 15951
More actions
August 12, 2010 at 8:03 am

#239010

Can a domain id get access to SQl Server if that id is an admin on that machine?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

windows authentication is for security purpose only. The access still need to be given from sql server either to the group the id belongs or login id itself

----------
Ashish

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Only if Builtin\Administrators is granted login and a member of the sysadmin server role.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 3

GilaMonster (8/12/2010)
Only if Builtin\Administrators is granted login and a member of the sysadmin server role.

AND if you decide to remove Builtin\Administrators make sure that you do some reading to understand the implications. A good article to start on this site[/url].

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

David Benoit (8/12/2010)
GilaMonster (8/12/2010)
Only if Builtin\Administrators is granted login and a member of the sysadmin server role.
AND if you decide to remove Builtin\Administrators make sure that you do some reading to understand the implications. A good article to start on this site[/url].

Bearing in mind that in SQL 2008 (and later service packs of 2005) Builtin\Administrators is not mapped as a login by default.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Mithra SSChasing Mays Points: 639 More actions · Answer 5

Guys,

Can someone give me a script that fires a trigger whenever sysadmin access is granted to a builin\adminstrator login.

Many thanks,

Boj

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Please post new questions in a new thread. Thank you.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass