We use sql authentication with sql 2000 databases. I can remote desktop to a server using either the name or IP address to find a server. I can also use query analyzer with either the servername or IP address and both connect directly to the database. I think my DNS is working.
When I try to add a server though using either the name or IP address, I get a connection error.
I have tried changing the connection properties from default to tcp/ip and named pipes but nothing connects. Any ideas?