Solved

Why i am getting SQL Agent error.

Posted on 2014-12-11
8
318 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 26

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
 
LVL 26

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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 26

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now