Post reply

sysadmin

  • 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?

  • August 12, 2010 at 8:31 am

    #1206043

    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

  • August 12, 2010 at 8:33 am

    #1206044

    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

  • August 12, 2010 at 9:16 am

    #1206094

    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

  • August 12, 2010 at 10:37 am

    #1206190

    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

  • August 14, 2010 at 6:01 am

    #1207027

    Guys,

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

    Many thanks,

    Boj

  • August 14, 2010 at 7:03 am

    #1207035

    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

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

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