Author: Tudor Coleman

Dynamics GP Excel Drillback. A connection Microsoft Dynamics GP could not be established. Be sure you are logged on to the appr

According to the following link : http://support.microsoft.com/en-us/kb/2966672 If you’re moving your Microsoft Dynamics GP databases and you use the drilldown functionality in the SQL Server Reporting Services or Excel integrated reports, you need to follow the steps below in order to update your server links so the drilldowns will continue to work after the server

Read More
GP 2013 and 2015 GP Web Services "Exception message: The security object does not exist"

After moving the GPWEBSECURITY database for GP Web Services and running a repair we received the following error opening the Security Console: “Exception message: The security object does not exist. Missing Key: 25cc1a21-2cc4-4b13-a1c8-eea186fb688a” Turns out we ran the wrong repair.  DO NOT run the repair from the GP Web Services Configuration Console.  Instead, launch the

Read More
SSRS Report Builder "Application cannot be started, contact application vendor."

When trying to launch Report Builder you receive the error “Application cannot be started, contact application vendor.” I did two things that seemed to of helpled. 1. Open SSMS and connect Server type “Reporting Services”, Server name. Right Click the Server Name in Object Explorer and pick Properties. Under Advanced setting in the Reports section

Read More
Management Reporter 2012 on GP 2015 Couldn't retrieve the list of available databases: The connection attempt failed.

While trying to configure Management Reporter 2012 on a brand new install of GP 2015 I received the following error: “Couldn’t retrieve the list of available databases: The connection attempt failed.” Configuration is SQL 2012 on Server 2012 R2, GP 2015 on Server 2012 R2. Solution: Install Dexterity Shared Components 12 from the install disc

Read More
Disable / Turn off UAC on Server 2012

While User Access Control can protect our servers from malicious attacks on Server 2012 it is a pain. Setting UAC to Never Notify does not turn it off. The following link explains how: http://social.technet.microsoft.com/wiki/contents/articles/13953.windows… Set HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionpoliciessystem EnableLUA value = 0

Read More
Personalize your CRM ADFS Sign-in page

Njevity and our partners wanted to brand the sign in page for our Microsoft CRM ADFS logon page. To do this we had to add a logo file and edit a couple of code and configuration files. On our ADFS servers we did the following: 1. Copied a our logo graphic file to c:inetpubadfsls (the

Read More
GP 2013 Crash on Navigation Lists

Some of our clients have been experiencing a Dynamics GP application crash when selecting a Navigation List. Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: Dynamics.exe Problem Signature 02: 12.0.270.0 Problem Signature 03: 5217d52e Problem Signature 04: WindowsBase Problem Signature 05: 4.0.30319.34004 Problem Signature 06: 5246811c Problem Signature 07: 1432 Problem Signature 08: 17

Read More
Error: The deployment has exceeded the maximum request length

While deploying reports to SQL Report Services you receive the error: “The deployment has exceeded the maximum request length allowed by the target server. Set the maxRequestLength= “20690” in the web.config file and try deploying again. This happen a lot because we forget to make a simple change. 1. On the SQL Reporting Server open

Read More
Grant Microsoft Dynamics GP Users Rights to Administer User Account & Access

We recently were working with a Dynamics GP client that has hundreds of users. They needed to give their IT department the ability to administer GP users and user access without giving them the DYNSA password. We found no documentation on how to accomplish this. So by trial and error we came up with a

Read More