I'm having an issue when I'm trying connect to one of my mssql server using Microsoft.EntityFrameworkCore.SqlServer on .net core 3.1.
In application log I can see 'Server not found in Kerberos database' but when I'm connecting to other server everything is fine.
What did I notice is that a server when connection is established has registered servicePrincipalName where CN=database_server_name. The second one where I have an error has SPN registered on sql user so the AD record starts with CN=sqluser.
I think this Package should searching in AD on registered principal names and not only searching where CN=database_server_name and then looking for their SPN.
I'm having an issue when I'm trying connect to one of my mssql server using Microsoft.EntityFrameworkCore.SqlServer on .net core 3.1.
In application log I can see 'Server not found in Kerberos database' but when I'm connecting to other server everything is fine.
What did I notice is that a server when connection is established has registered servicePrincipalName where CN=database_server_name. The second one where I have an error has SPN registered on sql user so the AD record starts with CN=sqluser.
I think this Package should searching in AD on registered principal names and not only searching where CN=database_server_name and then looking for their SPN.