Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Pl. post this question in Windows 2003 Server newsgroups rather than in an
SQL Server specific group.
Anith
sql
Showing posts with label connection. Show all posts
Showing posts with label connection. Show all posts
Friday, March 30, 2012
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
You have posted this into multiple unlinked groups which don't appear to be
anything to do with your question. Please restrict your questions to groups
to which it is relevant. Several people (including myself) have already
answered this elsewhere.
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:jPidnd00VsRrGjvcRVn-uw@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
You have posted this into multiple unlinked groups which don't appear to be
anything to do with your question. Please restrict your questions to groups
to which it is relevant. Several people (including myself) have already
answered this elsewhere.
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:jPidnd00VsRrGjvcRVn-uw@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
Am I correct in saying that you are trying to access an FTP site on your SBS
server? And presumably it has two network cards? If this is the case then
open up the IIS services manager, FTP sites, then right click and select
properties, then check under IP address that your internal IP address is
selected, this will mean that the ftp site is not available from your
external IP address though.
To be honest I'm entirely sure of your setup from the posting, the other
understanding I had would mean going down the line of setting up a static
route on the VPN router to ensure those packets are routed over the VPN
rather that the network.
Hope this helps
Dan
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:5dKdnWgJSLggFTvcRVn-vQ@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
Am I correct in saying that you are trying to access an FTP site on your SBS
server? And presumably it has two network cards? If this is the case then
open up the IIS services manager, FTP sites, then right click and select
properties, then check under IP address that your internal IP address is
selected, this will mean that the ftp site is not available from your
external IP address though.
To be honest I'm entirely sure of your setup from the posting, the other
understanding I had would mean going down the line of setting up a static
route on the VPN router to ensure those packets are routed over the VPN
rather that the network.
Hope this helps
Dan
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:5dKdnWgJSLggFTvcRVn-vQ@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
You have posted this into multiple unlinked groups which don't appear to be
anything to do with your question. Please restrict your questions to groups
to which it is relevant.
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:XcKdnWA0VOIRFTvcRVn-hw@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
You have posted this into multiple unlinked groups which don't appear to be
anything to do with your question. Please restrict your questions to groups
to which it is relevant.
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:XcKdnWA0VOIRFTvcRVn-hw@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Can you ping any of these sites? If you can't ping them you have to use the
route add command to add a route to get to the ftp sites.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:XYWdnT2NHp0dFTvcRVn-gA@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Can you ping any of these sites? If you can't ping them you have to use the
route add command to add a route to get to the ftp sites.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:XYWdnT2NHp0dFTvcRVn-gA@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Is this really a SQL Server question? You might do better posting this to a
Windows newsgroup or perhaps an IIS newsgroup.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
|||Create an Administrative FTP site hooked to the private IP on the IIS server. It is multi-homed; isn't it?
Now, this really isn't a SQL Server question, now is it?
Sincerely,
Anthony Thomas
"Jason Robertson" <jason6869@.msn.com> wrote in message news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
sql
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Is this really a SQL Server question? You might do better posting this to a
Windows newsgroup or perhaps an IIS newsgroup.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
|||Create an Administrative FTP site hooked to the private IP on the IIS server. It is multi-homed; isn't it?
Now, this really isn't a SQL Server question, now is it?
Sincerely,
Anthony Thomas
"Jason Robertson" <jason6869@.msn.com> wrote in message news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
sql
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.Is this really a SQL Server question? You might do better posting this to a
Windows newsgroup or perhaps an IIS newsgroup.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.Is this really a SQL Server question? You might do better posting this to a
Windows newsgroup or perhaps an IIS newsgroup.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.Is this really a SQL Server question? You might do better posting this to a
Windows newsgroup or perhaps an IIS newsgroup.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>|||Create an Administrative FTP site hooked to the private IP on the IIS server
. It is multi-homed; isn't it?
Now, this really isn't a SQL Server question, now is it?
Sincerely,
Anthony Thomas
--
"Jason Robertson" <jason6869@.msn.com> wrote in message news:cMidnYAGMND8Fz
vcRVn-3Q@.comcast.com...
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.Is this really a SQL Server question? You might do better posting this to a
Windows newsgroup or perhaps an IIS newsgroup.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:cMidnYAGMND8FzvcRVn-3Q@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>|||Create an Administrative FTP site hooked to the private IP on the IIS server
. It is multi-homed; isn't it?
Now, this really isn't a SQL Server question, now is it?
Sincerely,
Anthony Thomas
--
"Jason Robertson" <jason6869@.msn.com> wrote in message news:cMidnYAGMND8Fz
vcRVn-3Q@.comcast.com...
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
This is not really as SQL Server question! Sounds like you either need
address translation or a second network card to give the IIS servers and
internally facing IP address (and suitable firewall rules to restrict
access). A possibly alternative would be to use an upload utility that uses
HTTPS instead.
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:nvCdnZ3aX-TOFzvcRVn-uw@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hi
This is not really as SQL Server question! Sounds like you either need
address translation or a second network card to give the IIS servers and
internally facing IP address (and suitable firewall rules to restrict
access). A possibly alternative would be to use an upload utility that uses
HTTPS instead.
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:nvCdnZ3aX-TOFzvcRVn-uw@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hey Jason, I think you have the wrong newsgroup. No worries though. I had a
similar problem. What I did to "fix" it was use the route command to a route
to the Public FTP IP addrs. The command looks like this:
route ADD w.x.y.z MASK 255.255.255.0 10.10.10.1
All you would need to change is w.x.y.z to the network of the public FTP.
Then the correct subnet mask instead of the 255.255.255.0 I guess. And
finally whatever gateway you have during your VPN session, I guess .1.
To get help try "route /?". To see that everyone looks good try "route
print"
I put my fix in a bat file, I would only run the bat upon connecting to the
VPN. I had another bat file that would undo it, "route DELETE w.x.y.z".
If this is not your problem, if you really just can't to the net when
VPNing, try going through a Proxy server.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:0_idndGx5opzGjvcRVn-qA@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.
Hey Jason, I think you have the wrong newsgroup. No worries though. I had a
similar problem. What I did to "fix" it was use the route command to a route
to the Public FTP IP addrs. The command looks like this:
route ADD w.x.y.z MASK 255.255.255.0 10.10.10.1
All you would need to change is w.x.y.z to the network of the public FTP.
Then the correct subnet mask instead of the 255.255.255.0 I guess. And
finally whatever gateway you have during your VPN session, I guess .1.
To get help try "route /?". To see that everyone looks good try "route
print"
I put my fix in a bat file, I would only run the bat upon connecting to the
VPN. I had another bat file that would undo it, "route DELETE w.x.y.z".
If this is not your problem, if you really just can't to the net when
VPNing, try going through a Proxy server.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:0_idndGx5opzGjvcRVn-qA@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>
How to FTP via VPN to sites with real adresses on different IP's ?
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.This has been answered in numerous other groups please do not cross post
unlinked items
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:svKdnZQnc9zYFzvcRVn-sA@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>sql
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites using
the VPN server's IP, 10.10.10.2. Could you give me specific directions how
to deal with this?
Thank you for your help.This has been answered in numerous other groups please do not cross post
unlinked items
John
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:svKdnZQnc9zYFzvcRVn-sA@.comcast.com...
> Hi,
> I am using Windows 2003 Server. The VPN works fine, but I want to FTP
> through the VPN so the connection is encrypted. The problem is each of my
> IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
> comes up using a private IP, I can't connect to any of the FTP sites using
> the VPN server's IP, 10.10.10.2. Could you give me specific directions how
> to deal with this?
> Thank you for your help.
>sql
Monday, March 19, 2012
How to find Queries which makes CPU 100% ?
Hi,
There is an application which makes connection of more than 300 users
to a SQL Server 2000 DB.
Most of the times the server CPU hits the 100% for 2-3 seconds.
Since lots of queries are fired hence i'm unable to track down which
query makes the CPU 100%.
I'm using the SQL profiler (with settings on the Duration filter),
still i'm unabl;e to track down the BAD Queries.
Please suggest me a way/method/application to TRACK DOWN THE QUERIES
RESPONSIBLE TO OVERLOAD THE CPU BY 100 %.
Thanks,
~Nimit Sharma.Hi
Turn on SQL Server Profiler and filter by CPU
<nimitsharma16@.gmail.com> wrote in message
news:1189330367.686296.120070@.19g2000hsx.googlegroups.com...
> Hi,
> There is an application which makes connection of more than 300 users
> to a SQL Server 2000 DB.
> Most of the times the server CPU hits the 100% for 2-3 seconds.
> Since lots of queries are fired hence i'm unable to track down which
> query makes the CPU 100%.
> I'm using the SQL profiler (with settings on the Duration filter),
> still i'm unabl;e to track down the BAD Queries.
> Please suggest me a way/method/application to TRACK DOWN THE QUERIES
> RESPONSIBLE TO OVERLOAD THE CPU BY 100 %.
> Thanks,
> ~Nimit Sharma.
>|||Generally, it a normal behavior when some query utilizie 100% of CPU for 2-3
seconds, specially if it is using the data that are already in cache. Do you
really need to track such queries?
"nimitsharma16@.gmail.com" wrote:
> Hi,
> There is an application which makes connection of more than 300 users
> to a SQL Server 2000 DB.
> Most of the times the server CPU hits the 100% for 2-3 seconds.
> Since lots of queries are fired hence i'm unable to track down which
> query makes the CPU 100%.
> I'm using the SQL profiler (with settings on the Duration filter),
> still i'm unabl;e to track down the BAD Queries.
> Please suggest me a way/method/application to TRACK DOWN THE QUERIES
> RESPONSIBLE TO OVERLOAD THE CPU BY 100 %.
> Thanks,
> ~Nimit Sharma.
>
There is an application which makes connection of more than 300 users
to a SQL Server 2000 DB.
Most of the times the server CPU hits the 100% for 2-3 seconds.
Since lots of queries are fired hence i'm unable to track down which
query makes the CPU 100%.
I'm using the SQL profiler (with settings on the Duration filter),
still i'm unabl;e to track down the BAD Queries.
Please suggest me a way/method/application to TRACK DOWN THE QUERIES
RESPONSIBLE TO OVERLOAD THE CPU BY 100 %.
Thanks,
~Nimit Sharma.Hi
Turn on SQL Server Profiler and filter by CPU
<nimitsharma16@.gmail.com> wrote in message
news:1189330367.686296.120070@.19g2000hsx.googlegroups.com...
> Hi,
> There is an application which makes connection of more than 300 users
> to a SQL Server 2000 DB.
> Most of the times the server CPU hits the 100% for 2-3 seconds.
> Since lots of queries are fired hence i'm unable to track down which
> query makes the CPU 100%.
> I'm using the SQL profiler (with settings on the Duration filter),
> still i'm unabl;e to track down the BAD Queries.
> Please suggest me a way/method/application to TRACK DOWN THE QUERIES
> RESPONSIBLE TO OVERLOAD THE CPU BY 100 %.
> Thanks,
> ~Nimit Sharma.
>|||Generally, it a normal behavior when some query utilizie 100% of CPU for 2-3
seconds, specially if it is using the data that are already in cache. Do you
really need to track such queries?
"nimitsharma16@.gmail.com" wrote:
> Hi,
> There is an application which makes connection of more than 300 users
> to a SQL Server 2000 DB.
> Most of the times the server CPU hits the 100% for 2-3 seconds.
> Since lots of queries are fired hence i'm unable to track down which
> query makes the CPU 100%.
> I'm using the SQL profiler (with settings on the Duration filter),
> still i'm unabl;e to track down the BAD Queries.
> Please suggest me a way/method/application to TRACK DOWN THE QUERIES
> RESPONSIBLE TO OVERLOAD THE CPU BY 100 %.
> Thanks,
> ~Nimit Sharma.
>
Monday, March 12, 2012
How to find out Usersinfo using JDBC Connection to SQL Server
Hi..
I want to find out the List of users created in SQL Server.
Im using type 4 Driver to Connect SQL Server.
Regards
maruthi.List of active users, users for a database or logins for the sql server ?|||select * from master.dbo.syslogins
select * from master.dbo.sysxlogins
select * from your_database.dbo.sysusers|||Thanks
the problem is solved.
I want to find out the List of users created in SQL Server.
Im using type 4 Driver to Connect SQL Server.
Regards
maruthi.List of active users, users for a database or logins for the sql server ?|||select * from master.dbo.syslogins
select * from master.dbo.sysxlogins
select * from your_database.dbo.sysusers|||Thanks
the problem is solved.
Friday, March 9, 2012
how to find out MSSQL connection string?
how to find out MSSQL connection string?
Thx
YuriWHi Yuri,
Can you give us some more information on what it is you want
to know? Are you wanting to know how to build a connection
string for an application, for ADO to connect to SQL Server?
Or do you want to know how to tell how an application or
user is connecting to SQL Server? Or something else?
-Sue
On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
<yuriw@.hotmail.com> wrote:
>how to find out MSSQL connection string?
>Thx
>YuriW
>|||What connection string you should use to connect to a SQL
Server instance depends on the driver you use.
For instance, if you use the Microsoft SQL Server ODBC
driver, the connection string is documented under the
SQLDriverConnect() function.
Linchi
>--Original Message--
>how to find out MSSQL connection string?
>Thx
>YuriW
>
>.
>|||Say I have a ODBC connection that tests OK.
I want to know what connection string it uses when making a connection...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:leg0qvgb6hbone5eu8cg13df9mq1ddech2@.4ax.com...
> Hi Yuri,
> Can you give us some more information on what it is you want
> to know? Are you wanting to know how to build a connection
> string for an application, for ADO to connect to SQL Server?
> Or do you want to know how to tell how an application or
> user is connecting to SQL Server? Or something else?
> -Sue
> On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
> <yuriw@.hotmail.com> wrote:
> >how to find out MSSQL connection string?
> >
> >Thx
> >
> >YuriW
> >
>|||It depends on what you entered for the options but it would
look something like the SQL Server ODBC examples at this
site (watch for line wrap on the link):
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForSQLServer
Most of the entries correspond to what you see in the ODBC
data source administrator applet except for dialog you get
for authentication. If you select Windows NT Authentication
Using Network Login ID, that will use a connection string
with Trusted_connection=Yes.
If you select SQL Server authentication, that will use a
connection string with UID=YourLogin and PWD=YourPassword.
-Sue
On Wed, 29 Oct 2003 23:30:38 GMT, "Yuri Weinstein"
<yuriw@.hotmail.com> wrote:
>Say I have a ODBC connection that tests OK.
>I want to know what connection string it uses when making a connection...
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:leg0qvgb6hbone5eu8cg13df9mq1ddech2@.4ax.com...
>> Hi Yuri,
>> Can you give us some more information on what it is you want
>> to know? Are you wanting to know how to build a connection
>> string for an application, for ADO to connect to SQL Server?
>> Or do you want to know how to tell how an application or
>> user is connecting to SQL Server? Or something else?
>> -Sue
>> On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
>> <yuriw@.hotmail.com> wrote:
>> >how to find out MSSQL connection string?
>> >
>> >Thx
>> >
>> >YuriW
>> >
>
Thx
YuriWHi Yuri,
Can you give us some more information on what it is you want
to know? Are you wanting to know how to build a connection
string for an application, for ADO to connect to SQL Server?
Or do you want to know how to tell how an application or
user is connecting to SQL Server? Or something else?
-Sue
On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
<yuriw@.hotmail.com> wrote:
>how to find out MSSQL connection string?
>Thx
>YuriW
>|||What connection string you should use to connect to a SQL
Server instance depends on the driver you use.
For instance, if you use the Microsoft SQL Server ODBC
driver, the connection string is documented under the
SQLDriverConnect() function.
Linchi
>--Original Message--
>how to find out MSSQL connection string?
>Thx
>YuriW
>
>.
>|||Say I have a ODBC connection that tests OK.
I want to know what connection string it uses when making a connection...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:leg0qvgb6hbone5eu8cg13df9mq1ddech2@.4ax.com...
> Hi Yuri,
> Can you give us some more information on what it is you want
> to know? Are you wanting to know how to build a connection
> string for an application, for ADO to connect to SQL Server?
> Or do you want to know how to tell how an application or
> user is connecting to SQL Server? Or something else?
> -Sue
> On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
> <yuriw@.hotmail.com> wrote:
> >how to find out MSSQL connection string?
> >
> >Thx
> >
> >YuriW
> >
>|||It depends on what you entered for the options but it would
look something like the SQL Server ODBC examples at this
site (watch for line wrap on the link):
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForSQLServer
Most of the entries correspond to what you see in the ODBC
data source administrator applet except for dialog you get
for authentication. If you select Windows NT Authentication
Using Network Login ID, that will use a connection string
with Trusted_connection=Yes.
If you select SQL Server authentication, that will use a
connection string with UID=YourLogin and PWD=YourPassword.
-Sue
On Wed, 29 Oct 2003 23:30:38 GMT, "Yuri Weinstein"
<yuriw@.hotmail.com> wrote:
>Say I have a ODBC connection that tests OK.
>I want to know what connection string it uses when making a connection...
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:leg0qvgb6hbone5eu8cg13df9mq1ddech2@.4ax.com...
>> Hi Yuri,
>> Can you give us some more information on what it is you want
>> to know? Are you wanting to know how to build a connection
>> string for an application, for ADO to connect to SQL Server?
>> Or do you want to know how to tell how an application or
>> user is connecting to SQL Server? Or something else?
>> -Sue
>> On Wed, 29 Oct 2003 21:27:21 GMT, "Yuri Weinstein"
>> <yuriw@.hotmail.com> wrote:
>> >how to find out MSSQL connection string?
>> >
>> >Thx
>> >
>> >YuriW
>> >
>
Friday, February 24, 2012
How to find database table and their field name run time.
I am using sql server as back end. Through connection stringI am getting database name. But in A dropdown I want to show list of table inthat database. And in another B drop down I want to show fields of tableselected in A dropdown. can any one help in getting the field .
The sp_Tables query will return the tables in a database andsp_Columns returns the column names
http://www.vb-tips.com/dbpages.aspx?ID=9e2d9af4-3909-421d-b422-87c1d376674d
|||
And if you want to dig deeper into the structure of the database or server, you can use SQL-DMO in SQL Server 2000 or SMO (SQL Management Objects) in SQL Server 2005.
Don
Subscribe to:
Posts (Atom)