CRM Email Router: enabling logging (part 2)

My post  “CRM Email Router: enabling logging” has raised in popularity the last few weeks. It is simple, but IMO it doesn’t don’t contain all the information needed to debug the Email Router. Hopefully, this post can give you some more information.

Locate the Microsoft.Crm.Tools.EmailAgent.xml in the folder C:\Program Files\Microsoft CRM Email\Service.

If the tags <LogLevel> and/or <LogFile> doesn’t exist, add these.


The CRM Team has a quite good post EmailAgent.xml Explained on the XML configuration file.

You have to monitor the file size of the log file. Depending on number of accounts and profiles configured, this file will grow fast. I suggest you only have have set the LogLevel to 3 during the test period (a few hours at the most), and set it back to <LogLevel>1</LogLevel> when you have performed the test scenarios  needed.

Another solution is to create a command file that is scheduled. This script file should stop the email router service, zip the logfile or just delete it, and restart the email router service again.



Exam MB2-867: Dynamics CRM Installation & Deployment (Summary)

I passed the “MB2-867 Microsoft Dynamics CRM 2011 Installation and Deployment” earlier this week. I will summarize my preparations in this post – just to share my experience as a developer taking this kind of exam.

I actually needed a retake of the exam since I failed the exam earlier in February. I have been working with installation and deployment projects with Dynamics CRM for almost a year now, and my boss asked if could take this exam pretty quick. It was a Thursday, and I scheduled the exam on the following Tuesday.

On the next day, in the afternoon, I got a telephone from a desperate customer that told me that they had installed the production Dynamics CRM environment with the trail version, and this had expired the same day. As a service minded consultant, I stepped up to the occasion and started planning the reinstall the same weekend, knowing this was my only chance to prepare for the CRM exam next Tuesday. Shit happens! The full reinstall of the customer CRM environment was completed on 12 hours, including setting up new server, installing CRM 2011 RTM, installing rollups, language packs, and finally restoring the backup of the current organization database and reattach with the deployment manager. Phuuuu!

In addition, I had to prepare to travel for a funeral right after the exam.

The exam was paid for, and I decided to give it a try and I honestly believed I would pull it off – until I saw the first question “Outlook client”….Shite! Newer done any work on Outlook client, and IFD deployment, since none of my customers have been using these features. I got 595 points of total 1000 on my first exam, and decided to roll up my sleeves and start preparing for the retake exam.

Back at the office, I located earlier bought books “CRM Field Guide” and “CRM Admin Bible” and started reading the same afternoon. Luckily, I got company with two colleagues in the next days that were going to take the exam, and we started planning joint reading colloquium. We had three evening where we went through a test we found online. In addition, we discussed a lot of different scenarios we had encountered in project the last year.

My first exam was a total disaster when it came to CRM Outlook client, and some of the installation scenarios. I had mainly done migration scenarios and left most of the security issues to other colleagues and customer personnel. I regret that now 🙂

The MB2-867 is divided into the following part:

  1. Planning the installation
  2. Installing CRM 2011 Server
  3. Installing and deploying CRM 2011 Email Router
  4. Installing and deploying CRM 2011 Client for Outlook
  5. Configuring CRM 2011
  6. Upgrading and redeploying CRM 2011

On my first attempt, I only had good answer on planning, configuring and upgrading. On my last attempt, I had all correct answers on planning, email router, configuring and upgrading. I still had issues with Outlook client and some installation difficulties, but I’m happy with my 95% score.

Now, I will start my journey to complete the “MCSE: Business Intelligence (Solution Expert)” certification – five exams in total this year (hopefully). This will enable me to concentrate on a new area – BI – business intelligence. I have alway wanted to work on BI topics since it combine database, integration between system and representing complex information in a simple way to the end users.


Preparing “MCSA: SQL Server 2012”

I received the three first “SQL Server Training Kit” books from the post office today. My ambition is to complete all three exams before Christmas this year. I probably have enough knowledge to pass the first two exams without reading, but I think I will prepare some during this spring and take the first two exams before summer vacation, and concentrate on the last exam early autumn, and maybe attend a training course for the last two exams to archive “MCSE: Business Intelligence” certification.


The last two exams, leading to “MCSE: Business Intelligence (Solution Expert)”:

I have enough work in front of me this year, but I like it 🙂

SQL Server migration: 30 servers and 700 DBs

This week should be the last full week for current project at work. This project for handling receipts using mobile clients. I have been responsible for the database modelling, implementing a JSON service as an interface for Android and Window Mobile clients. I have been learning a lot the last weeks, regarding new features like using ASP.NET Web API and Entity Framework Code-First.  I have used Windows Azure for deploying the database and Web API during the development phase. Next week we will deploy the solution in one of our data centers and prepare deployment of new clients to the customers.

Today, I started at on a new project at work. This is part of a project where EVRY shall provide a high-performance data center solution to customer. My part of the project will involve upgrading, migrating and cancellation of databases from the customer environment to EVRY database hotel solution in one of our data centers.  All the databases involved for my part will be SQL Server. The current customer solution involve not less than 30 database servers (SQL Server 2000, SQL Server 2005 and SQL Server 2008 (R2). The customer has over 700 databases, which is very large in Norwegian scale.

The first step is to categories all the databases in the current customer environment. One of the first we need to address is the circa 50 SQL Server 2000 database. Since the support for SQL Server 2000 will expire in April 2013, we need to determine which database we have to upgrade and which ones we should exclude from the migration process as a part of the data center solution.

In addition, there are about 300 SQL Server 2005 and circa 400 SQL Server 2008 (R2) databases.

The new customer environment at our data center will include a development, test, QA and production domains. I think this will be a very interesting project, and hopefully we have completed the migration before the summer holidays.

Cannot load the TERADATA and SQLPDW extension

I ran into alot of errors in the Event log for a customer on a relatively newly installed SQL Server 2012:

  • Report Server (MSSQLSERVER) cannot load the TERADATA extension
  •  Report Server (MSSQLSERVER) cannot load the SQLPDW extension.

The main reason for these errors are that the TERADATA and SQLPDW extension are registrated by default when installing Reporting Services. If you are not using these extensions, they can be safely removed from the Reporting service configuration file rsreportserver.config. This file is located on the server where Reporting services is installed.

%SQL Server Root%\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

Jan D’Hondt has a post on how to edit the configuration files to disable these extension with further explainations on the subject.