CRM 2015 2013 find Dependencies for Managed Solution

How to Delete a Managed Solution in CRM 2013 or CRM 2015

Sometimes when you try to delete a managed Solution, there is an error message about the dependancies of the solution being in use.

CRM Cannot Delete Component

When you download the log file, you see some typical Microsoft Crap that really does nothing to help you.

Screenshot 2015 04 12 16 02 08

The only thing it does is to tell you that you can’t delete the component because it is being used in this case by two other components.

Now the hard part is finding the components that are using it.

 

Finding the Referenced Dependencies CRM 2015 Components

1. Work out the Solution Name. Navigate to CRM / Settings / Solutions – and read the exact Name of the Solution to be deleted. In this case it was “ZendeskCRM2011Connector

Deleting CRM Managed Solution

 

2. Login to your CRM Server and open the SQL database that matches the Organisation name being used in CRM.

3. Execute an SQL query against that database that reads.

select
SolutionId
from
Solution
where
UniqueName
=’Name of your Solution

(Replacing the Name of Your Solution) with the exact name of your solution, So in our case:

select
SolutionId
from
Solution
where
UniqueName
=’ZendeskCRM2011Connector’

And it executes to give:

CRM Find GUID for Managed Soltuon

This gives you the GUID of the managed solution in the results area. In our example it is the: 3AC85885-F78B-47A3-BAB5-F8DE569B4EDD number at the bottom.

4. Now navigate to the following URL: 

https://YOUR CRM URL/tools/dependency/dependencyviewdialog.aspx?objectid=GUID&objecttype=7100&operationtype=dependenciesforuninstall

 

Replacing the “YOUR CRM URL” with the URL to your own CRM system.  and replace the GUID with the GUID retrieved from step 3 above. Thus the URL may look like this: 

https://crm.iwebscrm15.com:444/tools/dependency/dependencyviewdialog.aspx?objectid=3AC85885-F78B-47A3-BAB5-F8DE569B4EDD&objecttype=7100&operationtype=dependenciesforuninstall

 

It will show a page that looks like this: 

Show Solution Dependencies CRM 2015

 

Which you can use to help you work out what to edit to remove the dependencies and delete the solution.

Thanks Microsoft for making something so easy so hard!

 

 

Setting up CRM 2015 on Windows 2012 R2 and SQL 2014 Stand Alone

Setting up CRM 2015 on a New Virtual Windows 2012 R2 with SQL 2014

