About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Monday, April 20, 2015


Msg 15025, Level 16, State 2, Line 1
The server principal '[DOMAIN\Faizal]' already exists.

To resolve the Error

1. SELECT SUSER_SID('DOMAIN\Faizal')

0x010500000000000519000000D114792BZ53ZB44C8C29BC2Z1F509700


2.SELECT * FROM sys.server_principals 
WHERE sid =0x010500000000000519000000D114792BZ53ZB44C8C29BC2Z1F509700

3. Get the Login Name and Drop it as follows

DROP LOGIN [DOMAIN\Faizal]



 

No comments:

Post a Comment