sql server connect: Connecting to DB with Static IP over the internet -- sql server connect

Connecting to DB with Static IP over the internet

ARTMIC
5/29/2006 6:55:01 PM

sql server connect:

Hello Did anyone ever get the SQL2000 server or MSDE to work on an XP Pro
computer, with a static IP address? If so how is this done? Iâ€™ve done the
following:

1) setup router to forward to a port 5000
2) I setup MS SQL server to listen to this port, I check error logs, and it
is listening, I do netstat â€“a and it does list that it is being listened to.
3) I make sure the DMZ is clear for the computer that is being forward the
stuff from the internet.
4) I can use the Remote Desktop Connection to connect to that static IP
computer and it works just fine, â€¦
5) When I try to connect to the computer through a connection string I get
the oh so informative â€œInvalid connection string attributeâ€ even though I use
the same thing with another static ip, on a win2000 server, and it works the
connection string looks like this:
User ID=DAN;Password=DAN;Protocol=TCP/IP;Server=60.44.118.127;Port No=5000;
6) I did setup the server network utility with the port,

I am not sure what I missed, I know on the Server2000 operating system I
did go into the remote access routing utility, but I canâ€™t find that on
Windows XP Pro,

Can anyone help me out?

Re: Connecting to DB with Static IP over the internet

John Smith
7/26/2006 4:36:47 PM

[quoted text, click to view]

Try equating the IP number to a name in hosts and then use that name in the
connection string.