In a perfect world, everything would function properly all the time. But we are living in a perfect world and support requests are inevitable. When submitting a support request, providing adequate information helps us resolve the issue faster and more efficiently. Oftentimes, seeing the exact message or behavior that is being shown tells us exactly what is going on, allowing us to fix it right away! Windows happens to have a handy dandy built in tool called Snipping Tool that lets you capture a specific area of your screen. Capturing errors with the Snipping Tool is the best and easiest way to make sure you are getting optimal support.  The Snipping Tool has several modes allowing you to select a rectangle area, a free form area, or an entire application window. In addition, it allows you draw directly onto the clipping to highlight or mark important areas. Using the tool is simple and [...]

We ran into an issue recently with multiple servers where a newly created user could not log into Dynamics GP on an RDP server and received the error user password not recognized by Dynamics GP. The Dynamics GP credentials worked fine on some Windows sessions, and not on others. Even when the password was blanked out in SQL using Management Studio, the user could set a password, but when attempting to log in, the user login was denied. One of the things that we found was that the Dynamics GP ODBC connection was being used as an Excel workbook data source, as well as for Dynamics GP. This seems to be a fairly common practice from the partners that I talked with. What we found was that when the user changed the default database for the ease of use of Excel, it appears to have changed the SQL connection string [...]

The installation of eConnect seems to complete correctly but eConnect Integration Service Will Not Start .   To fix this, I checked the error logs and found this in the Administrative Events: Action: Service Startup and Construction of Service Host Current User Name: Input parameters: Exception type: System.ServiceModel.AddressAccessDeniedException Exception message: HTTP could not register URL http://+:80/Microsoft/Dynamics/GP/eConnect/mex/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details). A quick web search found Adam Liposky’s GPUG blog entry, https://www.gpug.com/blogs/adam-liposky/2014/04/28/econnect-service-starts-and-then-stops. He had three steps, only one of which is necessary. The other two are unwise (sorry Adam). Step 3: “I opened the "Microsoft.Dynamics.GP.eConnect.Service.exe.config" file in notepad, which should be located in the following directory: C:\Program Files\Microsoft Dynamics\eConnect 12.0\Service At the bottom of the file, locate the following setting: <serviceMetadata httpGetEnabled="true" httpGetUrl=" http://localhost/Microsoft/Dynamics/GP/eConnect/mex "/> Change the value for "httpGetEnabled" from "true" to "false". Save and close the file, then try starting the [...]

A Dynamics GP customer reported users missing quick links after a Dynamics GP Upgrade on the home page. They tried to re-create them, but when they logged out and back in they were gone again. The SQL script below can be ran to allow them to recreate their home page.   -- change sa to the user ID with the home page problem declare @user char(15) set @user = 'sa' CREATE TABLE HomePage ( USERID char(15), SectionID smallint, DICTID smallint, COLNUMBR smallint, SEQNUMBR int, Visible tinyint, MetricSequence int, Selected tinyint, Mode smallint) INSERT INTO HomePage Values (@user, 1, 0, 1, 1, 1, 0, 0, 0), (@user, 2, 0, 1, 2, 1, 0, 0, 0), (@user, 3, 0, 1, 2, 1, 0, 0, 0), (@user, 4, 0, 1, 3, 1, 0, 0, 0), (@user, 5, 0, 2, 1, 1, 0, 0, 0), (@user, 6, 0, 2, 2, 1, 0, 0, 0), [...]