You’re offline. This is a read only version of the page.
Hi,
I'm trying to upgrade from MS-CRM 2015 (with the latest rullup) to MS-CRM 2016 and I'm getting this error message: "SQL Server Agent (MSSQLSERVER) (SQLSERVERAGENT) service is not running on the server PBC120."
My setup is (2 different servers):
1. server (PBC120) for iis & mscrm install (including ms crm deployment).
2. server (PBC121) for SQL Server & Email router.
I started setup and selected my organization to be updated (from the list).
On the "System Checks" stage I'm getting green sign for everything except the Microsoft SQL server agent.
I have a green "V" sign for "Microsoft Dynamics CRM Database".
On the log file I can see that the setup connected to my database on the PBC121 server:
19:27:40|Verbose| Connecting to database Data Source=PBC121;Initial Catalog=test_unit_MSCRM;Integrated Security=SSPI.
19:27:41| Info| Check SqlTableValidator: Success
19:27:41|Verbose| Connecting to database Data Source=PBC121;Initial Catalog=test_unit_MSCRM;Integrated Security=SSPI.
19:27:41| Info| Check SqlViewValidator: Success
But on the "SQL Server" check, setup is trying to find the agent on my pbc120 server and not on the pbc121 setup (the correct location for the sql server).
Here is the line from the log file
19:28:03| Error| Check SqlServerAgentValidator : Failure: SQL Server Agent (MSSQLSERVER) (SQLSERVERAGENT) service is not running on the server PBC120.
How can I force setup to check for the SQLSERVERAGENT service on PBC121 server?
Thanks,
Lior
*This post is locked for comments
I have the same question (0)
As per the prerequisites for MSCRM installation, the account used for the installation should have the sysadmin privilege on the assigned SQL Instance and also the account should be the added in the Local Administrator Group of the SQL Server on which the assigned SQL instances got hosted.
SQLAgent error will popup when the account is not a part of the administrator group of the SQL Server.
The causes of this error message are as follows:
• The user who is running Setup does not have local administrator permissions for the computer on which Microsoft SQL Server is running.
• The SQLSERVERAGENT service is not running on the specified computer where SQL Server is running.
Verify permission or start the SQLSERVERAGENT service
• Verify that you have local administrator permissions for the computer on which SQL Server is running, and if it is necessary, grant the necessary permissions.
• Verify the SQLSERVERAGENT service is running on the computer on which SQL Server is running. If the service is not running, start it.
Start the SQLSERVERAGENT service
1. Click Start, point to Administrative Tools, and then click Services.
2. Right-click SQL Server Agent (MSSQLSERVER), and then click Start
so:
add the installation user as local administrator on the SQL server
Installation user to have sysadmin system role on the database instance
Start SQL Agent on SQLserver
Share
Report
All responses (
Answers (
4
