Service Unavailable when browsing CRM

After doing some configuration on CRM 4 server, i hit the "Service Unavailable" error when browsing CRM default homepage.

I am using CRM 64 bits version in windows 2003 with IIS6.
Problem cause by the IIS is not pointing to .NET framework v2.0 64bits anymore, since it is 32bits/64bits compatible. I suspect it default back to 32bits version.

Solution: What I did was open Command Prompt browse to [C:\Windows\Microsoft.NET\Framework64\v2.0.50727>] then do an "aspnet_regiis.exe -i" to register it back.

Work like charm for me.
Hope this help others who facing the same problem.

How to enable custom query string passing in CRM 4

Scenario: Auto fill in lookup fill on prospect create mode.

By default, MSCRM do not allow us to change the url of the CRM form,it will prompt CRM error page, for example the new prospect form. Url ended with this" /sfa/leads/edit.aspx"

How can I add custom parameter behind? " /sfa/leads/edit.aspx?user=Yang"
So that I can use javascript grab the parameter and perform additional tasks.

Solution:What
we need to do is change/add a DWORD registry key
named [DisableParameterFilter] under [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM], set the value to 1.

Run iisreset, now you can append your custom parameters like normal ASP.NET web form.

My two cents for SQL Reporting Services

Working with SRS200 this few weeks, some of the trouble wasted me few hours to solve it.
So share some of the issues you might be looking for it.
Index was outside the bounds of the array









This error pop when I hit view report after I had changed the fields included in report. Click refresh button in preview mode remove the error.
It is cause by the report cahce previous columns in preview mode.
The report parameter is read-only and cannot be modified.
The Report parameter is set to read only, for SRS2005, this can be happen when you checked the Internal checkbox in report parameter screen
How to use RowNumber in grouping matrix table
put this expression in the row grouping 1st column.
=RunningValue(Fields!NAME_S.Value,CountDistinct,Nothing)

CRM Plugin: 32bits / 64 bits environment

Recently I found a post on CRM blog, most of the CRM developers develop plugin using 32 bits environment and then need to deploy to 64 bits production server. Latest SDK also included DLL for Microsoft.Crm.Sdk.dll and Microsoft.Crm.SdkTypeProxy.dll

1. If you build using platform neutral, then it should works for both 32 & 64 bits environment CRM
2. If you build using 32bits extension, then it should work on 32bits CRM only.
3. If you build using 64bits extension, then it should work on 64bits CRM only.
   

Reference from ascentium CRM blog

CRM 4.0 Update Rollup 1

Finally the rollup for CRM 4.0 is availabled. Just like usual, it accumulate all the hotfix packages into one installer.

This rollup 1 can be uninstalled.
List of changes can be view on Microsoft KB952858
Make sure you backup your database before apply this rollup!
For those who use development /production server, importing the customizations to Microsoft Dynamics CRM 4.0 Server is not recommended if the CRM version is different.

Updated component:

1. Email router
2. Server
3. Client
   
   Download here