up vote 0 down vote favorite
share [g+] share [fb]

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?

link|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? – Bostonvaulter Apr 6 '11 at 18:05
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.