Re: Connecting to DB with Static IP over the internet
- From: ARTMIC <ARTMIC@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 May 2006 16:10:02 -0700
i figured it out, i was so into the sql part that i forgot to disable dhcp,
in other words the damn internal ip address changed on my computer every time
i rebooted and that is why i couldn't connect, i filled in the DSN, and
internal computer iP and made sure on the router to use that internal
computer ip as the place to forward teh port and dmz stuff to.
I was getting mental over this because the settings on the sql server i did
ok, and it didn't dawn on me that if i use DHCP the ip of the computer
changes so even though i have a static IP, and i forward the port / DMZ stuff
the ip would have changed on me while i rebooted :) duh for me, pass the
doughnuts lol
the only thing i'm wondering is do i need DMZ enabled for that internal ip?
I was trying to connect from the outside of htat one computer/static ip /
router combo from a different computer , i tried to connect to the sql on
that computer directly with the login and the internal ip and it worked just
fine, but when i tried using the static ip from the outside world that is
when i ran into trouble (DHCP it is evil :) )
"Keith Kratochvil" wrote:
By the way, are you trying to connect from outside of your network, or are.
you starting simple and connecting from inside your network first?
--
Keith Kratochvil
"ARTMIC" <ARTMIC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:706CAF00-C903-4CA7-B145-D53E4A73B378@xxxxxxxxxxxxxxxx
well the Protocol= connection string works on the windows server 2000 OS
with static ip just well, but not on the Windows XP Pro machine.
i tried to do the following 2 methods for connecting:
DOES NOT WORK
Provider=sqloledb;Data Source=10.14.118.151,5555;Network
Library=DBMSSOCN;Initial Catalog=gtt;User ID=dan;Password=dan;
DOES NOT WORK
Data Source=10.14.118.151,5555;Network Library=DBMSSOCN;Initial
Catalog=gtt;User ID=dan;Password=dan;
the weird part is that it now gives me this error message:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied
I don't understand, the sql server is running and listening to the port,
and
i have created the dan account to access the database on the sql server
side
"Keith Kratochvil" wrote:
I don't think that you can specify PROTOCOL= like you did within the
connection string.
Head over to
http://www.connectionstrings.com/
and expand the "Read more" baloon under SQL Server.
You will see that you should use Network Library=DBMSSOCN
I think that I remember reading somewhere that this param should be the
last
item on the connection string.
--
Keith Kratochvil
"ARTMIC" <ARTMIC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8796C1F4-8A1A-4390-B2E2-63FE54A5DE4B@xxxxxxxxxxxxxxxx
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?
- Next by Date: Re: Connecting to DB with Static IP over the internet
- Next by thread: Re: Connecting to DB with Static IP over the internet
- Index(es):
Relevant Pages
|
