Table of Contents
SQL Server Error : 10009 Details
SQL Server Error: 10009
Severity: 16
Event Logged or not: No
Description:
The provider did not give any information about the error.
Severity 16 Description:
Indicates general errors that can be corrected by the user.
The Event ID 10009 indicates that RPC system service on local machine couldn’t reach the RPC system service of target server. There could be various possibilities cause this Event error.
Reading sql server error log location from SQL Query
Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.
USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go
For other ways to read and find error log location please our artcile https://sqlserver-dba.co.uk/error-log/sql-server-identify-location-of-the-sql-server-error-log-file.html
Solution for Resolving the Error
The forwarder IP (in your case, Google’s DNS servers) looks to have been configured as a DNS address on an interface at some point. However, if you don’t see it right now and don’t see it in DNS (A records, LdapIpAddress, GcIpAddress, NS records, etc), you should be fine. Check out this website for more information about the source. I recommend looking at this link for a step-by-step guide to checking the Component Services configuration:
http://www.eventid.net/display-eventid-10009-source-DCOM-eventno-579-phase-1.htm
SQL Server Error Code and solution summary
SQL Server Error: 10009
Severity: 16
Event Logged or not: No
Description:
The provider did not give any information about the error.