Solved

Why i am getting SQL Agent error.

Posted on 2014-12-11
8
381 Views
Last Modified: 2014-12-25
Dear EE,

In my SQL Server i am getting below information in EVENT ID. Please see attached picture.

There are two types of information.
SQL SERVER AGENT :-
The description for Event ID 53 from source SQLSERVERAGENT cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
[sqagtres] CheckServiceAlive: returning TRUE (success)


MSSQLSERVER
The description for Event ID 18454 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
AGRALAPP
 [CLIENT: 130.0.14.100]


I received information from client that there is a network issue from CLIENT TO DB SERVER.

Thanks
EE-Error.jpg
0
Comment
Question by:Netsol-NOS
  • 5
  • 3
8 Comments
 
LVL 27

Accepted Solution

by:
Dan McFadden earned 500 total points
ID: 40493602
This seems to indicate that the SQL Agent cannot contact or connect with the database.  If you received information from your client that there is a potential network issue between the client and server, then this is the reason for the event log entries.

Dan
0
 

Author Comment

by:Netsol-NOS
ID: 40493611
Hi Dan ,

Thank you for your quick reply.

Please see that why it is not showing any network disconnectivity or you can say why log are not reporting any NETWORK issue.

Even in Client machine or in DB Server machine.

Thanks
0
 

Author Comment

by:Netsol-NOS
ID: 40493616
Client Logs has nothing with respect to DB side i think it is not complete logs.

The only information i am getting is from DB Server side.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 27

Expert Comment

by:Dan McFadden
ID: 40493618
Event ID 18454 references logon audit events.  I would verify that the username and password for the account that is being used to connect to the database, is correct.

- Can you ping the database server from the client server?
- can you connect to the database using SQL Server Management Studio?

Dan
0
 

Author Comment

by:Netsol-NOS
ID: 40493633
All is going well right now.
0
 

Author Comment

by:Netsol-NOS
ID: 40493645
Issue is we need to find out why this happends.
0
 
LVL 27

Expert Comment

by:Dan McFadden
ID: 40493657
Then you need to post more information:

- what version of OS on the client
- what version of OS on the server
- what version of SQL drivers on client
- what version of SQL Server on server
- how are the computers connected?  on internal network, same subnet?  over a routed network thru the internet?
- how is the SQL Server Agent configured for authentication?  does it use a service account or SYSTEM, etc.
- what time did these errors occur?
- what events are in the SQL Server logs?
- what additional entries are in the event logs at this time?
- post the contents on the entries in from the events above
- can you manually connect to the SQL Server using the credentials of the SQL Server Agent?

Event ID 53 indicates that the SQL Server Agent is in a failed state.
Event ID 18454 indicates that there was a login issue on the sql server.
0
 

Author Closing Comment

by:Netsol-NOS
ID: 40517502
We have forwarded the case to Network team and they have resolved the issue .

As the client machine is not communicating with DB Server.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question