October 2, 2009 at 3:59 pm
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
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
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply