CRM 2011 Setup failed ‘SQLAgent service is not running on the server’

Issue:

While installing CRM 5.0, getting the following error “Error: SQLAgent service is not running on the server.”

Fix:

The CRM setup account was not part of local administrator group on SQL server and the Port number 445 was blocked in Internal Firewall.

Additional Information:

1. Minimum Permission for CRM Setup:

Minimum permissions that are required by the user account for Microsoft Dynamics CRM services and components.

Microsoft Dynamics CRM Server Setup

The user account used to run Microsoft Dynamics CRM Server Setup that includes the creation of databases requires the following minimum permissions:

• Be a member of the Active Directory Domain Users group. By default, Active Directory Users and Computers adds new users to the Domain Users group.

• Be a member of the Administrators group on the local computer where Setup is running.

• Have Local Program Files folder read and write permission.

• Be a member of the Administrators group on the local computer where the instance of SQL Server is located that will be used to store the Microsoft Dynamics CRM databases.

• Have sysadmin membership on the instance of SQL Server that will be used to store the Microsoft Dynamics CRM databases.

• Have organization and security group creation permission in Active Directory. Alternatively, you can use a Setup XML configuration file to install Microsoft Dynamics CRM Server 2011 when security groups have already been created. For more information, see Use the Command Prompt to Install Microsoft Dynamics CRM in the Installing Guide.

• If Microsoft SQL Server Reporting Services is installed on a different server, you must add the Content Manager role at the root level for the installing user account. You must also add the System Administrator Role at the site-wide level for the installing user account.

2. Network Ports to be opened:

On SQL Server:

On CRM Server:

Cheers!

Bala