sql server2019 cannot log in using Computer name in diffrent machine

Question

There are two machines in LAN,Both have installed sqlserver service.
All The sqlserver instance name is default.
Now, They can login in each other using IP,But can not login in using Computer name. why?

Answer 1

Hi HuiSky,

The DNS name you are using to connect to the server may not be resolving to the IP hosting the instance. You can check this by using nslookup to resolve the name and verify this resolves to the instance IP address you have configured on the SQL server. Refer to this blog to get more information about DNS.

If this is still not work, please check that there isn't a SQL Alias present in the machine's SQL Client configuration for the remote server name.

If the response helped, do "Accept Answer" and upvote it.

Best regards,
Cathy

Answer 2

Sounds like DNS configuration issues. I'd check that these two member servers, problem client and the domain controller all have the static ip address of DC listed for DNS and no others such as router or public DNS.

--please don't forget to Accept as answer if the reply is helpful--