web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Not your usual "SQL Agent not running" installation problem

(0) ShareShare
ReportReport
Posted on by 5

Hi all,

I've got an unusual installation problem that maybe someone can help me with. A fresh install of CRM 2016 from the Visual Studio iso onto fresh machines, installed from the command line with a configuration XML. This also applies to a GUI install as well, by the way.

For reference, the SQL servers will be called "SQL", the SSRS one "Reporting" and two load-balanced front end servers will be called "NODE1" and "NODE2".

Installing from NODE1, with SQL and Reporting defined in either the XML or GUI, while doing the preinstallation validation steps, I get the error:

"SQL Server Agent (MSSQLSERVER)(SQLSERVERAGENT) service is not running on the server Node1"

Checking the installation logs:

06:49:38|   Info| OrganizationInfo.BaseCurrencySymbol: $
06:49:38|   Info| OrganizationInfo.OperationTypeProperty: None
06:49:38|   Info| OrganizationInfo.OrganizationCollation: Latin1_General_CI_AS
06:49:38|   Info| OrganizationInfo.OrganizationFriendlyName: DelMe
06:49:38|   Info| OrganizationInfo.OrganizationUniqueName: DelMe
06:49:38|   Info| OrganizationInfo.ReportingUrl: https://reporting/ReportServer
06:49:38|   Info| OrganizationInfo.SqlServerInstanceName: MSSQLSERVER
06:49:38|   Info| OrganizationInfo.SqlServerMachineName: SQL
06:49:38|   Info| OrganizationInfo.SqlServerName: SQL
06:49:38|   Info| OrganizationInfo.SqlServerNameObject: Microsoft.Crm.Setup.Server.Utility.SqlServerNames
06:49:38|   Info| ProductInfo.InstallingLanguage: 1033

And yet, I also see the error:

06:49:40|   Info| Check W3svcServiceValidator: Success
06:49:40|   Info| Check NTAuthenticationProvidersValidator: Success
06:49:40|   Info| Group Microsoft SQL Server
06:49:40|  Error| Check SqlServerAgentValidator : Failure: SQL Server Agent (MSSQLSERVER) (SQLSERVERAGENT) service is not running on the server NODE2.
06:49:40|   Info| Group Active Directory®
06:49:40|   Info| Check DomainUserValidator: Success
06:49:40|   Info| Check SandboxServiceSettingServicePrincipalNameValidator: Skipped
06:49:40|   Info| Check AsyncServiceSettingServicePrincipalNameValidator: Skipped

I've tried a GUI installation, as well as command line XML. I normally use c-name DNS records for the SQL and Reporting server, but I've also tried direct a-records. This occurs on both the new servers, which have no relation, other than copying the same source files. I'm in the process of downloading more media, but I've used this media successfully in the past.

This is a new one for me - any ideas?

I have the same question (0)
  • edmunch Profile Picture
    Microsoft Employee on at

    Does the account you are using for performing the setup have the proper permission on the SQL Servers?  Also, have you checked that you have the proper ports open on the front end servers?

  • Lyfey Profile Picture
    5 on at

    Thanks for the reply Efrain. The issue is not related to permissions or networking. The CRM server is looking at --itself-- for the SQL agent, not the SQL server. This is why its an unusual problem.

  • Suggested answer
    Lyfey Profile Picture
    5 on at

    If you're reading this with the same issue, I resolved it eventually, using a combination of a few days break and a complete set of server restarts. It may or may not have been related to some AD Domain Controller connectivity issues - that's about the only thing I can put it down to.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 180 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 119

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans