How to connect SQL Server 2000?

i want to connect SQL Server 2000 with remotely how it will work?

i have a sql server data base on server(domain) in xyz company, they give me following information:

database name

server IP address

database user name

database password

i can connect the same database using networking internet (proxy)

connect internet connection

start proxy connection

i am using a pc from network which is useing proxy for internet.

i open query analyzer

enter IP address, user name and password (which is currect)

though i can't connect sql server

else i can connect the same server which PC is using own internet connection not form network

i want to know that

how can we connect SQL Server using internet connection form network (proxy server)?

where is to enter networ pc IP address?

where is to enter port number?

Hi,

Just a bit of advice. That is a bad practice actually.You'll attract all the hackers in the world to get in to your box. That would force you to open port 1433 in your firewall to everyone else ... with out that port open you won't be able to connect to the server.

that is like saying. "hello world, we've got a 1433 port open "

if your pulling and pushing data to the server

how about using web services instead also

sql server 2000 has builtin support for IIS querries . i just forget the actual name.

just look for it in your start>programs>microsoft sql server 2000 then

look for something there with IIS.

for remote admin administration over the internet i'll strongly recommend this tool

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

http://www.microsoft.com/downloads/details.aspx?familyid=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en

regards,

joey

|||

Hi,r

I would suggest to refer below KBs for Proxy Configuration

http://www.support.microsoft.com/kb/890775

http://support.microsoft.com/kb/216415

and as stated it is not a best practice refer www.sqlsecurity.com 's checklist for securing sql server , i suggest to configure port nomber other then default and set appropriate firewall rules.

Regards

Hemantgiri S. Goswami