Error connecting to SQL Server in SCCM

Question

I want to use SQL queries for SCCM, but I encounter an error when connecting to the server in SQL Server Management Studio. The message says, "A connection was successfully established with the server, but then an error occurred during the login process. The target principal name is incorrect."

I am using the Server type as Database Engine and Authentication as Windows Authentication.

Answer 1

Hi, @golden alick

Thank you for posting in Microsoft Q&A forum.

How do you specify the server name? Try to specify the FQDN of the server name instead of just a host name.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Answer 2

Which version of SSMS are you using? It may help to check the option "Trust server certificate" as in the example below. (But I believe that there are more possible reasons for this error, so it may not help.)

If you are using an older version of SSMS, you find this checkbox on the Connection Properties tab.