I have several computers (XP) connected to domain controller (2008R2). Last time I had to change IP address of the SQL Server 2008 R2 (simple instance, no clustering or replication). DNS has been updated and on all computers everything work great. On all computers...but one. The one computer behaves strange - I can connect to SQL Server only if I put the IP address. Using the name I get an error "SQL Server does not exist or access denied".
I checked things from troubleshouting:
- the name is resolved correctly when pinging (and ping is ok)
- connection is established when telneting
- nslookup works in both directions (ptr record set)
- \\servername works without problem
I tried releasing and renewing IP, dns flushing, restarting but with no success.
Server configuration should be ok because other computers work great and before IP change it was ok. Maybe SQL client is caching something? Do you have any ideas? Please help