MSSQL ERROR 15141: The server principal owns an events notification and cannot be dropped.(Microsoft Sql Server)

MSSQL ERROR 15141: The server principal owns an events notification and cannot be dropped.(Microsoft Sql Server,
Error : 15141)
May 18 2019.

Problem: As a SQl admin you are trying to drop a user from instance logins.
SQL Server Instance—Security–Login–Highlight a user to drop—delete.

The SQL Server errors out with 15141 code.

Solution:
The error just means that the particular user, you are trying to drop, has event notifications enabled/active.
Run this query:

SELECT
s.name AS ‘EventNotificationName’
, p.name AS ‘PrincipalName’
, ‘DROP EVENT NOTIFICATION ‘+s.name+’ ON SERVER;’ AS ‘DropEventNotificationQuery’
FROM sys.server_event_notifications s
LEFT JOIN sys.server_principals p
ON s.principal_id = p.principal_rror
WHERE p.name = ‘domain\user’;

replace domain\user with your domain and user.

Should give you the broker processes the user has notifications enabled and the last column will give you the SQL statement to drop the notifications.
Once that is done you should be able to Drop the login.

Prakash.

Leave a Reply

Your email address will not be published. Required fields are marked *