SQL server 2000 ( domain problem)
Let me explain my problem :- I Installed Sql2000 ( enterprise edition ) server on my machine since my machines name is "MyComp" so while installing the sql server showed me "MyComp" and I installed my sql server with that name . so now when I run my sql server on the machine I am able tp connect to sql server from asp script or Enterprise Manager using just the "MyComp" to connect via TCP/IP and it does connect fine , it even connects through 127.0.0.1 ( local Ip ) .
But my problem is that I want to connect to sql server with the domain "MyComp.com" ( not just "Mycomp" ) . The domain "MyComp.com" works fine one the same machine I can ping it and even get my website on the same machine from IIS but problem is i cant connect to sql via TCP/IP using the domain "Mycomp.COM" it works if i only use "MyComp" by removing the ".com" from host name . The domain can be pinged from the same machine and DNS is also all fine domain cant be reached from same machine and even from remote machines by ping or by http to load a website but same domain does not connect to sql server even from the same machine .
Now I have to use the domain also because some remote machines have to connect using domain . I would really really appreciate if some one can help me to solve this problem .
