Thursday, February 6, 2014

Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine. MS CRM 4.0 srsconnector installation on report server

while installing the srsConnector for MS CRM4.0 I got the below error....

"Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."

then after asking to google, got to know you must use the patches as my servers are not connected to internet.

you need to use config files and do command line installation.
so include the patch in the config as below...
you will find the 'install-config.xml´ under the srsConnector folder.
add the below tags inside

also the report server URL

then go to command (run as Admin)
cd "
SetupSrsDataConnector.exe /CONFIG install-config.xml

then it should go smoothly...


Friday, August 30, 2013

Service msftesql was not found on computer ‘server_name’.The specified service does not exist as an installed service (MS CRM 4.0 installation error)

while installing ms crm 4.0 i got the below error: Service msftesql was not found on computer ‘server_name’...

so the solution is as follows...
to do this you must have admin privilege
take a back up of the keys...
Run (window + R) > Regedit
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- Rename MSSQLFDLauncher Folder to msftesql
- Reboot System
- Administrative Tools > Services > SQL Full-text Filter Daemon Launcher (MSSQLSERVER) and Check START Status
if you have SQL as named instance, then u will get the error "Service msftesql$instancename was not found on computer ‘server_name’.
sos you have to Rename MSSQLFDLauncher$instancename  Folder to msftesql$instancename .
this is the trick....make sure other application(if used the same DB) does not affected....

Wednesday, May 16, 2012

System.Exception: Action Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction failed. ---> System.Data.SqlClient.SqlException: Windows NT user or group '\SQLAccessGroup {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}' not found. Check the name again.

Sometimes while installing MS CRM 4.0 or 2011 we used to get the bellow error.
this happens while its doing the installation where as the environment checking is over and successful.


"System.Exception: Action Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction failed. ---> System.Data.SqlClient.SqlException: Windows NT user or group '\SQLAccessGroup {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}' not found. Check the name again. "

there are many many resolutions for different people..

1. someone who clicked the retry , it works.. but latter they may face while adding users to CRM
2. some hot fixes will resolve the issue
3. some where uninstalled and installed again works
4. some where installing with minimun credentials with the config file by precreated groups in ad works
5. some where by creating the group in manually in db and click retry also works
6. ask the AD admin , how much it takes to reflect the ad groups once its created , then wait more than that much time and click retry, it should pick it up, so its not getting the groups or user with the name specified...
7. This can be caused due to the CRM privilege groups being left in the SQL Server Security folder when CRM is uninstalled.

below are some links to the above possible solutions

point 6 is bit weired but works...

hope this will help...


Tuesday, May 15, 2012

Workflow Error Message in MS CRM 4.0

if any of the workflows are getting failed in ms crm 4.0, then if we will go to system jobs and see the error, it will not give the details of the message, but it will give a short and general description as "An Error has occured".
to get the details , you just go to advanced find and edit the view by adding the "Message" column, this contains the "details message..." and it will have meaningful description...

in 2011, its very clear.. you will have a details section in the record...


Wednesday, May 9, 2012

Line feeds are not used when you send an e-mail message that uses an e-mail template to render data that has line feeds in Microsoft Dynamics CRM 4.0

When you send an e-mail message that uses an e-mail template to render data that has line feeds in Microsoft Dynamics CRM 4.0, the line feeds that are included in the data are not used. Instead, the data in the e-mail message is concatenated together. The data does not appear on separate lines.

For example, you create a contact type e-mail template that contains the {!Contact:Description;} code. When you try to send an e-mail message that uses the e-mail template for a contact record, the e-mail message should display a description as follows:
Line 1
Line 2
Line 3
However, the e-mail message displays the description without line feeds, as follows:
Line 1Line 2Line 3
This problem occurs if the e-mail template renders data that merges the nvarchar data type and the ntext data type.

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs.
Install this cumulative update rollup on computers that are running the Microsoft Dynamics CRM 4.0 server components

Use the following registry keys(DWORD) to enable the fix:
  • On the Microsoft Dynamics CRM Server, locate the following registry subkey:
    SOFTWARE\Microsoft\MSCRM\SDKEmailTemplateHTMLLineBreak = 1
  • On the Microsoft Dynamics CRM client for Outlook, locate the following registry key:
    SOFTWARE\Microsoft\MSCRMClient\SDKEmailTemplateHTMLLineBreak = 1


A hyperlink text that is generated from an e-mail template is incomplete when you add the template to a body of an e-mail activity in Microsoft Dynamics CRM 4.0

