Hi All, I have SQL server installed on a cluster enviroment, current verison of the SQL Server is (Microsoft SQL Server 2005 - 9.00.3152.00 (X64)). Cluster enviroment is setup on Microsoft Windows Server 2003 R2 Ent. x64 Edition with SP2. Issue i am facing is whenever i try to create a Local login in SQL Server 2005 with windows authentication, I am getting an Error: 15401 with a message of "Windows NT user or Group 'Tlqs\xyz' not found. check the name again" I am able to carete domain logins in sql server. but unable to resolve Local logins. Thanks in advance for the help.
Hi Subrath, I got that error today while doing some security accounts; it turned out the account already existed under different name but same SID. This article was helpful for me ... http://support.microsoft.com/kb/324321 Thanks. -- Mohit K. Gupta B.Sc. CS, Minor Japanese MCTS: SQL Server 2005 http://sqllearnings.blogspot.com/ "Subrath Maji" wrote: > Hi All, > > I have SQL server installed on a cluster enviroment, current verison of the > SQL Server is (Microsoft SQL Server 2005 - 9.00.3152.00 (X64)). > Cluster enviroment is setup on Microsoft Windows Server 2003 R2 Ent. x64 > Edition with SP2. > > Issue i am facing is whenever i try to create a Local login in SQL Server > 2005 with windows authentication, I am getting an Error: 15401 with a message > of "Windows NT user or Group 'Tlqs\xyz' not found. check the name again" > > I am able to carete domain logins in sql server. but unable to resolve Local > logins. > > Thanks in advance for the help. > > > > >
