Microsoft Dynamics CRM 2011 Installation Languages Supported

 

I have been installing Microsoft Dynamics CRM 2011 Server using the English language pack most of the time.  Recently, I was asked to investigate installing it using language pack other then English.

If language other than English is required for installation, then we must confirm ALL of the following servers are installed in the same language edition:

a. Windows Server (2008 R2 or 2012)

b. Microsoft SQL Server (2008 R2 or 2010)

c. Microsoft Exchange Server (2007 or 2010)

d. MSXML

e. .NET Framework

f. Microsoft Dynamics CRM Server 2011

And the languages supported are:

 

Arabic	Chinese (HKSAR)	Chinese (Simplified)	Chinese (Traditional)	Czech
Danish	Dutch	English	Finnish	French
German	Greek	Hebrew	Hungarian	Italian
Japanese	Korean	Norwegian (Bokmal)	Polish	Portuguese (Brazil)
Portuguese (Portugal)	Russian	Spanish	Swedish	Turkish

The appropriate installation language pack can be downloaded from:

http://www.microsoft.com/en-us/download/details.aspx?id=27822

From the download page, use the Change language pick list to select the appropriate language and the page will refresh and the execution file (CRM2011-Server-LAN-amd64.exe ) for download will be updated to the language pack you selected.

Reference Links:

http://technet.microsoft.com/en-us/library/hh699690 

http://www.microsoft.com/en-us/download/details.aspx?id=27822

Microsoft Dynamics CRM 2011 Outlook Client failed to install due to Microsoft SQL Server 3.5 Service Pack 2 failed to be downloaded

With the latest integration between Office 365 and Microsoft Dynamics CRM online services, I have been experiencing a few different installation and connectivity issues.  Today’s issue was originally related to unable to Get CRM for Outlook from the Online notification bar.  When I click “Get CRM for Outlook” button, it pops up a page with url http://go.microsoft.com/fwlink/?LinkID=194222&clcid=0x409 and I had Internet Explorer cannot display the webpage error.  So I decided to download and install the Outlook client manually.  (I am setting up a new CRMOnline demo for a client, hence have to go through this process again)

To download the CRM for Outlook client, I use this link http://www.microsoft.com/en-us/download/details.aspx?id=27821 

During the installation process, I experienced the following error:

The installation has failed.  Microsoft SQL Server Compact 3.5 Service Pack 2 did not download successfully.  To try again, ensure your internet connection is working, then try again.  Click the link below to view the log file.

I decided to download and install it manually.  To download the installation file, I use this link http://www.microsoft.com/en-us/download/details.aspx?id=5783 . 

During installing SQL Server Compact 3.5 SP2, I have the first warning screen.

Warning – On a 64-bit Computer, install both 32-bit and 64-bit versions of the SQL Server Compact 3.5 SP2 MSI files. Existing SQL Server Compact 3.5 applications will fail if only the 32-bit version is installed on the 64-bit computer.  Developers should chain both the 32-bit and the 64-bit MSI files with their applications and install both of them on the 64-bit Computer.  See Install.txt file for more information.  Click ‘Yes’ to Continue.

I clicked ‘Yes’, then continued installation, all went well!  Then I need to configure the Outlook client.  When the Configuration wizard pops up, I selected Server URL to be CRM Online and click test connection, I experienced this error:

Cannot connect to Microsoft Dynamics CRM server because we cannot authenticate your credentials.  Check your connection or contact your administrator for help.

I clicked OK to continue.  Then a login screen pops up.

I input my registered Office365 user name and password, then I see a better confirmation screen

I clicked OK and finally saw a better promising screen.

There is always new experience everyday with CRM!

CRM2011 Set a field to read only

Since I am not a programmer or developer, I always save some frequently used jscript and solutions in my toolbox for quick reference.  Today, I converted one of my CRM4 frequently used jscript and saved to my CRM2011 toolbox. The jscript is to set a field read only.

For CRM4, the jscript is like this:

crmForm.all.new_fieldname.disabled=true;

For CRM2011, the jscript is like this:

Xrm.Page.getAttribute("new_fieldname").controls.get(0).setDisabled(true);

Free AD tool to facilitate creation of test CRM environment

 

When a new CRM project is initiated, one of the most frequent task involved is to setup a dev and/or test environment, either for upgrade, extend or a new deployment.  Setting up a proper test environment, sometimes involves re-creation of AD user objects, so we can restore existing CRM database to perform testing with it in the dev or test environment. I have been using this little free tool (AD manager plus) to help with the bulk creation of AD users without using any script file.

http://www.manageengine.com/products/ad-manager/download-free.html 

Hope it help you too!

Unable to connect to CRMOnline from Developer Toolkit

 

Today, I have been working with the CRM2011 Developer Toolkit on a new machine and getting problems to connect to Microsoft Dynamics CRM Online.  When using “orgname.crm5.dynamics.com” port 443 and https to connect, I am getting “There is an error in XML Document(5, 5)”.  Found this issue related to LiveDevice.xml cache on the local machine, deleted the file from c:\Users\{your user name}\LiveDeviceID\ resolved the connectivity issue!

Enabling Quick Access to CRM2011 Entities for Outlook Client

 

In CRM4, adding frequently used CRM entities (such as Account and Contact) to Outlook’s favourites folder list was part of the routine client setup for me.  All users like it as it allows us to access CRM information quickly.  In CRM2011, due to the Solutions Module, users may find they would have to use the CRM Solutions or the very long Outlook Mail folder list to access CRM data. 

Picture 1: Solutions Module in Outlook 2010

