最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

.net - EF Core: An error occurred when the migration wants to be executed - Stack Overflow

programmeradmin4浏览0评论

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?

发布评论

评论列表(0)

  1. 暂无评论