Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tracy5436
Yak Posting Veteran
50 Posts |
 Posted - 2014-07-07 : 14:48:41
|
| Hi,I have deleted a windows login user under security in SQL 2012 Management Studio. The users have also been removed from the associated databases. When I try to add back the login, I receive the message 'The server principal 'xxxx' already exists'. What do I need to do so that I can re-add the login ?Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-07-07 : 15:49:24
|
| Deleting the login is all you need to do. Were you successful in deleting the login? You can check if the login still exists using SELECT * FROM sys.server_principals |
 |
|
|
|
|
|
Server Principal already exists