Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Not your usual "SQL Agent not running" installation problem

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?

  • Suggested answer
    Lyfey Profile Picture
    Lyfey 5 on at
    RE: Not your usual "SQL Agent not running" installation problem

    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.

  • Lyfey Profile Picture
    Lyfey 5 on at
    RE: Not your usual "SQL Agent not running" installation problem

    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.

  • edmunch Profile Picture
    edmunch on at
    RE: Not your usual "SQL Agent not running" installation problem

    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?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans