Getting Windows authentication to work in a workgroup is difficult. It usually works, if you have the same username and password on the two machines, but beyond that, you are better off with SQL authentication.
Installation of SQL Express 2019 on Windows 11
I have done an installation of SQL Express (English version) on a Windows 11 profesional (Spanish version). SQL Express was the first program that I installed in the laptop. The problem is: I can open the Databases from another computer different of the one that I installed SQL Server Express. I get the following error:
The target principal name is incorrect. Cannot generate SSPI context (Microsoft SQL Server).
In the events viewer I can find this information (I think related to this problem): The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/MIQUEL7390:1433 ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. Alguien pude ayudarme. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
I try to install SPN manually registered, but I can,'t.
Can anybody help me.
Thanks
Miquel
1 additional answer
Sort by: Most helpful
-
Miquel Umbert Hugas 21 Reputation points
2021-11-11T21:58:36.497+00:00 Thanks, I will do it in that way.
Miquel