Install the Following Components

  • Services
  1. Indexing Service (Windows Search Service
  2. IIS Admin
  3. World Wide Web Publishing
  • Windows Data Access Components MDAC 6.0
  • Microsoft ASP.NET

 

Windows Search Service

The following method is use to install the Windows Search Service on Windows 2012 R2. The search feature is launched form the Server Manger (which will start by default as login as an administrator).

Click Add Roles and Features

Windows 2012 Add Roles and Features

 

Next

Screenshot 2015 03 22 16 15 03

 

Next

Screenshot 2015 03 22 16 15 42

 

Next

Screenshot 2015 03 22 16 16 41

 

Next (without selecting anything)

Screenshot 2015 03 22 16 17 44

 

With the Features, select Windows Search ServiceNext

Screenshot 2015 03 22 16 19 46

 

Select Install

Windows Search Service Feature

 

Select Close

Screenshot 2015 03 22 16 22 15

 

Run through the process again 

Click Add Roles and Features

Windows 2012 Add Roles and Features

 

Next

Screenshot 2015 03 22 16 15 03

 

Next

Screenshot 2015 03 22 16 15 42

 

Next

Screenshot 2015 03 22 16 16 41

 

Next (without selecting anything)

Screenshot 2015 03 22 16 17 44

 

This time select the Web Server (IIS)

Screenshot 2015 03 23 18 09 39

When prompted select Add Features

Screenshot 2015 03 23 18 08 42

Select Next

Screenshot 2015 03 23 18 13 00

Next

Screenshot 2015 03 23 18 13 15

Next

Screenshot 2015 03 23 18 13 19

Next

Screenshot 2015 03 23 18 13 36

Close

 

Installing SQL Server

When installing the SQL server, the required features are almost the default features with the following two ticks.

1. Database Engine Service

2. Full-Text and Semantic Extractions for Search

 CRM 2013 SQL 2012 Requirements

 

Additional IIS Feature to Add for IIS

CRM will work much better with IIS Dynamic Compression. The install this you follow the normal Roles and Features install, and find the section for:

Web Server Role (IIS)

Second option: Under Server Manager click Add roles and features       

  • Click Next for Role-based or featured-based installation       
  • Select Server Roles       
  • Expand Web Server (IIS) role     
  •  Under Performance check the option for Dynamic Content Compression

IIS Dynamic Compression Feature

Click Next

This ensures that you can enable dynamic compression after install to ensure that performance is best.

 

 

 

 

 

 

CRM 2015 Extend Auto Logout Time in IFD

CRM 2015 IFD will Automatically Logout the user with a Message:

Your session in Microsoft Dynamics CRM is about to expire. To continue working, you must sin in again.

CRM 2015 Auto Logout

By Default this setting is 60 minutes, and the message will pop up around 20 minutes before logout.

Any unsaved changes will be lost as your session ends.

 

The Fix

To extend the automatic logout time in CRM 2015, we must extend the time set in ADFS 3.0 using the PowerShell command. First we need to know the name that was used to set up the Relying Party Trust in ADFS.

1. Open Server Manager and from the Tools menu select ADFS Management

ADFS Management

2. in AD FS management, open Relying Party Trusts and find the Display name for the CRM IFD Relying Party Trust

Screenshot 2015 04 03 17 30 58

In this case, we have called the Relying Party Trust – “CRM IFD Relying Party” as we keep things simple when we create things. Using the exact name for the title of the trust as we created it. But really it could be anything. One distinguishing feature is that the URL identifier is going to be optioning to the URL that displays in the browser window when you are in the process of login into your IFD CRM.

3. Start PowerShell

Screenshot 2015 04 03 17 35 57

4.  Check you have the correct name of the Relying Party Trust by typing the following command.

Get-ADFSRelyingPartyTrust -Name "relying_party"

Where you replace the “relying_party” with the name you identified in Step 2 above. In our case the command will be: 

Get-ADFSRelyingPartyTrust -Name “CRM IFD Relying Party

 

The result should look something like this if you get it correct.

Screenshot 2015 04 03 17 40 02

5. Not type the command to set the time you want to set for Auto Logout.

Set-ADFSRelyingPartyTrust -Targetname “CRM IFD Relying Party“ -TokenLifetime 720

(Again replacing the “CRM IFD Relying Party” with the name used on your system.)

Note: The 720 is time in minutes. 8 Hours in this case. You can change the value up and down as liked.

Set-ADFSRelyingPartyTrust -Targetname “CRM IFD Relying Party“ -TokenLifetime 720

Screenshot 2015 04 03 17 43 47

6. Close out the PowerShell and you are done.

SQL 2014 ‘Agent XPs’ componet is turned off when accessing Maintenance Plans

When trying to create a Maintenance Plan you get an error: 

‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure. For more information about enabling ‘Agent XPs’ see “Surface Area Configuration” in SQL Server Books Online. (Object Explorer)

Screenshot 2015 04 01 14 39 39

Details of the error are:

===================================

Cannot show requested dialog.

===================================

Unable to execute requested command.

——————————
Program Location:

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

===================================

‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure. For more information about enabling ‘Agent XPs’, see “Surface Area Configuration” in SQL Server Books Online. (Microsoft.SqlServer.Management.MaintenancePlanWizard)

——————————
Program Location:

at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.LoadData()
at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm..ctor(XmlDocument doc, IServiceProvider serviceProvider)

 

The Cause

This is caused because the “SQL Server Agent” is not running.

By default, this service is set to start manually. This is normal after a fresh install.

 

The Solution

1. Open SQL Server Configuration Manager

2. Start the service for SQL Server Agent.

SQL Server Agent

3. Right click the service and select Properties

Screenshot 2015 04 01 14 43 29

4. Click the Service tab and change the start mode to Automatic

Screenshot 2015 04 01 14 43 48

That’s it! 

 

 

CRM 2015 IFD Adding a New Organization Additional Steps

Error when attempting to login to a New Organisation in CRM 2015 IFD

When attempting to login to a newly configured Organisation you may receive an error looking like this.

Screenshot 2015 03 28 18 43 05 

             An error occurred
An error occurred. Contact your administrator for more information.

 

  • Activity ID: 00000000-0000-0000-1400-0080010000ff
  • Error time: Sat, 28 Mar 2015 07:37:45 GMT

 

The Cause

Because IFD (Internet Facing Deployment) uses the AD FS Authentication it requires an additional step after using the CRM Deployment Manager to setup a new Organisation to then register at login with the AD FS setup.

Basically it is saying that you have set up the org, but not gin figured the authentication login settings in AD FS.

 

The Fix

1. Open AD FS Mananagement

Screenshot 2015 03 28 18 46 58 

2. Click on AD FS / Trust Relationships / Relying Party Trusts and local your CRM IFD Relying Party Trust associated with the IFD Authentication.

Screenshot 2015 03 28 18 49 52 

3. Highlight it, and select Update Federation Metadata

 Screenshot 2015 03 28 18 50 30

4. Update

Screenshot 2015 03 28 19 04 29 

And you are done!

You should now be able to login to the CRM server without getting the error message, and with no need to reset IIS or any other services.

 

 

 

CRM 2015 Reporting Extension Setup Error The SQL Server Reporting Services account is a local user and is not supported

Error Message installing CRM 2015 Reporting Extensions

When installing Microsoft Dynamics CRM Reporting Extension Setup you receive an error message: The SQL Server Reporting Services account is a local user and is not supported. This is during the System Checks.

SQL 2014 CRM 2015 Reporting Extension Setup Error.png

In our instance this was with MS CRM 2015 on SQL 2014 on the same server in a test environment.

The Solution

The fix is easy.

1. Open the SQL 2014 Reporting service configuration Manager

Screenshot 2015 03 28 17 56 17

2. Connect to your Server.

Screenshot 2015 03 28 17 57 04

3. Select the Service Account

Screenshot 2015 03 28 17 57 37

4. Select the Local System account and apply with the appropriate security levels.

Screenshot 2015 03 28 17 58 25

That’s about it. Run the setup process again and you should be good to go.

Windows 2012 R2 C:\Program Files (x86)\PHP\v5.6\php-cgi.exe – The FastCGI process exited unexpectedly PHP

The FastCGI process exited unexpectedly – Trying to run PHP on IIS 8.0

This problem has been talked about extensively around the forums, but no one is being clear on how to fix the problem. The issue first appeared after installing new Windows 2012 R2 Release.  after using  the Windows Web platform installer 5.0 to install  the framework PHP 5.6.0 and I might add when we tested on PHP 5.5 .11, a simple test page return the error: C:\Program Files (x86)\PHP\v5.6\php-cgi.exe – The FastCGI process exited unexpectedly

The Solution

You need to install the: Visual C++ Redistributable for Visual Studio 2012 Update 4  32-bit version.  and it should be noted that even if your operating system is a 64-bit operating system, you must install the 32-bit version  as PHP does not run in 64 bit.

 A download link is here: http://www.microsoft.com/en-us/download/details.aspx?id=30679

Select the download button

FastCGI Process exited unexpectedly

 

Select the 32 bit version or x86

Screenshot 2015 03 23 00 36 43

Screenshot 2015 03 23 00 37 01

 

You are done!

Screenshot 2015 03 23 00 37 10

Test your PHP and you should be good to go.

Windows 2012 Turn off Password Complexity

How to disable (turn off) the default Windows 2012 Administrator Complexity

1. Open the Administrative Tool

Windows 2012 Password Complexity.png

2. This places you in the Administrative Tools section. Select Local Security Policy.

Windows 2012 Password Local Security Policy.png

3. Change the password Must Meet Complex Requirements option to Disabled.

In a Domain Environment, for an Active Directory Domain Server.

  • In the Server Manager click on Tools and from the drop down click Group Policy Management
  • Expand Forrest >> Domains >> Your Domain Controller.
  • Right click on the Default Domain Policy and click on the Edit from the context menu.
  • Now Expand Computer Configuration -> Policies -> Windows Settings -> Security Settings -> Account Policies -> Password Policy
  • Double-click on the Passwords Must Meet Complexity Requirements option in the right pane.
  • Select Disabled  under define this policy setting:
  • Click Apply then OK all the way out and close the GPO window.
  • In order to refresh the policy type the following command: “gpupdate /force”  in the CMD window and click ENTER.

CRM 2015 Improve Outlook Client Performance Issue WFC Compression

CRM 2015 Outlook Performance

After installing the Microsoft CRM 2015  and client, you may notice that the connection over the internet is slow and not as desired. One likely reason for this is that WCF communication is not compressed, and the outlook client is using that to talk to the CRM server.

Assuming that your current environment is configured correctly with Windows 2012 R2 and IFD, then you can simply update the server to support WCF compression and improve performance for CRM 2015 and outlook.

Enable compression by manually updating the ApplicationHost.Config

1. On the CRM Server Navigate to: C:\Windows\System32\Inetsrv\Config\applicationHost.config and open it with notepad.

Screenshot 2015 03 20 23 03 14

Screenshot 2015 03 20 23 03 29

2. Search for the Section: “<dynamicTypes>” and in that section you should fine an entry that looks like this:  
<add mimeType=”application/x-javascript” enabled=”true” /> 

Screenshot 2015 03 20 23 04 15

3.  Below that, add the following line:  
<add mimeType=”application/soap+xml; charset=utf-8″ enabled=”true” /> 

Screenshot 2015 03 20 23 04 40

4. Save the file and reset IIS for the setting to take effect.

Screenshot 2015 03 20 23 04 53

CRM 2013 Improve Outlook Client Performance Issue WFC Compression

CRM 2013 Outlook Performance

After installing the Microsoft CRM 2013  and client, you may notice that the connection over the internet is slow and not as desired. One likely reason for this is that WCF communication is not compressed, and the outlook client is using that to talk to the CRM server.

Assuming that your current environment is configured correctly with Windows 2012 R2 and IFD, then you can simply update the server to support WCF compression and improve performance for CRM 2013 and outlook.

Enable compression by manually updating the ApplicationHost.Config

1. On the CRM Server Navigate to: C:\Windows\System32\Inetsrv\Config\applicationHost.config and open it with notepad.

Screenshot 2015 03 20 23 03 14

Screenshot 2015 03 20 23 03 29

2. Search for the Section: “<dynamicTypes>” and in that section you should fine an entry that looks like this:  
<add mimeType=”application/x-javascript” enabled=”true” /> 

Screenshot 2015 03 20 23 04 15

3.  Below that, add the following line:  
<add mimeType=”application/soap+xml; charset=utf-8″ enabled=”true” /> 

Screenshot 2015 03 20 23 04 40

4. Save the file and reset IIS for the setting to take effect.

Screenshot 2015 03 20 23 04 53

1 2 3 36