Event ID - 15497

Event Id15497
SourceMSSQLServer
DescriptionCould not add login using sp_addlogin (user = %s). Terminating this procedure
Event InformationCAUSE:
You have called sp_change_users_login with the auto_fix option in an attempt to create a login with the same name as the specified orphaned user. The attempt to create the login failed.

RESOLUTION:
Create the login manually, then use the Update_One option of sp_change_users_login to map the user to the manually created login.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 15497

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.