Consider the following scenario. You create a hyperlink in an e-mail template in Microsoft Dynamics CRM 4.0. The hyperlink text contains query string variables. The query string variables include special characters, such as the slash mark (/) or the equal sign (=). Then, you add the template to the body of an e-mail activity. In this scenario, the generated hyperlink text in the body of the e-mail activity is incomplete.
This problem occurs because the e-mail template editor uses a SPAN element to create the body of an e-mail activity. If a URL contains characters that are used as part of a query string variable in a hyperlink, the URL is entered into the SPAN element. If the characters are not encoded by using hexadecimal values, the characters cannot be returned.
To resolve this problem, encode the special characters by using hexadecimal values. For example, encode the slash mark (/) by using the hexadecimal value %2f.
to get the values from URL Encoding Values



Friday, May 4, 2012

MS CRM 4.0 plug-in update of email statuscode

SetStateEmailRequest request = new SetStateEmailRequest();
request.EntityId = new Guid(context.InputParameters.Properties["EmailId"]+"");
request.EmailState = EmailState.Completed;
request.EmailStatus = 3;
ICrmService service = context.CreateCrmService(true); // this is the services getting form context as its from plugin code, other way you ca create the service...
      service.Execute( request );

Tuesday, December 6, 2011

uCertify , The fastest way to IT Certification

I got the kit for ms crm 4.0.
it looks good .
Waiting for the kit for MS CRM 2011.
Will post my review about MS CRM 2011 on my blog MS CRM 2011 Blog
Top 12 features of our Award Winning Prepkits

1. Simple, intuitive, user-friendly interface
2. One click dashboard makes it easy to find what you need
3. Guided learning steps you through the process of learning
and test preparation, including crucial information about
the exam format and test preparation tips
4. Reference Notes and Study Guides organized according to
the actual test objectives
5. Numerous study aids, including study notes, flash cards,
pop quizzes and more
6. Useful Technical Articles section contains information
written by industry experts and How To’s that help for easy
look up to specific questions
7. Collaboration
8. Exhaustive practice questions and tests, starting with
Diagnostic tests to determine your initial level
9. Learning and test modes
10. Customize your tests – decide how many questions,
combine one or more topics of your choice, quiz yourself
on a study note, increase the level of difficulty based on
your performance at any point in time, even create a test
based on the amount of time you have to take a test!
11. Feedback and assessment when you need it, including Gap
Analysis that clearly indicate your areas of strength and
12. Full length Final Practice test that closely simulates those
on the certification exam to gauge your preparation level
for the actual exam

Monday, August 1, 2011

User accesible issue in ms crm 4.0

i faced one issue, that the user in MS CRM is unable to log in, its showing you do not have sufficient permission to view these records.
Even if the user is in enabled list.
i also can disable and enable the user, still the user cud not logged in.

May be the user has been deleted from the AD and after that again created.

What i did is, i just opened the user in crm , then i changed the same to another user, which is not in ms crm, suppose a temp user.
Then i tried to log in using the temp user, i am able to login.
Then what i did is, i swaped back from temp user to the actual user.
Then the actual user was able to login.
This works,
hope this will help somebody really...

Wednesday, June 8, 2011

alternate colors in the main grid of ms crm 4.0

Sometimes the requirement used to come as the records in the main grid to be alternate colors as in normal grid controls.
keep it in mind we are going to alter the aspx page provided by MS CRM :P
To achieve it in CRM just needs some JS code.

1. open the HomePage.aspx from the _root folder
2. append a method onload of the body as <body class="stage" onload="alterGridRecords()">
3. now the function alterGridRecords should be as followed

function alterGridRecords(){
var grid = document.getElementById("gridBodyTable").lastChild; //gridBodyTable is the id, wch will help
for (var i = 0; i < grid.childNodes.length; i++)
if ((i % 2) == 0) {
grid.childNodes[i].style.backgroundColor = "#EEEEEE"; //put color as per the user requested
grid.childNodes[i].colourised = true;
else {
grid.childNodes[i].style.backgroundColor = "#FFFFFF"; //put color as per the user requested
grid.childNodes[i].colourised = true;

this is so simple

one prob in the above is that you will not be able to make the selected records in diff color.
so just a bit twist
grid.childNodes[i].childNodes[2].style.backgroundColor = "#FFFFFF";
this will make alternate colorsonly the 1st column as its being implemented as only one color in ms crm 2011. :P