When I try to connect to SQL Server Express on another machine in the corporate network I face "Cannot generate SSPI context". My machine runs Windows XP and that machine runs Windows 2003 and I don't know much about how the network is structured and what equipment is used where.
I googled and found this article that describes some weird case that it calls "DNS Poisoning". I started
nslookup on my machine and results seem pretty much as described in the article:
>machinewithsqlserver Name: machienwithsqlserver.companyname.com Address: A.B.C.D >machinewithsqlserver Name: computer_1 Address: A.B.C.D
so there's some
computer_1 resolving into the same IP address and I guess that's the problem. Now how do I resolve it? How do I make local DNS server forget the extra entry?