• Biztalk taught me, not to put more than 65000 files in one folder
• Microsoft CRM taught me not to do more than 1024 joins in one select statement (if you're working with SQL 2005 and newer)
• Ibatis taught me not to use more than 2100 parameter in a sql command
• Some stupid code taught me not to select 50000 rows and store them in session

Recently I moved my Microsoft CRM installation to a new server. This showed to be surprisingly easy. However I had a some time consuming problems, configuring the outlook client afterwards. When trying to connect to the server through the Configuration Wizard I'd get an errormessage The request failed with HTTP status 401: Unauthorized.

Accept this error, and a new message pops up: Mandatory updates for Microsoft Dynamics CRM could not be applied successfully. Try running the application again. 

The first message indicates that some authentication settings was messed up. Doing a lot of googling gave so many suggestions on how to solve this. Add the website to intranet zone in internet explorer, install Internet Facing Deployment tool (IFD Tool) and lots of other stuff, but nothing helped me.

Spending a lot of time on this getting nowhere, I decided to move on to the second error that indicated that there could be some update for the Outlook Client. And there is, you can get it here: rollup 7

Installing this made both errors go away, but of course a new error popped up. This time a big messy messagebox containing a lot of xml, claims that a wrong name for the server, has been entered in the Configuration Database. In the MSCRM_Config i found a table called Server that has a column Name that contained the name of the old server. When this value was changed to the name of the new server, everything worked.