MSCRM

Open Active Directory Users and Computers. To do this, click Start , click Run , type dsa.msc, and then click OK . On the View menu, make sure that Advanced Features is enabled. Right-click the organizational unit (OU) that contains the CRM security groups, click Properties . On the Security tab, add the user account, and then grant the Full Control permission to the added user account. Repeat the same step for the following CRM security groups that can be located under the OU: PrivUserGroup  SQLAccessGroup ReportingGroup  PrivReportingGroup  Now you should be able to create an organization successfully.

It is possible to close the monitor and view the display the in an external monitor. Please perform  the below steps for the same on Win7 OS. Go to control panel and click on Power options In the left hand navigation, Click on "Choose what closing the lid does". Select "DO Nothing" for all the options you see in that window. Now, to divert the display to the external monitor, click on "Windows key + P" Click on projector only. Now you should be able to see the close the laptop and work on the external monitor.

Issue --------------------- HTTP ERROR 500.22 – Internal Server Error.”   “An ASP.NET setting has been detected that does not apply in Integrated Managed Pipeline mode.” Solution ------------------ Ensure the application pool configured for the MS Dynamics CRM application is correct and has the correct privileges.

Many a times, it is required to scrub the data before it is used in development environments as the data may be sensitive and cannot be shared with the vendors. The  below SQL functions can be used to scrub the data. --Creating the User defined function    CREATE FUNCTION getRandomText(@sLength TINYINT)   RETURNS VARCHAR(10)   AS                 BEGIN                  DECLARE @counter TINYINT                  DECLARE @nextChar CHAR(1)                  DECLARE @randomString VARCHAR(50)                    SET @sLength=10                  SET @counter = 1                  SET @randomString = ''              ...

If for some sane reasons if fetchxml needs to be converted to a SQL Query in MSCRM 4.0, it is possible. It actually requires the below DLL's which are avilable in the folder Server\setup Microsoft.Crm.dll, Microsoft.Crm.Platform.Server.dll and Microsoft.Crm.Reporting.dll The code looks as below : Microsoft.Crm.BusinessEntities.ExecutionContext myContext = new Microsoft.Crm.BusinessEntities. ExecutionContext (OrganizationId from the context); myContext.OnBeginRequest(UserId, false); Microsoft.Crm.Reporting.ReportQueryBuilder myreportQueryBuilderObj = new ReportQueryBuilder(); string Query = myreportQueryBuilderObj.BuildReportQuery(fetchXml, myContext); The query will be returned as string. The Query is not readable but it works, -:)

In web.config file,  system.webServer tag, for the validation element set the value of the attribute   validateIntegratedModeConfiguration to false. This infact helped in my case.

Shortcut Keys  Description F2 ------Edit the selected cell. F5-------Go to a specific cell. F7-------Spell check selected text and/or document. F11----------Create chart. Ctrl + Shift + ; ----- Enter the current time. Ctrl + ; ------------- Enter the current date. Alt + Shift + F1 ----------------Insert New Worksheet. Shift + F3 ---------- Open the Excel formula window. Shift + F5--------------------Bring up search box. Ctrl + A ------------- Select all contents of the worksheet. Ctrl + B ------------ Bold highlighted selection. Ctrl + I --------------Italic highlighted selection. Ctrl + K ------------- Insert link. Ctrl + U ---------------- Underline highlighted selection. Ctrl + 5 ------------- Strikethrough highlighted selection. Ctrl + P ------------ Bring up the print dialog box to begin printing. Ctrl + Z------------ Undo last action. Ctrl + F9-------------- Minimize current window. Ctrl + F10 ------------ Maximize currently selected window. Ctrl + F6 ----...