map servername to IP address

HI,
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
rickchan108Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
0
 
wingateslConnect With a Mentor Commented:
you want to edit the hosts file
c:\windows\system32\drivers\etc\hosts

and put a line int it that says

<IP ADDRESS>          <SERVERNAME>
0
 
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
0
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
0
 
rickchan108Author Commented:
hi cottsak,
could you please instruct me how to  allow remote connection for sql server. thanks
0
 
cottsakCommented:
aneeshattingal,

nice instructions ;)
0
 
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
0
 
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 )
0
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.