Archive for May, 2012

Mobile and Tablets emulators

May 22, 2012

Microsoft Device Emulators

http://www.microsoft.com/downloads/details.aspx?familyid=A6F6ADAF-12E3-4B2F-A394-356E2C2FB114&displaylang=en

Microsoft Windows Phone SDK 7.1 RC Release Notes

http://www.microsoft.com/downloads/it-it/details.aspx?familyid=0a373422-6680-46a7-89e1-e9a468a14259

RIM Blackberry Emulators

http://us.blackberry.com/developers/resources/simulators.jsp

Android Emulator

http://developer.android.com/guide/developing/tools/emulator.html

iPhone e iPad Emulators

http://www.genuitec.com/mobile/ http://iphone4simulator.com/

Advertisements

Install Microsoft Dynamics CRM 2011 without an Internet Connection

May 18, 2012

This article is an update for users who wish to install the Microsoft Dynamics CRM 2011 without an Internet Connection. The blog below should be followed for this process and what pre-requisites are needed:

http://community.dynamics.com/product/crm/crmtechnical/b/crminthefield/archive/2011/03/28/how-to-install-microsoft-dynamics-crm-2011-without-an-internet-connection.aspx

Users may see errors when attempting to install CRM 2011 Outlook Client offline regarding Server Compact 3.5. Errors in the install log conatin such as:

Error | Microsoft SQL Server Compact 3.5 Service Pack 2 does not download correctly. Make sure your Internet connection and try again.     Error | hr = 0xc0040202

To stop this error occurring, you need to add the Microsoft SQL Server Compact 3.5 Service Pack 2 to the pre-requisites folder. You need to download both the 32 & 64 bit versions from the below links and ensure they are placed in the SQLCE folder under the Redist folder structure, and replace the previous SSCERuntime files that were in there.

http://go.microsoft.com/fwlink/?LinkId=147327&clcid=0x40c http://go.microsoft.com/fwlink/?LinkId=147326&clcid=0x40c

CRM 2011 – Form errors when opening non customised forms (object doesn’t support property or method ‘Form load’)

May 16, 2012

You may experience the following error across a number of default entities after installing CRM 2011 on a new server. The errors occur despite having made NO customisations:

There was an error with this field’s customized event

Field: window

Event: onload

Error: object doesn’t support property or method ‘Form load’

Within a fiddler trace, you may see the following:

401 http://<crmserver>/<myorg>/%7B634443390830000000%7D/WebResources/Ribbon_main_system_library.js

404 http://<crmserver>/<myorg>/%7B634443390830000000%7D/WebResources/Ribbon_main_system_library.js

When a Web Resource is requested from the CRM server, a URL is built dynamically. For that, CRM uses a component (that gets installed with CRM) called “Microsoft URL Rewrite 1.1 for IIS 7”, together with a rule that you can see inside the CRM Web site configurations under the URL Rewrite section called “WebResourcesRule”.

It has been seen that in some circumstances the Microsoft URL Rewrite Module does not get loaded properly and/or the rewrite rules are missing. The following can be done to check this:

1)

-Launch IIS Manager on the CRM server

-Select the CRM Website

-Double click Modules under IIS heading

-Verify RewriteModule is listed in the list here and is associated with the following DLL: %SystemRoot%\System32\Inetsrv\rewrite.dll

2)

-Launch IIS Manager on the CRM server

-Select the CRM Website

-Double click URL Rewrite under the IIS heading

-Verify that 3 rules exist here (ClientGlobalContectRule, WebResourcesRule, FederationMetadataRule)

If one or both of the above does not appear correct, then you should perform the following:

A) Make sure that Kernel-mode authentication is enabled:

-Launch IIS Manager on the CRM server

-Select the CRM Website

-Double click Authentication under the IIS heading.

-Select ‘Windows Authentication’

-Click on Advanced Settings in the right hand Actions pane.

