Ok so you run the capture login script and then get the below message.
supplied parameter sid is in use
you then try to remove the sid from the syslogins table but you get some message related to 'adhoc' something is not allowed.
then you try to create the record manually and get 'the server principal already exists'
How to fix run the below and replace name with the name of the record you have the issue with. You should be fine now.
EXEC sp_droplogin 'namehere'
No comments:
Post a Comment