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 [...]
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>
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.
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
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 [...]
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
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.
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 [...]
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.
The following is from http://www.interactivewebs.com/blog/index.php/server-tips/ad-fs-certificate-rollover-crm-2011/The FixBasically the certificate automatically rolls over to a new one and ADFS won’t authenticate any more. Here are the steps that seem to fix this issue:Open windows Powershell as administrator (right click runas)Run the following commands:add-pssnapin Microsoft.adfs.powershellset-adfsproperties -autocertificaterollover $trueupdate-adfscertificate -urgentRun the CRM deployment manager Run through Configure Claims-Based Authentication Wizard (no changes)Run through Configure Internet-Facing Deployment Wizard (no changes)Restart the adfs service From a Command Prompt “cmd” Type net stop adfssrv then net start adfssrvRestart the Microsoft Asynchronous processing service From Services Windows Click the Restart Icon while the Service is selected run an iisreset from the elevated command prompt Start RUN “cmd” iisreset