Jump to content

SQL Server Agent (ERASQL) Can Not starting


hungtt
 Share

Recommended Posts

Hi all,

I'm using ERA 6.5, when I check sql service, I see "SQL Server Agent (ERASQL) stop", I tried start it on services.msc but it fail.

Please help me check this.

Thanks.

 

1.jpg

2.jpg

3.jpg

Link to comment
Share on other sites

  • ESET Staff

Primary DB services is SQL Server (ERASQL) which seems to be running, SQL Server Agent is not supposed to be running permanently but rather it is started when required directly by DB.

In case you have problems with ERA startup after upgrade to 6.5, check SERVER's trace log for startup issues.

Link to comment
Share on other sites

Hi MartinK,

I checked on  ERA 6.4 is same issue.

SQL Server (ERASQL) is mean ? Because when I check service, ERA server is normal.

Link to comment
Share on other sites

  • ESET Staff

I am not sure I understand correctly - is there any problem with ERA?

Service named "SQL Server (ERASQL)" is where ERA is connecting and where data is stored. This is service that has to be running so that ERA can work properly.

Service named "SQL Server Agent (ERASQL)" is helper service that is started only to perform specific automated task (see MS documentation) and it is normal that it is not running for most of the time.

Link to comment
Share on other sites

@hungtt @MartinK

Hungtt - I think Martin tries to tell you "SQL Server Agent" is not suppose to be in "running" state all the time. only when "SQL Server" requires it will be running. so don't worry about it.

IF "SQL Server" is not running, it would be a problem, because all the database is working through this process.

Hope this clears this one out.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...