Re: Connecting to DB with Static IP over the internet
- From: ARTMIC <ARTMIC@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 May 2006 16:11:01 -0700
I forgot to disable DHCP on the computer, so it changed every time so the
port and dmz was forward to the incorect internal ip address :)
as for the comptuer itself, it is stock Windows XP Pro with no Service Pack
installed :) the only thing i did install is the sql 2000 sp4
Thanks for the help though, i learned a whole lot from my brain freeze with
the dhcp stuff
"jebuskrust@xxxxxxxxx" wrote:
You guys are thinking too hard. Try permitting TCP/UDP access to port.
5555 and any other ms sql server related ports on the server. This is a
WINDOWS XP machine. Probably with service pack 2 installed.
ARTMIC wrote:
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?
- Prev by Date: Re: Connecting to DB with Static IP over the internet
- Next by Date: Cannot uninstall SQLServer 2000
- Previous by thread: Re: Connecting to DB with Static IP over the internet
- Next by thread: Cannot uninstall SQLServer 2000
- Index(es):
Relevant Pages
|