-Confirm ‘Enable Kernel-mode authentication’ is marked.

B) Repair or Reinstall the URL RewriteModule:

– The installation msi for the Microsoft URL RewriteModule can be found within the CRM server installation media under a folder called UrlRewriteModule. The file is called rewrite_1.1_amd64_rtw.

– Reboot the CRM Server after reinstalling the module.

When the module is correctly installed, the CRM website web.config file should be automatically updated. To verify this open the CRM website web.config file and make sure the following element is present under <rewrite>.

</security>

<rewrite>

<rules>

<rule name=”ClientGlobalContextRule” stopProcessing=”true”>

<match url=”/?([0-9a-zA-Z][^/]*)?/?((?:%7b|\{)[^/]*(?:%7d|\}))?/?(WebResources|Handlers)/ClientGlobalContext.js.aspx” />

<action type=”Rewrite” url=”/{R:1}/_Common/ClientGlobalContext.js.aspx” />

</rule>

<rule name=”WebResourcesRule” stopProcessing=”true”>

<match url=”/?([0-9a-zA-Z][^/]*)?/?((?:%7b|\{)[^/]*(?:%7d|\}))?/?webresources/([^\\?]+)” />

<action type=”Rewrite” url=”/{R:1}/Handlers/WebResource.ashx?name={R:3}” />

</rule>

<rule name=”FederationMetadataRule” stopProcessing=”true”>

<match url=”FederationMetadata/2007-06/FederationMetadata.xml” />

<action type=”Rewrite” url=”/Handlers/FederationMetadata.ashx” />

</rule>

</rules>

</rewrite>

</system.webServer>

 

Microsoft URL Rewrite Module 1.1 for IIS 7 (x64) can be downloaded from below:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16784

Microsoft SQL Server Community Projects & Samples

May 14, 2012

The SQL Server 2012 RTM versions of the Adventure Works OLTP sample database and Adventure Works data warehouse sample database are available on AdventureWorks for SQL Server 2012.
SQL Server 2008R2 product code samples are available here. Download the AdventureWorks 2008R2 family of sample databases and AdventureWorks 2008R2 sample databases
Note: When you click the big Download button on the SQL Server R2 sample code project page (this one),  you will get the x64 installer and download the SQL Server 2008R2 samples.
SQL Azure AdventureWorks community sample databases can be downloaded from here.
SQL Server 2008 code samples are available here. Download the AdventureWorks 2008 family of sample databases separately.
SQL Server 2005 product samples can still be downloaded and separately AdventureWorks for SQL Server 2005.
CodePlexis the project hosting site for Microsoft SQL Server Samples and Community Projects. Projects listed here are official Microsoft samples for SQL Server (released with Service Packs or major releases of SQL Server) and applications developed by MVPs, and the SQL Server community at large, including:

Unless noted otherwise, the download links are for the latest release of the project; see the individual project sites (on the Releases tab) for prior version releases. Most projects have more than one file download for a given release; read carefully to be sure you choose the ones that you need.

Source: http://sqlserversamples.codeplex.com/

You receive an “HTTP Error 401.1 – Unauthorized: Access is denied due to invalid credentials” error message when you try to access a Web site that is part of an IIS 6.0 application pool

May 9, 2012

When you try to access a Microsoft Internet Information Services (IIS) 6.0 Web site that is configured to use Integrated Windows authentication only, you are prompted for your user credentials.  When you try to log on, you receive the logon prompt again.  After you try to log on three times, you receive the following error message:

HTTP Error 401.1 – Unauthorized:  Access is denied due to invalid credentials.
This behavior may occur if the following conditions are true:

  • The IIS 6.0 Web site is part of an IIS application pool.
  • The application pool is running under a local account or under a domain user account.
  • The Web site is configured to use Integrated Windows authentication only.

