Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
Does the pc have IP 6 enabled? –  benni_mac_b Apr 30 '13 at 11:00
    
@benni_mac_b No, it doesn't –  user1121956 Apr 30 '13 at 11:04
    
Is there a SQL alias configured in the client settings on the affected machine? –  Chris McKeown Apr 30 '13 at 12:07
    
@CMcKeown OMG, you are right! Aliases where the problem! Thank you a lot. Please add the answer, I will mark it as the correct answer. Btw. it is interesting who and why set it (espacially where was no SQL Configuration Manager installed before) –  user1121956 Apr 30 '13 at 13:19

1 Answer 1

up vote 1 down vote accepted

Check that there isn't a SQL Alias present in the machine's SQL Client configuration for the remote server name.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.