UNC Path no longer works with 2 servers with the same IP address.
Posted on 2011-09-30
This is on a 2 Windows 2008 (non) R2 servers test environment. Both servers are SQL servers and also have files shares.
TEST01 10.0.0.1 (Master)
TEST01DR 10.0.0.2 (Replica)
We replicate data between the 2 servers and when we need to failover to the DR server we change all the DNS (A) records in all of our DNS servers so that both IP addressess match. So it looks like below
Now when users type in TEST01 they are actually accessing TEST01DR through DNS
This works great for all the applications that are writing to the SQL server since they are using DNS to connect. Now the issue we are having is files shares. The data is replicated but once we make the DNS record change where both servers have the same IP, and try to access \\TEST01\ we get Logon Failure: The target account name is incorrect. This is only for the file shares. I tried DisableStrictNameChecking and rebooting. That didn't work. Im sure the server is denying me access because Im using a different host name to try to access it. If I do \\10.0.0.2\ I can access the file shares. And if I try to access TEST01DR by its actual host name, \\TEST01DR....that works. I just cant access it by \\TEST01\ even though DNS points TEST01 to TEST01DR. Any tips or tricks? I hope all this makes sense. Also as a side note, neither servers registers their IP addressess to the DNS server. The 2 servers are setup static in DNS.