Maximum attributes supported by CRM 4!

During enterprise CRM implementation, we always deal with largr data volumn and massive configuration file. We might come to a point to ask: what is the CRM 4 attribute limit per entity?

If we study the CRM database scheme, noticed that custom attribute are store in separate table which is the extensionbase. So 1 attribute==1 column in the table. Limitation goes back to your SQL database. Different version/platform of the SQL can have different result.

To be confirm, always refer back to the Maximum Capacity Specifications for SQL server.In that microsoft paper, find the limit of column per base table, that is your limit. Eg: SQL 2005 & 2008 is 1024. Which means you can have 1024 attibute per entity creation.

I do some small testing, try to create the 1025 attibute and it prompt me "exceeds the maximum of 1024 columns". Try to reduce the attibutes if can, less columns means it run more faster!

CRM 4.0 Update Rollup 4

Microsoft released the RoolUp 4 for MSCRM 4.0, this time including the rollup for SRS data connector, as usual it was packed into 64/32 bits version. You can get it from the link below
Download Here

Rollup 4 can be uninstall.
Again, backup first before you make any major changes

You can export customizations from a server that has Update Rollup 2 or Update Rollup 3 for Microsoft Dynamics CRM 4.0 installed and import those customizations to a server that has Update Rollup 4 for Microsoft Dynamics CRM 4.0 installed. You can also export customizations from a server that has Update Rollup 4 for Microsoft Dynamics CRM 4.0 installed and import those customizations to a server that has Update Rollup 2 or Update Rollup 3 for Microsoft Dynamics CRM 4.0 installed.


Details of the Rollup 4 documented in KB968176

Report Manager Blank Page

By right, we should be able to see the 2 tabs in report manager homepage, Contents and Properties. BUT now its missing.
Confirm that site already added into trusted site.

Double check on:

1. Browse to the report manager virtual directory, open the web.config. (Make sure it has the <identity impersonate="true"/>)
2. Uncheck the enable anonymous access in the directory security in IIS.
3. Log in locally on your report server computer as a member of the Local Administrators group

My situation is missing the impersonate in web.config
Hope this can help. :)

Latest CRM 4 SDK version 4.0.8

Microsft just release the latest CRM 4 sdk on this month.
Version 4.0.8

You can download it from here

CRM 4.0 Update Rollup 3

Microsoft released the RollUp 3 for MSCRM 4.0, this time including the rollup for SRS data connector, as usual it was packed into 64/32 bits version. You can get it from the link below
Download Here


Details of the Rollup 3 documented in KB961768