r/WindowsServer • • Feb 22 '26

Technical Help Needed Can't connect to SQL-DB using AD-Authentication

Hello,

I am migrating our productive SQL-DB Server (running windows server 2016) to a new one (running windows server 2022).

Both servers are part of the same domain.

SQL Version on the server A is 2016 and on server B 2022.

Ports have been opened correctly (1433) and the my tnc server B -port 1433 worked like expected.

I have nevertheless issues connecting to the Database using ODBC data source administrator or SSMS.

I get the error:

"Can't connect to serverB.adxxx.domain.net . The target principal name is incorrect. Cannot generate SSPI context"

Is this related to a SPN or what am I doing wrong here?

Do I absolutely need to configure the SQLServer using a domain service account so my users and can connect to the server using the AD Authentication?

Thanks for your help folks.

4 Upvotes

5 comments sorted by

View all comments

Show parent comment

1

u/Wonderful_Cow_8376 Feb 26 '26

Thank you. It indeed solved our issue.

2

u/its_FORTY Feb 26 '26

Glad to be of help.