I noticed a question today on a Microsoft Dynamics CRM discussion site asking “is there anyone who is not trying to sell me their product, that has done something interesting with CRM and Silverlight?” Well yes there is… InteractiveWebs have done several interesting projects with Silverlight as an interface to Microsoft CRM. One of the most interesting of these is a Silverlight membership login system for a grain trading company based in Australia. The business is an organisation that trades produce in a similar way to how shares are traded in the stock market. The difference being that the commodity being traded has been grown by “growers” (farmers) and represents the produce that their farm has for sale in the open grain trade market. Interestingly, Microsoft CRM is being used entirely for the backend management of this trading. This is quite complex in it’s design as you can imagine would… Read More »Microsoft CRM 2011 and Custom Silverlight Development
PCI Failure Today we received notification during a PCI compliance check that our Microsoft CRM 2011 server was not PCI Compliant. The cause of the lack of compliance was due to the server accepting connections via an SSL v 2.0 protocol. Synopsis : The remote service encrypts traffic using a protocol with known weaknesses . Description : The remote service accepts connections encrypted using S S L 2.0, which reportedly suffers from several cryptographic flaws and has been deprecated for several years . An attacker may be able to exploit these issues to conduct man-in-the-middle attacks or decrypt communications between the affected service and clients . See also : http://www.schneier.com/p Download File – ZipSource aper-ssl.pdf Solution: Consult the application’s documentation to dis able S S L 2.0 and us e S S L 3.0 or TLS 1.0 instead. Risk Factor: Medium / CVS S Bas e S core : 2… Read More »Disable SSL 2.0 IIS 7 Windows 2008 64bit with CRM 2011 for PCI Compliance
Cannot Access CRM 2011 site 404 Something strange that we have encountered with CRM 2011 is a 404 – File or directory not found error. What is particularly strange about this one is that the error happens from IE 9 on one computer, but the same URL and site loads correctly with another browser on another computer AND loads correctly to the authentication screens on the same computer but with a different browser. Go figure right! Microsoft show it as: So what is the Solution? We tried a number of things that did not work, and we will not bother to list them all, but interesting the clearing the browser history and cache etc does not fix it but is needed to fix it. 1. Clear history and cache in the browser: 2. Close the Browser entirely 3. Navigate to C:\Windows\Temp and delete everything in that directory. 4. From… Read More »CRM 2011 Server Error 404 – File or directory not found
Sick of seeing the message “Your session in Microsoft Dynamics CRM is about to expire. To continue working, you must sin in again.” and would like to extend the session time so as not to bother you as often? This is quite easy with an IFD setup of CRM 2011. We have an IFD configuration and setup that we use to test settings and some of our CRM Portal – Linking to DotNetNuke on. Taking the server as configured as described here: http://www.interactivewebs.com/blog/index.php/server-tips/microsoft-crm-2011-how-to-configure-ifd-hosted-setup/ We ended up with an ADFS Relying Party Trust that is named “CRM IFD Relaying Party” This is the name we must use in the Windows PowerShell program to make the necessary changes. To Extend the Auto Logout of IFD CRM 2011 or 2013 1. Start Windows PowerShell 2. Copy and Paste the following command into PowerShell and hit enter (you can right click to paste): (Not… Read More »Your session in Microsoft Dynamics CRM is about to expire. CRM 2011 2013 Extend Session Time
Microsoft CRM 2011 allows XRM services that use application/soap+xml content type. When you install Microsoft CRM 2011 in an IFD / hosted environment, it is smart enough to automatically configure IIS gzip compression on the website. What it does not do, is configure the C:\Windows\System32\Inetsrv\Config\applicationHost.config file to compress XRM calls out of the CRM database. In a test we were performing for an update to our Microsoft CRM 2011 Portal technology, we found that retrieving a list of around 20,000 items returned a 19 MB data package without gzip dynamic compression. Not huge but pretty big! What amazed us was that after enabling dynamic compression on the XRM data, this reduced from 19 MB to 890 KB, a huge performance improvement! We also noticed that the Microsoft Hosted CRM 2011 service already has this compression enabled, so we figured if it is good enough for them, then we should give… Read More »CRM 2011 XRM Performance Problem IIS Dynamic Compression
[gard] With CRM 4.0 and Microsoft CRM 2011 there is a default limit for the number items that can be retrieved when making various types of web service calls into the CRM. Typically this limit is set to 5000 but with some types of calls it will return 7000. In any case, the process to remove the limit and set it to 20,000 is very easy. On the server running CRM Click Start, click Run, type regedit in the Open box, and then click OK. Locate and then select the following registry subkey:HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM On the Edit menu, point to New, and then click DWORD Value. Type TurnOffFetchThrottling, and then press ENTER. Right-click TurnOffFetchThrottling, and then click Modify. Type a number other than 0 in the Value data box, and then click OK. Note Step 6 lets you retrieve the number of records specified in the Count attribute of your fetch… Read More »Turn off Microsoft CRM 2011 5000 limit on data retrieval via SDK
If you use IE9, you must be familiar with this message: “Only secure content is displayed.” This kind of messages are implemented by Microsoft because they want to inform you that you are about to access some unsecured content on a website. This is actually a security purpose message. Unfortunately, this kind of messages are more often annoying or unnecessary than useful. Internet explorer show this message when the same website page contain both secured and unsecured content: in this way, some unsecured scripts may have access to secured data on that page. Same thing happens when you play a game (unsecured scripts) on Facebook and want to publish that game information on your wall (secured action). 1. Launch Internet Explorer. 2. Go to Tools -> Internet Options. Then, navigate to Security tab. 3. Click on “Custom level” button. 4. Search for “Display mixed content” under Miscellaneous section. Change it… Read More »How to stop – Only secure content is displayed in IE9 message
CRM 2011 Email Router Problems–She’s a Fickle Bitch Since we published an extensive set of step by step instructions on how to setup CRM 2011 as an Internet Facing Deployment IFD. We have continued on to find a few issues with the Email Router Tool that are probably worth sharing. The Tool Does Not Connect to Exchange 2010 like the CRM 4.0 tool. We had a previous test environment that included CRM 4.0 and the well patched Email Router Tool. It was talking nicely to Exchange Server 2010 using the Exchange Web Service URL: https://server.domain.com/EWS/Exchange.asmx In our instance the HTTPS was configured with an service signed certificate that was a trusted provider. In other words. We purchase an expensive certificate and used that for testing a real world deployment. No self signed junk. That all hummed nicely, but we find that in CRM 2011, the Email Router Incoming Settings, using… Read More »CRM 2011 Email Router Problems–She’s a Fickle Bitch
Today we posted a blog about How to configure IFD Hosted Setup in CRM 2011 Following on from that we tested the migration from CRM 4.0 hosted CRM instillations to the newly configured test environment for CRM 2011. We ran into a few problems (and a few things we did not know) and thought others may benefit from this. CRM Migration The process was reasonably simple for us and for that reason we will just list the steps. Backup the CRM 4.0 database to file. On the new CRM 2011 SQL server, perform a normal SQL database restore from the backup file. Use the CRM 2011 deployment tool to “Import and Organisation”. Specifying the obvious settings for the database selection and user mapping. (In our case, we were on the same domain, so user mapping was easy). All this worked well, but there were a few problems when we went… Read More »CRM 2011 IFD Multi-Tenency Migration Tips
[gard] Like many, we have struggled to configure Microsoft CRM 2011 as an Internet Facing Deployment. There is quite a bit of disjointed and some what typical Microsoft “junk” on how to set this up. So after reading the White Papers, blogs and YouTube videos on the topic, I figured I would need notes for myself as much as anything. This is mostly because I am yet to find one single example that covered the setup I was after. That being: Single Server On an existing domain Running true IFD ready for customer access. The last point it telling, as all the Microsoft examples give a self generated SSL cert, that really is an example of a DEV environment only. We want to test the “real deal”, and don’t mind spending a few $ on a real Certificate to see this in a true working environment. If you need support… Read More »Microsoft CRM 2011 How to Configure IFD Hosted Setup
Today we experienced ‘another’ issue with the Microsoft CRM 4.0 Email Router Configuration Manager. Like many of the other issues with the E-mail router tool, we only noticed when we stopped receiving email association icons in outlook. Normally for us this has ended up being the problem with the Configuration Manager xml configuration files, and has required us to restore them from backup in line with the Official MS fix. Unusually today the error lay elsewhere. With a test of the User and Queue access, we were receiving a message that looked like this: Client found response content type of ”, but expected ‘text/xml’. With an Event Log Entry Event ID: 0 #26090 – An error occurred while opening mailbox firstname.lastname@example.org System.InvalidOperationException: Client found response content type of ”, but expected ‘text/xml’. The request failed with an empty response. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) … Read More »Client found response content type of '', but expected 'text/xml'.
You may have noticed if you connect to a MS CRM 4.0 server after installing Rollup 7 or later, (including rollup 9), that you get a message: Internet explorer has blocked this site from using an ActiveX control in an unsafe manner. The cause of this problem is listed in this MS KB: http://support.microsoft.com/kb/976539 The long and the short of it is a known problem in a situation where you have an established relationship with a CRM server using the Outlook plug in. If you then connect to another CRM server that has had the Rollup 7.0 installed, you will get the error message. Now the official Microsoft Solution to this problem is this: Note You can safely ignore this message and allow blocked content. Go Microsoft. Yet another totally inadequate solution to a known problem! What they should have said was this: 1. In IE click tools / Internet… Read More »CRM 4.0 Internet explorer has blocked this site from using an ActiveX control in an unsafe manner.
Scheduling a CRM System Job to Delete AsyncOperationBase junk from CRM 4.0 with CRM Automatic AsyncOperationBase Delete Tool
As you may be aware, there are some issues with CRM 4.0 and performance being inhibited by AsyncOperationBase table growth. There are a few blogs on the AsyncOperationBase problem here. 1. http://www.interactivewebs.com/blog/index.php/crm/slow-performance-or-large-database-file-in-ms-crm-asyncoperationbase/ 2. Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM 4.0 3. Deadlocks, Performance issues, MSCRM database growth, AsyncOperationBase table increase 4. Managing size of AsyncOperationBase table in CRM 4.0 These great resources lead us down a path of discovery that the is no automated way in CRM to manage this problem. There is however some code examples in the SDK that allow you to place an automated process into the CRM server that can be viewed and managed from within CRM. Only problem is that you need to be a coder to make the SDK process call and action the reoccurring job. I thought this was a bit “Microsoft”. Not being a… Read More »Scheduling a CRM System Job to Delete AsyncOperationBase junk from CRM 4.0 with CRM Automatic AsyncOperationBase Delete Tool