Installation of SQL Express 2019 on Windows 11

Miquel Umbert Hugas 21 Reputation points
2021-11-11T07:34:34.66+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,449 questions
{count} votes

Accepted answer
  1. Erland Sommarskog 116.5K Reputation points MVP
    2021-11-11T21:55:25.14+00:00

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Miquel Umbert Hugas 21 Reputation points
    2021-11-11T21:58:36.497+00:00

    Thanks, I will do it in that way.
    Miquel

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.