Solved

Why i am getting SQL Agent error.

Posted on 2014-12-11
8
405 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 28

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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 28

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 28

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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need multiple Group By's 8 55
Recover from a ISCSI Share In Windows 2 68
Any benefit to adding a Clustered index here? 4 40
T-SQL: need to reset a declared variable 4 33
In this article I will describe the Backup & Restore 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.
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.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…

752 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