Wednesday, October 24, 2012

Installing CRM 2011 SSRS Data Connector on Windows Server 2012


I will share some information with you about installing CRM 2011 SSRS Connector in Windows Server 2012. You might already have customers that use SQL Server 2012 and Windows server 2012.
Lets say you want to install SQL 2012 on a Windows Server 2012 and then use SQL Server 2012 Reporting Services for your Microsoft Dynamics CRM 2011 server.
Even though CRM 2011 is not supported with Windows Server 2012 yet.

During the installation of CRM SSRS Connector you will get an error.
The error message is Windows Identity Foundation Installation failed
The error looks like this.
error Win 2012 server

To get around the setup error you must add Windows Identity Foundation from Features. In Windows Server 2012 WIF is a Server feature. So just add the feature.
wif

After you have added the Feature you can run the setup again.

ReportConnectorSuccess
Next the setup will continue to install Microsoft .Net Framework 4 if it’s not already installed.
Remember that Windows Server 2012 is not supported for CRM 2011 yet.
Check out Microsoft Dynamics CRM 2011 Compatibility list to see the versions that are Supported. http://support.microsoft.com/kb/2669061
I really look forward to learn more about Windows Server 2012 !
And I’m currently spending my evenings with SQL 2012 preparing for exam 70-462.
So much new things to learn, really exciting Ler
Cheers!
//Hans

Tuesday, October 2, 2012

Limit or no limit using CRM 2011 Quick Find queries

In CRM 2011 Rollup 10 there is a new system setting where you can choose to limit or not to limit the amount of records that is returned by quick find.
The default setting is to limit the records returned when users search using quick find queries.
As a best practice this should also be limited as it might impact performance of CRM if users do these kind of Quick Find queries.
Users should be using advanced find when searching for records that returns more than a few results.
If you choose to disable the limit for quick find queries you will find the setting under Administration / System settings and in the bottom of the general tab you can select “no”
quickfind  
The limit is 10,000 records
If a user performs a Quick find that returns more than that an error will be displayed
error quickfind
Error
The Quick Find limit is exceeded. Narrow your search by entering a longer query, or use Advanced Find.
But there might be business requirements to disable this limit and now you can do it from the System settings.
Hope you find this information helpful!