I'm using Dynamics SL 7.0 Sp3.
What happens is that I can log on to any company successfully but I cannot open the shippers screen as a normal user logged on to windaows. However if I log on to windows as a local or network admin I can open the screen well.
I get the following error message:
Description: Stopped working Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: 4011000.exe Problem Signature 02: 7.0.0.0 Problem Signature 03: 4bbf1291 Problem Signature 04: Solomon.Kernel Problem Signature 05: 7.0.0.0 Problem Signature 06: 4903e6a9 Problem Signature 07: 1b7 Problem Signature 08: 0 Problem Signature 09: PSZQOADHX1U5ZAHBHOHGHLDGIY4QIXHX OS Version: 6.0.6002.2.2.0.18.10 Locale ID: 1033 I have tried this on the server and its doing the same. The problem began when I was on FP1 but did not get solved with SP3. Please help
*This post is locked for comments
Chad,
You saved me. The "grant exec on getauthenticationtype to [public]" on the system DB worked.
Hello,
Usually when I see an issue with the OM Sales Orders/Shippers screen, and it's only occurring for non-admin users, it has to do with a SQL permissions issue. Try running the following statement against the SL system db to see if it cleans up the issue:
grant exec on getauthenticationtype to [public]
If the users still cannot open up the sales orders screen, try running a SQL trace using the trace template in the article below to see if you can identify any permissions issues:
Page Title: How to use SQL Profiler in SQL Server 2005 to trace database events in Microsoft Dynamics SL
mbs.microsoft.com/.../MSDSLSQLServer2005_Howto
OR
Page Title: How to use SQL Profiler in SQL Server 2008 and SQL Server 2008 R2 to trace database events in Microsoft Dynamics SL
mbs.microsoft.com/.../MSDSLSQLServer2008R2_Howto
Chad Perkins
Technical Support Engineer
**This posting is provided "AS IS" with no warranties and confers no rights.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156