Create Login
Create Login [\TestAccount} from Windows Go That's the command I'm using to create a login, however, I keep getting, **"msg 15401, level 16, state 1, line 1 windows nt user or group '\TestAccount' not found. Check the name again".** Error. I created a new user Called TestAccount under the computer management, so the user is there.
You've got a `}` instead of a `]` there - is that in your script, or just a typographical / transcription error?
Best Answer
Try tweaking it as:
CREATE LOGIN [ComputerName\TestAccount] FROM WINDOWS;
GO
Verify that the Windows login still exists in the domain. Your network administrator may have removed the Windows login for specific reasons, and you may not be able to grant that login access to the SQL Server.
Syn:
`Create Login [ComputerName\Loginname] from Windows`
