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 two Win 2k3 SP2 servers running where one is a web server and the other is a SQL 2000 server. We changed the IPs of these servers earlier today and now we cannot connect to SQL using the NetBIOS name. We can connect just fine using IP or fully qualified domain name.

Unfortunately I cannot change the name we use to connect to the server right now, so we are stuck trying to fix the NetBIOS name. I have tried clearing everything with nbtstat -RR, I verified things are correct in the lmhosts file, and that the right IP comes back when pinging the server. My thought is that the port for SQL is blocked when using NetBIOS, but I don't know if that is even possible. We can use the NetBIOS name to connect to the server using a shared drive like \server\drive$. That is what leads me down the port idea.

Any ideas on what I could check next?

share|improve this question
    
Just check the error logs inside SQL Server for any Logging denied error. The errors thrown on the client side are somewhat cryptic due to secuirty reasons. However SQL Server logs al failed login attempts. –  Ganesh R. Apr 6 '11 at 17:37
    
Can you connect via IP address? –  Jason Axelson Apr 6 '11 at 18:05
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.