On one of our client server, Windows Server 2008 R2 is installed. On the same machine, on SQL Server 2012, I am seeing 2 server names MHMSDB01 and user_DB1 are actually same server (IP address.) host name is MHMSDB01.
But I have access to MHMSDB01 through Windows authentication but do not have on the other. It gives error that
Login from untrusted domain. I want to know how this setup is done. I checked alias option in SQL Server Configuration Manager but I could not see any alias there. I checked cliconfig.exe but could not find any alias name there as well.
I ran nslookup command for MHMSDB01 and user_db1 and both returned same IP address and DNS name as MHMSDB01.xyz.com. I am new to this area. I want to know the relation between them and how they have been setup. Please ask me further questions know if I have not given sufficient information.