Running SQL and CRM on the same Server

I haven't seen this problem for a while (mainly because Version 1.2 is out), but I came across it again, so here is the solution.
If you have installed Microsoft CRM on the same server as Microsoft SQL Server, it's possible that the Microsoft CRM Security Service will fail when the service is started. The service will start without issue when it is started manually. (This shouldn't be an issue in Microsoft CRM 1.2 because in version 1.2, the server setup will detect this problem and correct it for you.)
The fix for this issues is to make the Microsoft CRM Security Service dependant on the service for SQL Server. This will wait for the SQL Service to start before the service attempts to start itself.
This is how your can register the Microsoft CRM Security Service and make it dependent on the SQL Server Service (MSSQLSERVER).

• Log on to your Microsoft CRM server as a domain administrator.
• Click Start, and then click Run. In the Open box, type cmd. Then press ENTER.
• Type cd Program Files\Microsoft CRM\server\bin, and then press ENTER.
• Type CrmSecurityService –r –s, and then press ENTER. After completing the previous steps, follow these steps to restart the Microsoft CRM Security Service: Click Start, point to Control Panel, point to Administrative Tools, and then click Services.
• Under Services, right-click Microsoft CRM Security Service, and then click Start

You should now be able to restart the Server and the CRM Service will start after the SQL Service has finished starting.