Post reply

Windows NT user or group 'DOMAIN\user' not found. Check the name again.

  • October 2, 2009 at 3:59 pm

    #214947

    We are in process of upgrading our sql server databases from 2000 to 2008 ent 64bit, however we are stuck at this point:

    I am trying to create the domain logins to new sql server 2008 with followign script

    CREATE LOGIN [DOMAIN\user] FROM WINDOWS

    , however, it ends up with error message:

    Msg 15401, Level 16, State 1, Line 1

    Windows NT user or group 'DOMAIN\user' not found. Check the name again.

    This domain user does exist in active directory, and it was working fine with sql 2000 server. I have verified there is no duplication SID in database.

    Any guidance will be appreciated.

    Thanks

    Swarndeep

    http://talksql.blogspot.com

  • October 3, 2009 at 9:31 pm

    #1061415

    Are there any errors in the OS system event log indicating the server is having problems locating the domain or talking to the domain controller? That's the first place I'd start if the new server is in the same domain as the older one.

    K. Brian Kelley
    @kbriankelley

  • May 4, 2010 at 8:55 pm

    #1162207

    Such problem occur when we do CRM installation on Windows Server 2008 R2 which is under the domain hosted in Windows 2000 server.

    This kind of error occur when a program calls the LookupAccountName function to retrieve a security identifier (SID) for an account.

    So, CRM installation is stopped when the AD groups created by CRM (SQLAccessGroup, ReportingGroup, UserGroup, etc.) cannot be added into SQL security logins.

    Installing the hotfix including in this article will solve the problem.

    http://support.microsoft.com/kb/976494

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

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