Solution module is an added feature in Outlook 2010. For users still using Outlook 2007 or Outlook 2003, you can still add CRM2011 entities to your Outlook Favourites folder list by right click the CRM entity and select Show in Favorites. 

Picture 2: Showing CRM entity in Favourites list.

To enable quick access to CRM2011 entities in Outlook 2010, I have found 2 work-around so far. 

* Disable the CRM2011 Outlook client solution module as per Microsoft KB article KB2494600 http://support.microsoft.com/kb/2494600 .  So we can have the “Show in Favourites” options when right click any CRM sitemap items in Outlook.

* Use Outlook2010 Shortcuts instead of Favourites

Option 1) Disable the CRM2011 solution module as per KB2494600

1) Close Outlook

2) Click Windows icon and type regedit in the search box, then hit Enter on your keyboard

3) Click Yes if User Account Control windows pops up

4) Locate HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient

5) Right click MSCRMClient, select New and then select DWORD (32-bit) Value.

6) Enter DisableSolutionsModule as the name.

7) Double click the newly created subkey DisableSolutionsModule, replace value 0 to 1. Click OK.

8) Exit regedit.

9) Restart Outlook.  Now you will see the Solution Module is not available anymore.

10) Navigate to Outlook Mail folder list, expand CRM2011 and select any CRM sitemap item (ie. Dashboard).  Right click on the sitemap item and now you will see Show in Favorites option appears.

Option 2) Use Outlook2010 Shortcuts instead of Favourites

I have found this work-around from Frank’s blog. http://mscrmonline.wordpress.com/2011/08/13/shortcuts-setup-in-microsoft-crm-2011-outlook-client/

1) From Outlook 2010 Navigation Pane, click Shortcut

2) Right click shortcuts heading and select New Shortcut

5) Add to Navigation Pane window pops up.  Select the CRM sitemap item and click OK.

6) Repeat the above step 4 and 5 to add more items

7) Use New shortcut group and drag and drop items to groups to organise shortcut items.

8) Use Outlook Navigation Pane options to re-organise your navigation options

Hope you find this helpful too!

CRM2011 On-Premise Installation Failure: The SQL Server ‘{0}’ is unavailable

I have been trying to install CRM2011 On-Premise on a brand new Windows2008R2 Server connecting to a brand new SQL2008R2 server and getting installation failure: The SQL Server ‘{0}’ is unavailable.  After doing some testing and troubleshooting, found out to be Firewall related and here is what I do to open up port 1433 on a Windows 2008 Server. 

To open a port in the Windows firewall for TCP access

1. On the Start menu, click Run, type WF.msc, and then click OK.

2. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.

3. In the Rule Type dialog box, select Port, and then click Next.

4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next.

5. In the Action dialog box, select Allow the connection, and then click Next.

6. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.

7. In the Name dialog box, type a name and description for this rule, and then click Finish.

While I was troubleshooting, also found these information from CRM2011 Planning Guide to be really useful.

Network ports for the Microsoft Dynamics CRM Web application

The following table lists the ports used for a server that is running a Full Server installation of Microsoft Dynamics CRM. Moreover, except for the Microsoft SQL Server role, and the Microsoft Dynamics CRM Connector for SQL Server Reporting Services server role, all server roles are installed on the same computer.

Protocol	Port	Description	Explanation
TCP	80	HTTP	Default Web application port. This port may be different as it can be changed during Microsoft Dynamics CRM Server Setup. For new Web sites, the default port number is 5555.
TCP	135	MSRPC	RPC endpoint resolution.
TCP	139	NETBIOS-SSN	NETBIOS session service.
TCP	443	HTTPS	Default secure HTTP port. The port number may differ from the default port. This secure network transport must be manually configured. Although this port is not required to run Microsoft Dynamics CRM, we strongly recommend it. For information about how to configure HTTPS for Microsoft Dynamics CRM, see "Make Microsoft Dynamics CRM 4.0 client-to-server network communications more secure" in the Microsoft Dynamics CRM Installing GuideMake Microsoft Dynamics CRM client-to-server network communications more secure .
TCP	445	Microsoft-DS	Active Directory directory service required for Active Directory access and authentication.
UDP	123	NTP	Network Time Protocol.
UDP	137	NETBIOS-NS	NETBIOS name service.
UDP	138	NETBIOS-dgm	NETBIOS datagram service.
UDP	445	Microsoft-DS	Active Directory service required for Active Directory access and authentication.
UDP	1025	Blackjack	DCOM, used as an RPC listener.

Network ports that are used by the SQL Server that runs the Microsoft Dynamics CRM Connector for SQL Server Reporting Services server roles

The following table lists the ports that are used for a computer that is running SQL Server and has only SQL Server and the Microsoft Dynamics CRM Connector for SQL Server Reporting Services server roles installed.

Protocol	Port	Description	Explanation
TCP	135	MSRPC	RPC endpoint resolution.
TCP	139	NETBIOS-SSN	NETBIOS session service.
TCP	445	Microsoft-DS	Active Directory required for Active Directory access and authentication.
TCP	1433	ms-sql-s	SQL Server sockets service. This port is required for access to SQL Server.This number may be different if you have configured your default instance of SQL Server to use a different port number or you are using a named instance.
UDP	123	NTP	Network Time Protocol.
UDP	137	NETBIOS-NS	NETBIOS name service.
UDP	138	NETBIOS-dgm	NETBIOS datagram service.
UDP	445	Microsoft-DS	Active Directory service required for Active Directory access and authentication.
UDP	1025	Blackjack	DCOM, used as an RPC listener.