Thursday, April 26, 2007

Deploy existing CRM DB to new DB Cluster

When you want to deploy your existing CRM databases to a new DB cluster ("Active/Active" or "Active/Passive") server you can get the following message "SQL Server Agent is not running" see figure 1.

You need to be sure that the account which has started the deployment manager is member of the group "domain admin" and "System Administrator" rights in Microsoft CRM.

If you use a user account on the application pool, the user has to be sysadmin on the sql server, otherwhise the user account network service (NT AUTHORITY) has to be sysadmin.

Figure 1: