I encountered this error when I want to run my .NET project:
Microsoft.Data.SqlClient.SqlException: 'Logon failed for login 'DESKTOP-S466H9W\User' due to trigger execution.
Changed database context to 'DB_NAME'.
Changed language setting to us_english.'
I ran these commands:
USE DB_NAME;
SELECT name, is_disabled
FROM sys.triggers
WHERE type = 'TR';
Result: it didn't return any records.
EXEC sp_helpuser 'DESKTOP-S466H9W\User';
SELECT *
FROM sys.database_permissions
WHERE grantee_principal_id = USER_ID('DESKTOP-S466H9W\User');
Result:
Msg 15198, Level 16, State 1, Procedure sp_helpuser, Line 142 [Batch Start Line 0]
The name supplied (DESKTOP-S466H9W\User) is not a user, role, or aliased login.
EXEC sp_helpsrvrolemember 'DESKTOP-S466H9W\User';
SELECT *
FROM sys.server_principals
WHERE name = 'DESKTOP-S466H9W\User';
Result:
Msg 15412, Level 11, State 1, Procedure sp_helpsrvrolemember, Line 10 [Batch Start Line 0]
'DESKTOP-S466H9W\User' is not a known fixed role.
SELECT *
FROM sys.policy_group_policies;
SELECT *
FROM sys.server_audits;
Result:
Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.policy_group_policies'.
Also, no changes were made to the SQL Server settings and SQL Server was working properly before this.
Is there another solution?