SQL Server

SQL Timeouts and Warnings

  • Posted on: 11 May 2015
  • By: feridun

On CRM servers, in the Event Viewer you might see warnings similar to the following logged against the MSCRMPlatform source with Event ID 17972

"Query execution time of 84.5 seconds exceeded the threshold of 10 seconds: Thread: 91; Database: CRM Database; Server: SQL Server; Query: query/stored procedure"

Unable to validate SQL Server Reporting Services Report Server installation

  • Posted on: 22 July 2011
  • By: feridun

When trying to install the SSRS Data Connector you may encounter the error:
"Unable to validate SQL Server Reporting Services Report Server installation".
There are many reasons why this might happen but I came across a rather obscure one where a 32-bit SQL Server was installed on a 64-bit Windows server. It seems that this combination is not supported as per this article:
http://support.microsoft.com/kb/2223769