I have a server that has three instances installed and in all three when trying to open the SQL Error Log we get the following:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
I am getting the following error in the Windows Application log
The description for event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises the is event is not installed on your local computer or the installation is corrupt. 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
Severity: 16 Error: -2146893022, OS: -2146893022 [Microsoft][SQL Server Native Client 11.0]SSL Provider: The target principal name is incorrect
When trying to use exec xp_readerrorlog I get the following error
Failed to open loopback connection. Please see event log for more information
error log location not found
I have tried the following with No luck
-Executing a SQL Server Repair did not work - even a new instance installed on the same server does not work
-did NOT want to create the disableloopback entry in the registry so I did not do this
-Registry settings for the error log location is fine
-I added the virtual SQL Service account for the SQL Server Agent with full control of the program file folder where the log folder is and restarted the instance and - no luck
-I checked C:\WINDOWS\system32\drivers\etc\hosts and made sure 127.0.0.1 localhost server_name was there.
-I tried to turn off network encryption and no luck
-I tried to install ODBC Driver 13 and no luck
To me it does not seem like an SQL Issue because all three instances are doing the same thing. Its seams to me a server permission or setting.
Any help is appreciated.