Monday, December 31, 2007

Merry Christmas and a Happy New Year

31 December 2007, the last day of the year. I hope that everyone had a wonderfull Christmas and I wish everyone a happy and healthy 2008. Please enjoy the last few hours of 2007 and be carefull with all the fireworks. Last but not least I hope that 2008 will be the year of Microsoft Dynamics CRM:)

Sunday, December 23, 2007

Leaving Atos Origin, starting for iRelate B.V.

Last wednesday was my final day with Atos Origin. From the 1st of January I will be working for iRelate Netherlands B.V. More information will be followed.

Thursday, December 13, 2007

SOLVED: HTTP status 401: Unauthorized Error

Today Microsoft Customer Support & Services has solved our issue with the customer.
Short summary is given below.

Error:
When we try to connect to the Reports Module in Microsoft Dynamics from a desktop (browser) but we receive a
Server Error in '/' Application.
The request failed with HTTP status 401: Unauthorized.
We also get the same error when we try to connect to Settings\Organization Settings\System Settings. When we're loggin into the server (by Remote Desktop) we don't get any errors.
Note that there are 2 ip-addresses configured and DNS is resolving an other ip-address than the server is opening Microsoft Dynamics.

Solution:
Reports in Microsoft Dynamics CRM 3.0 require Kerberos authentication if Microsoft Dynamics CRM and SQL Server Reporting Services (SSRS) are installed on different computers. This requirement means that you cannot use NTLM negotiation.
Add the NTLMForSQLRSServer reg key on the server side.

  1. On the Microsoft Dynamics CRM Server, click Start, click Run, type regedit , and then click OK.
  2. Open the following registry key: HKLM\Software\Microsoft\MSCRM
  3. Right-click MSCRM, point to New, and then click DWORD value.
  4. Type NTLMForSQLRSServer .
  5. Double-click NTLMForSQLRSServer , type 1 , and then click OK.


Tuesday, December 4, 2007

HELP WANTED: HTTP status 401: Unauthorized Error

Dear CRM colleagues,
I have some errors in a development environment of one customer. I receive the following error on the Reports module and Organisation Setting:
Server Error in '/' Application.
The request failed with HTTP status 401: Unauthorized.
Please see some screenshots below. I have checked the Trust for Delegation with the SPN accounts. These are all correctly set. Who has any ideas? Please leave a message on this post for any sollution or remakrs.
Thanks!


Reports error:
Organisation Settings error:
Trust for Delegation setting:

Monday, December 3, 2007

Microsoft Dynamics CRM Visio Shapes

If you're working with Microsoft Visio, you can download some really cool Microsoft Dynamics CRM Visio Shapes. These shapes can be used for different designs and can be downloaded here.
See screenshot below.

CRM time difference

We are struggling with a time difference of 9 hours for a while. The operating systems are configured to the GMT +01:00 timezone but CRM was configured to the GMT -08:00 timezone. You can change the CRM timezone setting by clicking on Tool - Option

You will get the screen below:




Change the timezone settings to GMT +01:00 and apply these setting.


This will solve your problems, good luck.