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
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.
Take a look at this link www.sqlserverlogexplorer.com/fix-error-code-916 hope this will help you out
Do you have customizations?
do you use sql or windows security context?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (