After doing a database move for Microsoft CRM 4 to a separate server we were experiencing issues with the CRM Asynchronous Service which is responsible for processing asynchronous jobs like the workflows. The cause for the issue was the service dependency on MSSQLSERVER. To resolve the issue I had to perform the following registry change to remove the dependency.
- Run the “regedit” command to open the Registry Editor
- Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSCRMAsyncService
- Delete the Value (MSSQLSERVER) for the “DependOnService” Name
- Restart the server
The service should come up running after the restart.