SQL Server Agent doesn't turn on after upgrading from SQL EXPRESS to SQL Standard

Question

I upgrade the SQL 2014 Express to a Standard edition without changing the instance name. There was a success and it seems to be working fine, except the SQL AGENT.

Error message from configuration manager:

The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs details.

Trying with the server administrator user. Built in account/Local service also don't work.

Event log doesn't show anything except that it's turned on and then off.

This is what I see in DETAILS. doesn't tell me anything:

• Provider

  [ Name] SQLAgent$SQLEXPRESS

  • EventID 102

  [ Qualifiers] 16384 Level 4 Task 2 Keywords 0x80000000000000

Trying to run it from CMD with admin rights:

StartServiceCtrlDispatcher failed (error 0).

Read somewhere to try to turn off VIA protocol. I don't have any protocol called VIA.

Any ideas?

Thanks

Answer 1

I know this is late, but I hope it helps someone in the future; a fix that has worked for me after an upgrade from Express to Standard was to run the Repair option (see image) from the Maintenance node of the SQL Server Installation Center. Once the repair completes & restart finishes, Agent works as expected.

Use Repair option from the Maintenance page of the SQL Server Installation Center

Answer 2

Just after I posted I checked the security and found out that the BUILTIN\USERS didn't have sysadmin permission..

After adding it, it was resolved!