In this scenario, when Integrated Windows authentication tries  to use Kerberos,   Kerberos authentication may not work.     To use Kerberos authentication, a service must register its  service principal name (SPN) under the account in the Active Directory directory service that the service is running under.   By default, Active Directory registers the network basic input/output system (NetBIOS) computer name. Active Directory also permits the Network Service or the  Local System account to use Kerberos.

If this behavior occurs when the application pool is running under a local account, follow the steps in the “Workaround” section.
To resolve this behavior when the application pool is running under a domain user account, set up an HTTP SPN with the NetBIOS name and the fully qualified domain name (FQDN) of the domain user account that the application pool is running under.  To do this, follow these steps on a domain controller:
Important    An SPN for a service can only be associated with one account.    Therefore, if you use this suggested resolution, any other application pool that is running under a different domain user account cannot be used with Integrated Windows authentication only.
  1. Install the Setspn.exe tool.  To obtain the Microsoft Windows 2000 version of the tool, visit the following Microsoft Web site:

    To obtain the Setspn.exe tool for Microsoft Windows Server 2003,  click the following article number to view the article in the Microsoft Knowledge Base:

    970536  (http://support.microsoft.com/kb/970536/) Setspn.exe support tool update for Windows Server 2003
  2. Start a command prompt, and then change to the directory where you installed Setspn.exe.
  3. At the command prompt, type the following commands. Press ENTER after each command:
    setspn.exe -S http/IIS_computer’s_NetBIOS_name DomainName\UserName
    setspn.exe -S http/IIS_computer’s_FQDN DomainName\UserName

    Note UserName is the user account that the application pool is running under. Also note that if you are running the setspn.exe command on a Windows 2000 machine, use the -A switch instead of the -S switch.

After you set the SPN for the HTTP service to the domain user account that the application pool is running under, you can successfully connect to the Web site without being prompted for your user credentials.

To work around this behavior if you have multiple application pools that run under different domain user accounts, you must force IIS to use NTLM as your authentication mechanism if you want to use Integrated Windows authentication only.    To do this, follow these steps on the server that is running IIS:
  1. Start a command prompt.
  2. Locate and then change to the directory that contains the Adsutil.vbs file. By default, this directory is C:\Inetpub\Adminscripts.
  3. Type the following command, and then press ENTER:
    cscript adsutil.vbs set w3svc/NTAuthenticationProviders “NTLM”
  4. To verify that the NtAuthenticationProvidersmetabase property is set to NTLM, type the following command, and then press ENTER:
    cscript adsutil.vbs get w3svc/NTAuthenticationProviders

    The following text should be returned:

    NTAuthenticationProviders       : (STRING) "NTLM"

PowerPivot Security Architecture Technical Diagram

May 7, 2012

Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster provides an end-to-end view of the PowerPivot Security Architecture in one view.  This view includes nearly all of the logical security surface areas and illustrates how these systems interact.

Included in this diagram are:

  • Service Accounts
  • SharePoint Databases
  • Security Hardening
  • Automatic Data Refresh
  • User Identity Flow
  • PowerPivot Permissions Levels

image

Because this poster is very large (34″ x 44″) reading in an online format such as a graphic becomes impractical, so we offer it as a downloadable Microsoft Visio, PDF, or XPS document.

original web source

Power View and PowerPivot HelloWorldPicnic Samples for SQL Server 2012

May 4, 2012

These samples use a simple model to demonstrate new features of Power View (formerly Project Crescent), a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, and PowerPivot for Excel for SQL Server 2012.

Download

Microsoft Contoso BI Demo Dataset for Retail Industry

May 3, 2012

A fictitious retail demo dataset used for presenting Microsoft Business Intelligence products.

Download

Microsoft PowerPivot for Excel 2010 Data Analysis Expressions Sample version 1.0

May 2, 2012

Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010. Download this PowerPivot workbook to learn more about DAX calculations.

Download

Microsoft PowerPivot for Excel 2010 Samples

May 1, 2012

Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010. Download examples of the types of reports you can create.

Download