I'm trying to remote connect to my Sql server 2016 instance on my home server running on a workgroup. I need to set an SPN to do this. All the guides out there seem to be related to setting the SPN for domain situations, not workgroups. Here is the SPN that I have tried for server Odin running under NT SERVICE\MSSQLSERVER (the default service account)
C:\Windows\system32>setspn -A MSSQLSvc/Odin:1433 "NT SERVICE\MSSQLSERVER" Ldap Error(0x51 -- Server Down): ldap_connect Failed to retrieve DN for domain "" : 0x00000051 Warning: No valid targets specified, reverting to current domain. FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0x000004BC Unable to locate account MSSQLSERVER
I am running the cmd prompt as admin, I'm logged in as admin and now out of ideas. The account MSSQLSERVER must exist otherwise SQL server would not be running (I can connect locally).