SQL Server Error 916 - The server principal is not able to access the database under the current security context

(0) Share

Report

Posted on by Community Member

SQL Server Error 916 - The server principal is not able to access the database under the current security context

I am receiving the above error when trying to "Post Transactions" in the GL. This error message normally means that I need to Sync all ownership and security in update databases. I did this but still receiving the error. Anyone have another solution? It would be greatly appreciated.

Thank you,

Frank

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Apps Mexico 1,090 on at

Like (0)

Report

Do you have customizations?

do you use sql or windows security context?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Take a look at this link www.sqlserverlogexplorer.com/fix-error-code-916 hope this will help you out

Was this reply helpful? Yes No
Suggested answer

Ram Peru 2,830 on at

Like (0)

Report

Hello,

Do you have any custom trigger in GLTran/Batch table?

please try the below link for this issue.

community.dynamics.com/.../74563

support.microsoft.com/.../240872

community.dynamics.com/.../14413

support.microsoft.com/.../2655112

please let me know how it goes.

Was this reply helpful? Yes No