About Tudor Coleman

This author has not yet filled in any details.
So far Tudor Coleman has created 55 blog entries.

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 move: 1. Ensure that everyone has logged out of Microsoft Dynamics GP and close all instances of SQL Server Management Studio. 2. On a machine where Dynamics GP is installed click on Start, then point to All Programs. Then click to expand Microsoft Dynamics, then GP and click on Database Maintenance. 3. When the utility opens select or enter the SQL Server instance name where the Dynamics GP databases are stored. If you are logged in as a domain account with rights to this SQL Server instance you can select the Windows Trusted Authentication method. [...]

By | 2018-07-18T11:23:45+00:00 April 6th, 2015|Dynamics GP|

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 GP Setup.exe from the GP installation media.  This will detect the existing install and give you the option to repair.I used information from the following link and updated it for the new web services that does not run in IIS:https://support.microsoft.com/en-us/kb/943949To determine the scopes in the ADAM database, use the Authorization Manager (Azman.msc) Microsoft Management Console (MMC) snap-in to browse the database. To do this, follow these steps:Click Start, click Run, type azman.msc, and then click OK.On the Action menu, click Open Authorization Store.Click Active Directory.In Windows Explorer, open the following folder:C:Program FilesMicrosoft DynamicsGPWebServicesWebServicesUse Notepad to open the [...]

By | 2018-07-18T11:23:45+00:00 March 24th, 2015|Dynamics GP|

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 set the ReportBuilderLaunchURL to https://serverurl/ReportServer/Report/BuilderReportBuilder_3_0_0_0.appli.... 2. Create a Web.config file in the C:Program FilesMicrosoft SQL ServerMSRS11.instancenameReporting ServicesReportServerReportBuilder folder containing the following <?xml version="1.0" encoding="utf-8"?> <configuration> <compilation tempDirectory="C:Program FilesMicrosoft SQL ServerMSRS11.instancenameReporting ServicesRSTempFiles"/> </system.web> </configuration>

By | 2018-07-18T11:23:45+00:00 January 27th, 2015|Dynamics GP|

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 for GP2013 R2. I found the answer here: https://community.dynamics.com/gp/f/32/t/146554.aspx Thank you to Richard Markham.

By | 2018-07-18T11:23:45+00:00 December 19th, 2014|Dynamics GP|

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

By | 2018-07-18T11:23:45+00:00 October 24th, 2014|Cloud|

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 root directory of the ADFS web page) 2. Made a backup copy of the web.config file in the same directory 3. Opened web.config with notepad 4. Found and un-commented the <add key="logo" value="logo.png" /> key 5. Edited the key to point to our logo file. 6. Saved and closed the web.config file. 7. Made a backup copy of c:inetpubadfslsMasterPagesMasterPage.master.cs 8. Edited MasterPage.master.cs 9. Change the line Page.TitleLabel.Test = PageTitle ; to Page.TitleLabel.Test = "Sign In to:"; 10 Change the line (so the logon page does not display the server name) STSLabel.Text = FriendlyName; to STSLabel.Text [...]

By | 2018-07-18T11:23:45+00:00 July 28th, 2014|Dynamics CRM|

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 Problem Signature 09: System.InvalidOperationException OS Version: 6.3.9600.2.0.0.16.7 Locale ID: 1033 Additional Information 1: 5861 Additional Information 2: 5861822e1919d7c014bbb064c64908b2 Additional Information 3: d1d9 Additional Information 4: d1d94a13d3609d6b740644c12508f581 I found this post from Donna Krizik that solved the problem: http://www.crestwood.com/blog/view/dynamics-gp-2013-crashes-every-time-y... Quick fix: The Business Analyzer Fact Box was the culprit. I used the following script to turn it off and make sure it stayed turned off. Use Dynamics go update DYNAMICS..SY07225 set FactBoxVisible = 0 go CREATE TRIGGER dbo.Update_SY07225_FactBoxVisible ON dbo.SY07225 AFTER INSERT AS Update SY07225 SET FactBoxVisible = 0 go

By | 2018-07-18T11:23:45+00:00 June 11th, 2014|Dynamics GP|

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 the folder that SSRS is installed to. This is something like C:Program FilesMicrosoft SQL ServerMSRS10. The MSRS folders is what you are looking for. 2. Go to the Reporting ServicesReportServer sub directory. 3. Make a backup copy of the web.config file. 4. Open the original web.config file. 5. Find the line: <httpRuntime executionTimeout="9000" /> 6. Replace with: <httpRuntime executionTimeout="9000" maxRequestLength="30000" /> 7. Save the file. 8. Restart SQL Reporting Services. 9. Redeploy the reports.

By | 2018-07-18T11:23:46+00:00 April 25th, 2014|Dynamics GP|

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 solution: IN DYNAMICS GP (login as 'sa'): Created new Security Task: ADMIN_SYSTEM_USER Gave the Task access to: Category: System Product: Microsoft Dynamics Type: Windows Series: System - Activity Tracking Setup - Alternate/Modified Forms and Reports - Remove Security Setup Records - User Access Setup - User Class Setup - User Security Setup - User Setup Created new Security Role: USER_ADMIN and added DEFAULT and ADMIN_SYSTEM_USER tasks to it. Added Role to users security in GP IN SQL SERVER MANAGEMENT STUDIO: From Security: Added the following roles to SQL user accounts dbcreater securityadmin Added the following [...]

By | 2018-07-18T11:26:05+00:00 October 24th, 2013|Dynamics GP|

Dynamics GP DYNSA cannot grant users access to companies or company

We recently had an issue where DYNSA could not grant users access to companies. The User Access Screen would not allow DYNSA to check or uncheck access to any company. We found that DYNSA was not the owner of one of the company databases. Make sure DYNSA is the owner of the DYNAMICS system database and all Company databases. Run: EXEC sp_changedbowner 'DYNSA' against EACH GP database.

By | 2018-07-18T11:26:05+00:00 June 6th, 2013|Dynamics GP|