• I had a similar problem while accessing SQL 2000. On the server I could login through IP but not through name. While trying many things I added a full stop (.) at the end of the name and it worked.

    Now I can login from remote machine using 'server_ name' but at the local computer machine I can login using 'server_name.' Perhaps length of the server name could be an issue as it was only four characters in length.