After everything was finished I updated one of the clients. Only one of those, the DEFAULTUSER or the user specific group may need to be edited to include the report. Join the community of 500,000 technology professionals and ask your questions. I have the error message in the first two screenshots. http://axishost.net/error-accessing/error-accessing-security-set-data.php
Dynamics Gp Report Writer Error Accessing Sql Data Error Codes are caused in one way or another by misconfigured system files in your windows operating system. Suggested Solutions Title # Comments Views Activity Buffer provided to read column value is too small. The other step is to rename your reports.dic file, open Great Plains and then restore it from backup. All rights reserved. my review here
It completed 4 companies fine and then utilities quit responding. I also deleted the REPORTS.DIC file and re-imported, and didn't help either.Could someone please help me on this issue? Featured Post How to run any project with ease Promoted by Quip, Inc Manage projects of all sizes how you want. I did a backup before the upgrade and after.
You'll receive secure faxes in your email, fr… eFax Advertise Here 804 members asked questions and received personalized solutions in the past 7 days. Reply Somakarpagamoorthy Kanagasabapathy Works For Business Experts Gulf in UAE - Dubai @soma_moorthy LinkedIn Google+ YouTube Blog Website My Badges Verified Answer Somakarpagamoorthy Kanagasabapathy responded on 15 Jun 2014 9:25 PM This helped me out greatly.ReplyDeleteAnonymousApril 16, 2013 at 7:21 AMGreat stuff, thanks!ReplyDeleteAdd commentLoad more... Let us know what happens.
Here, we not only had to write a script that created a script against each company, but also against each user as follows: -- Don't forget to set Results to Text I'm trying to find the difference between these User Securities (I don't think there's any though).Thank you very much for your help in this!-Elizabeth K. Error When Running Dynamics GP SQL Reporting Servi... his explanation How does it work?
If you have a backup of your reports.dic from prior to the update, restore Go to Solution 5 Comments LVL 13 Overall: Level 13 MS SQL Server 2005 11 MS Additionally, when a user is granted access to a company, their SQL login is added as a SQL user in that company's database as part of the DYNGRP role. Maybe add some steps I can follow. In some cases the error may have more parameters in Dynamics Gp Report Writer Error Accessing Sql Data format .This additional hexadecimal code are the address of the memory locations where
If yes, change it to standard and try again. https://groups.google.com/d/topic/microsoft.public.greatplains/gxdrpvXblUg Open that group in the A/MFR and edit it to give the user permission to the reports. Sponsored Links Post Reply Tweet Forum Jump -- Select Forum -- GP - Installation and Administration GP - Customization and Integration GP - Web Applications GP - General SL The corrupted system files entries can be a real threat to the well being of your computer.
For more information on how the V10 Security system works, you may want to get a copy of our Dynamics GP Security Handbook. http://axishost.net/error-accessing/error-accessing-sql-data-great-plains-report.php Dynamics User w/ Missing SQL User This is the case where a Dynamics GP user has been given access to a company in GP but the corresponding SQL login doesn't have Fixing all this by hand would have been a nightmare, so we decided to write a script that would fix it. I can't even find "SQL Management Studio".....I have SQL Server Configuration Manager is that the same thing?ReplyDeleteShah MoinMarch 9, 2011 at 2:47 PMGreat article John !!
All rights reserved. Under Administration, under Setup/System, open the Alternate/Modified Forms and Reports. To unlock all features and tools, a purchase is required. http://axishost.net/error-accessing/error-accessing-sql-data-microsoft-dynamics-10-0.php If yes, how to modify it in the reports?I tried re-importing the reports to each user but that didn't help.
in Ballston Lake, New York My Badges Richard Wheeler responded on 29 Aug 2012 3:13 PM Step 1) Is this a modified report? SQL User in Company Database w/o Membership in DYNGRP SQL Database Role In this case, the Dynamics GP user has access to a company and their corresponding SQL login has access Thanks in advanced for your help!-Elizabeth Reply All Responses (2) Richard L.
Reply Industries Education Government Health Discrete Manufacturing Hospitality and travel Retail and consumer goods For customers Small and midsize businesses Enterprise Envision Microsoft Ignite Microsoft AppSource For partners Microsoft partner resources Disclaimer: This website is not affiliated with Wikipedia and should not be confused with the website of Wikipedia, which can be found at Wikipedia.org. This tool will scan and diagnose, then repairs, your PC with patent pending technology that fix your windows operating system registry structure. Newer Post Older Post Home Subscribe to: Post Comments (Atom) DynamicsGeek Exploring the technology behind Microsoft Dynamics GP...Some of it at least.
I never had any more problems and it upgraded all of the companies without any errors. Whaley Website My Badges Richard L. Novice Computer User Solution (completely automated): 1) Download (Dynamics Gp Report Writer Error Accessing Sql Data) repair utility. 2) Install program and click Scan button. 3) Click the Fix Errors button navigate to this website Weird thing was, when I added Tax Detail Summary, it printed, which is not the way we had done it before.