Home Forums SQL Server 2008 Security (SS2K8) BUILTIN\Administrators login doesn't appear to be working. RE: BUILTIN\Administrators login doesn't appear to be working.

  • February 27, 2012 at 6:58 am

    #1452042

    adding the login is not enough...did you add them to the server role as well;

    something like this is what you are after, i think:

    --Add/Restore Restore Builtin\Administrators

    EXEC sp_grantlogin 'BUILTIN\Administrators'

    EXEC sp_addsrvrolemember 'BUILTIN\Administrators','sysadmin'

    after you've done that, make sure you are really part of the Builtin\Administrators group:

    EXEC master..xp_logininfo

    @acctname = 'Builtin\Administrators',

    @option = 'members' -- show group members

    does your windows login appear as part of that result set?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!