You’re offline. This is a read only version of the page.
817
This is a new install of SL 2011 FP1 on Windows Server 2012. When a user with Sysadmin rights runs the Unemployment Worksheet process they get the error below. I ran Synch in Database Maintenance and checked the users rights. All looks right. Any suggestions?
Processing: Employee: '950046'
System Message 916: [Microsoft][SQL Server Native Client 11.0][SQL Server]The
server principal "Checks\GVC" is not able to access the
database "SIVSystem" under the current security context.
Debugging info: insert wrksutag
(cpnyid,ficawagelimit,gladdr1,gladdr2,glcity,glcpnyname,gls
System Message 6127: Error occurred during an abortable transaction. Processing
will continue.
*This post is locked for comments
Teri,
Was this ever solved?
I am having the same issue after switching my SL 2011 SP1 logins to Windows authentication. The Unemployment Tax worksheet (02.770.00) can be run as SYSADMIN, but the users who used to be able to run (when using SQL logins) can no longer.
Any help would be appreciated.
Kevin
Teri,
In all previous cases we have seen about this issue it has been do to a custom trigger in the DB. Have you tried running a SQL Trace to determine what could be causing the issue?
KB 967955
How to use SQL Profiler in SQL Server 2008 and SQL Server 2008 R2 to trace database events in Microsoft Dynamics SL
Hi Blaine,
Yes, it is the Unemployment Tax worksheet (02.770.00). I just reread my post and I misstated something. Only a user with SYSADMIN rights can run the report. Other users will get the error message I mentioned.
Sorry for the lack of correct information in my post.
Teri
TKNOW,
Are you talking about the Unemployment Tax worksheet (02.770.00)? If ,not please give us the Full Screen Name and Number of the screen you are talking about.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (