Hello,
i have 2 sql server each one on different domain with no trust between them.there’s ping between them but suddenly something happened and now they can’t see each others and from first site if i put the name of the second site it don’t login.
I brought the serevr from site2 to site1 network it worked but on the other site it doesn’t and eaven i can’t authenticate using IP plus on the nework no blocks for it but what i did is adding a DNS entering on site to allow the sql to authnticate and discover the name with IP but the problem still.
Please can someone help me could it be DNS or i need to create a trust between both domain?
Does sql server authenticate and replicate using only IPs but not servername?
IS there’s anyway to allow name solving between to domain without creating trust.