Skip to content
Skip to content
Eric G. Harrison's Blog

Not as nerdy as I used to be, but still pretty geeky

  • About
← XBox 360 – so much love, so much hate
Urge, what are you doing with my hard drive? →
-->

Changing CRM server IP address resulted in massive slowdown

Posted on May 16, 2007 by ericgharrison
On Monday we moved our offices.  As part of the move, we changed the IP addressing scheme in our office.  As we started using CRM, we noticed that certain things were running quite slowly.  For example, if you attempted to open an Account window, it could take up to 15 seconds, even if you had just opened the same one a moment before!
 
At first I was ready to blame my desktop for this problem.  In troubleshooting it, I remoted into the server as administrator and tried opening some screens, and they opened quickly, making me think that it was my machine.
 
I then tried opening the screens from another computer, and found that they were opening slowly there too, which told me it was not my desktop, but server related.
 
It turns out that the IP address of the reporting server that CRM was pointed to was hardcoded as an IP address, rather than a DNS name.  The result of this was that every time a form was opened that referred to the reporting server, it was timing out waiting for the reporting server.  The reason the administrator wasn’t running into that problem was because as a "limited user" within CRM, none of the screens it has access to (or that I tested in any case) were tied to the reporting server.
 
The solution is to go into the following location in the registry: HKLMSoftwareMicrosoftMSCRM and correct the value in the SQLRSServerURL key.  In our case, I changed it from a hardcoded 192.168.0.2 to the proper DNS name (which is top secret :)).  Then I did a quick IISRESET and everything was golden.
 
Hope this helps someone! – Eric.
 
This entry was posted in CRM. Bookmark the <a href="https://www.ericgharrison.com/?p=70" title="Permalink to Changing CRM server IP address resulted in massive slowdown" rel="bookmark">permalink</a>.
← XBox 360 – so much love, so much hate
Urge, what are you doing with my hard drive? →

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2025 | Blog info WordPress Theme | By Bharat Kambariya