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

Notifications

Announcements

No record found.

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
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans