Archive for the 'CRM Supports and KB' Category

mscrm_log and sql timeout error in Microsoft CRM 4.0

Is your MSCRM_log file getting bigger and bigger? Have you ever considered looking at MSCRM_log.LDF?

The first thing you witness is sqltimeout error and it is almost impossible to use CRM application. If you look at SQL logs, there will be something  like


In order to overcome , one need to shrink the log database file. Remember to take the back-up of CRM database and then go through from these two figures.


Right click CRM Database …Task…Shrink and then choose ….Files. Now one need to choose mscrm_log.


This process will release unused pages. If logfile does not get smaller then you need to check the properties of Database if Option of “Full Recovery” is selected ? Change it to “Simple” and then shrink it. Remember to change it back to Full recovery once you are done .


CRM 4.0 outlook client -Microsoft Visual c++ Runtime installation error

I recently got stucked in installtion of outlook client for a
customer.There was expection while installig Microsoft Visual c++ Runtime .

exception_Unknown (checkbase.cpp:ccheckBase:: Action:315)





 I tried with removing window XP SP 3 , re.installtion of .Netfrmaework version .

But finally i got success after installing .Net framework 3.5 .

Installation of MS CRM 4.0 on Citrix Presentation Server 4.0.

It is quite easy to install CRM 4.0 on Citrix presentation server 4.0 compare to CRM 3.0 but every user need to configure the outlook client for CRM 4.0 unlike CRM 3.0 (in CRM 3.0 we need to click on script to configure the CRM for every user profile).

Here  are  steps:

1 = Intsall the online version of CRM 4.0 through  “Add /remove” program on
citrix server and remember that they must not be any user on  the server.

2 = when you are finished installation then put the configuration wizard on the
desktop of each user via administrator profile .
3 =Every single user need to configure the profile by using configuration wizard.

Finding license key type/value in CRM 4.0

Open the deployment Manager and click on License . There are three columns providing us information about

1 = Licese Type

2 = Number of licensed users

3 = License Key

In order to find the more detail and real value of license key , please use the Organizationname_MSCRM ( default organization in enterprise edition) . Open the SQL server management studio and run the query . It will bring the all infromation one is looking for about key.

Now you can either compare it with the trial version key if you want to make it sure that it is not a trial version key. The trial version keys are located on :

PS” MSDN keys are not present in database”.

MCRM 4.0 email router :An error occurred while opening mailbox

In the event log you see the problem while testing the connection .

An error occurred while opening mailbox .


The best way is to play with access credentails and use  enter the user name
and password while configuring the incoming and outgoing access credentails. The user must be able to open the mail boxes in exchange.

please go through from this post .

Reports: An error has occurred during report processing(rsProcessingAborted) CRM 4.0

Error :

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘xyz’.
For more information about this error navigate to the report server on the
local server machine, or enable remote errors .
solution :

1 = change the datasource to the “Real” database on the reporting
services . Click properties of a single report and then click on data
source and edit the connection string . after that run it . If it
works then reset the IIS and run the report from CRM interface .
2 =You need to  publish your reports again (PublishReports.exe) . Find the
following exe on the crm server , it should be at (C:\Program Files
\Microsoft CRM\Reports) or search on drive.

CRM 3.0 upgrade issue "There is already an object named ‘AttributeTypes’ in the database "

I am adding the screen shots to make the life easy 🙂

Step1 = enable the full text search enable in organizationName_MSCRM databse

USE Northwind_MSCRM
EXEC sp_fulltext_database ‘enable’

Step2 = Manully add the following columns

Step 3= Make it sure SQL jobs are there and running properly .