The server principal '<domain>\User' already exists. But it doesn’t

Posted by simonsabin on SQL Blogcasts See other posts from SQL Blogcasts or by simonsabin
Published on Thu, 18 Nov 2010 21:04:53 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 167

Filed under:
|
Interesting little situation occurred today, the person I was working with was trying to add a login to a server and was getting the following error. “The server principal '<domain>\User' already exists” They were using a command like this and couldn’t figure out why they were getting the error above because when they looked at the logins setup on the system the login definitely didn’t exist. CREATE LOGIN [<domain>\<user>] FROM WINDOWS WITH DEFAULT_DATABASE = [master] The...(read more)

© SQL Blogcasts or respective owner

Related posts about Tips and Tricks

Related posts about security