I'm trying to start SQL server Agent on windows 10, I'm getting following error. - SQL server Agent have installed with SQL express - custom installation
Following things which I tried to resolve this issue with no luck. :(
- Change Built in account to Local system - didn't work.
- Tried to use Network service account didn't work.
- I have uninstalled the SQL server stand alone and reinstalled it. - Didn't work.
- Tried to run the services from Services.msc - didn't work
I see SQL server and SQL server browser services running without any issues. But I cannot start sql server agent.
First, SQL Agent doesn't come with SQLExpress. Been that say what say on the event logs of windows? Can you post that information here?
How do you manage to install the agent?
I suggest if you are using SQL Express, you use some other tool to simulate the agent (I have done this with Jenkins, Ansible and Task Scheduler with some PowerShell/batch scripts)