Post reply

Granting SA to group

  • July 19, 2012 at 3:56 am

    #264110

    Hi all - I think I maybe being thick. I have installed a new SQL instance giving a group SA access at the time. My account is part of the group in AD, however I am getting a login denied when I try to access the instance.

    I have set it to single user and I have been able to login, what have I missed?

    Thanks

  • July 19, 2012 at 6:25 am

    #1514786

    when you say you are granting sa access to a group, how did you do that?

    for me, "sa" access means you made the group part of sysadmin, like this?

    (this is way to strong of priviledges, unless this is on a dev machine for developers, by the way)

    CREATE LOGIN [DEV223\Power Users] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

    GO

    EXEC master..sp_addsrvrolemember @loginame = N'DEV223\Power Users', @rolename = N'sysadmin'

    GO

    if that is true, all you need to do is make sure your user is part of that group.

    otherwise show us exactly what you did and what you mean.

    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!

  • July 19, 2012 at 6:34 am

    #1514795

    I am talking about adding a group to the Sysadmin server role, which I did at installation time. I can see the group in AD contains my user and that it is also granted Sysadmin in SQL. Yet I can not access the instance using my account.

    I had to put it in single user, add my individual account and grant it sysadmin. Switched back to mulit user and can now access the instance.

    This must be something weird in AD or SQL not recognising the members of the group, not sure what I have missed.

Viewing 3 posts - 1 through 3 (of 3 total)

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