map servername to IP address

I have a server application installed on a windows 2003, with ms sql 2000 as database.At home, I want to connect to the server through vpn, but found that I can't find the sql server name .I found that it might help by doing the two steps at the bottom, but I am not familiar with this. so could someone please tell me how to do so. is there any other thing that might help? thank you

1)  make an entry in lmhosts file on the home PC that explicitly maps  servers name to the IP address

2) Use SQL Network utilities to create an alias that maps the servers name to the IP address
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
wingateslConnect With a Mentor Commented:
you want to edit the hosts file

and put a line int it that says

Aneesh RetnakaranDatabase AdministratorCommented:
> Using Client network utility

Open client network utility from "start -> programs -> MS Sql server " 
Click Alias tab -> add -> Select TCP/IP as the network library, IP address as the server name and the desired server name as the "server Alias"
Thats all
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

cottsakConnect With a Mentor Commented:
in addition to above, make sure the sql server is allowing Remote Connections as this might hold u up if Management Studio (or another connection) refuses u entry
rickchan108Author Commented:
hi cottsak,
could you please instruct me how to  allow remote connection for sql server. thanks

nice instructions ;)
rickchan108Author Commented:
hi aneeshattingal,
this is a very clear demonstration for sql 2005. however, as I am still running sql 2000, I found it difficult to follow.  would you mind telling how to set it in sql 2000. thank you very much
Aneesh RetnakaranDatabase AdministratorCommented:
> would you mind telling how to set it in sql 2000.

You don't have to change any settings for SQL 2000. In case you have firewall installed on your remote server, you just need to open the ports which are used by SQL (by default 1433&1434 )
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.