SQL Can connect by server name but not by instance name

Question

I just install SQL 2017 in two servers with default options. I also have configured the cluster role in both servers and activated the Allways On option.

Testing the enviroment before beging creating datasbase, i try to connect with SQL Management console to instance default name (select @@servicename is correct > MSSQLSERVER) and i cant connect. But i can connect with server name and cluster name in both servers.

I tried:

SERVERNAME\MSSQLSERVER

MSSQLSERVER

Why cant i connect to instance name?

Thanks, Regards

Ensure your SQL Server instance name has a registered service principal name (SPN) for Kerberos authentication. See this — leeharvey1, Jun 24 '22 at 10:48
just a blind stab, but you have to enable TCP connections for each instance and restart it, if you haven't already. — Frank Thomas, Jun 24 '22 at 19:26
SQL server browser is already runnig and TCP is also enable. Im checking the SPN Automatic SPN Registration. Thanks to all. — RAN55, Jun 27 '22 at 07:07

score 0 · Answer 1 · edited Jun 27 '22 at 08:58

0

setspn -L domain\sqlserver

enter image description here

Should the instance name appear?

Besides, should i must change the default instance name MSSQLSERVER to another more appropriate before proceeding with the rest of the configuration ?

edited Jun 27 '22 at 08:58

Toto

17,839

answered Jun 27 '22 at 08:02

RAN55

53

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center. – Community Jun 27 '22 at 08:14

SQL Can connect by server name but not by instance name

1 Answers1