SQL Server Error : 10009, Severity: 16. The provider did not give any informatio

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.