Windows 10: "the target principal name is incorrect". when connecting to SQL Server

We have configured our organization's Windows 2022 Domain Controller and have been attempting to run windows updates which are mentioned below. However, we have encountered a Kerberos authentication issue that has prevented the authentication of the users and MS SQL, as mentioned below.SQL Server 2019 version sp1 We would greatly appreciate any assistance you can provide in resolving this issue. Thank you in advance for your help.

:)

 

The server you are connected to is using a certificate that can not be verified. The target principal name is incorrect. View certificate. etc.

I get the following message and don't understand what it means or how I can correct it. I need help!

"The server you are connected to is using a certificate that can not be verified. The target principal name is incorrect. View certificate. Do you want to continue using this server? Yes No"

 

Released: Microsoft Kerberos Configuration Manager for SQL Server v3.1

Source: Released: Microsoft Kerberos Configuration Manager for SQL Server v3.1 | SQL Server Release Services

 

connecting to SQL SERVER

TITLE: Connect to Server

------------------------------

Cannot connect to (local).

------------------------------

ADDITIONAL INFORMATION:

I'm first time user to SQL Server



While connecting to SQL server I just gave Server name as (local) & trying to click connect but it display this message.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

------------------------------

The system cannot find the file specified

------------------------------

BUTTONS:

OK

------------------------------