Post reply

Cannot add any group to SQL login on new Win 2008 server

  • May 16, 2008 at 12:32 pm

    #191096

    Hi,

    We have just created a new Windows 2008 server running SQL 2005 64 bit. I am in the process of migrating old SQL 2000 databases onto this new server. One of the databases required a SQL login for some Windows groups that get created from the SMS software. I'm having a problem when I go into create a new login, select object type Groups, from this location , I enter the object name and click Check Names and it finds it. I select okay and everything looks good. But when I click ok on the New Login screen, I get the 15401 error saying that Windows NT user or group not found. I have gone into the Server Manager - Groups and verified that the group exists, and it does. The only thing I see when I click properties is on the bottom right had side of the screen it says "Changes to a user's group membership are not effective until the next time the user logs on." It says this for all the groups on this server and I get the same error message when I try to add any group. I have had the user that is a memeber of this group log off and back on a few times, but it still says the same thing and I still get the same error.

    Anyone have any ideas on what the problem might be? Is there something on the Windows 2008 server setup that we missed?

    Thanks,

    Isabelle

    Thanks!
    Bea Isabelle

  • May 16, 2008 at 1:31 pm

    #816707

    I just brought up a Win08 box but I'm still using Yukon.

    The only thing I can think of that would keep you from being able to do this is Katmai is still beta, so maybe they haven't put that in yet, though that doesn't sound feasible does it...

    OK, I'm not sure exactly. I'd have to look at it and I just don't have a Katmai box up on Win08. Have you verified that it can be done with Yukon on a Win08 box? I'm just spitballing here to try to come up with an idea. Are you crossing domains maybe?

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • May 16, 2008 at 2:31 pm

    #816734

    Hi,

    Yes, I have posted this also in the Microsoft forums. We have another Windows 2008 box with SQL 2005 that is being used for our web and it does the same thing. I get the same exact error that's why I figured it has to be something with the Windows 2008 setup or server.

    Thanks,

    Isabelle

    Thanks!
    Bea Isabelle

  • May 17, 2008 at 9:25 am

    #816871

    Is the security group a local group or a domain group?

    K. Brian Kelley
    @kbriankelley

  • May 19, 2008 at 12:06 pm

    #817366

    Hi,

    It is a local group on the server.

    Thanks,

    Isabelle

    Thanks!
    Bea Isabelle

  • May 19, 2008 at 3:03 pm

    #817464

    Is the SQL Server on the same server as SMS?

    K. Brian Kelley
    @kbriankelley

  • July 15, 2008 at 10:48 am

    #843246

    Has anybody resolved this issue?? I am currently experiencing the same issue and cannot not figure out for the life of me how to fix it. Thanks.

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

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