feridun

Unable to validate SQL Server Reporting Services Report Server installation

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 […]

Unable to validate SQL Server Reporting Services Report Server installation Read More »

Export to Excel for re-import

In Microsoft Dynamics CRM 2011 you can export data to edit in Excel and then import the data back to CRM. To do this, you select the Make this data available for re-importing by including required column headings option. The export file has a .xml extension. To edit the file you must open it with

Export to Excel for re-import Read More »

Security groups required by Microsoft Dynamics CRM 4.0

Microsoft Dynamics CRM uses several security groups in Active Directory. Security Group Members PrivUserGroup The account that the CRMAppPool application uses The account that the ASP.NET process model uses The user account that ran the installation The computer account on which the E-mail Router is installed PrivReportingGroup The account for the computer on which the

Security groups required by Microsoft Dynamics CRM 4.0 Read More »

Running negative queries

Sometimes you need to get a list of records (say contacts) that don’t have any related records of a particular type (e.g. appointments). Unfortunately, this is not possible using Advanced Find as it can only return lists of records that have related records (e.g. contacts with appointments). Yes, you can narrow the related records (e.g.

Running negative queries Read More »