Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2005-12-02 : 15:10:13
|
| I'm setting up a dts package that needs to open a vpn client. I'd like to schedule this off hours and therefore noone will be here to start the vpn client. Does anyone know of a way to autostart a Lucent iPSec client?thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-03 : 13:49:12
|
| ??? You want to do this from DTS???Learn Windows scripting and create a schedule. Is the iPSec client on the same server as SQL Server? Are you wanting to just start the service or actually open up a VPN client session?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2005-12-04 : 16:52:55
|
quote:
Originally posted by derrickleggett
??? You want to do this from DTS???Learn Windows scripting and create a schedule. Is the iPSec client on the same server as SQL Server? Are you wanting to just start the service or actually open up a VPN client session?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
|
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-04 : 21:17:26
|
| ???MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2005-12-05 : 09:14:19
|
Sorry about the last post. The ipsec software is on one of the dba's machines. I'd like to put it on the sql server itself (any security reasons not too?). My intentions are to start the vpn client, login and connect to the secure backend, run my dts package and pull the data into my db.quote:
Originally posted by derrickleggett
???MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
|
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-05 : 23:34:54
|
| Where is this database server that you are wanting to pull the data to? It's not on the secure backend with the other database server? Explain the topology here. I don't want to be accidentally helping a hacker here.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2005-12-06 : 08:57:34
|
I'm connecting to an Oracle DB (linked Server) thats outside our firewall and behind another. To get to the Oracle DB we must use a VPN client. I'm then bringing this data into sqlserver 2000. quote:
Originally posted by derrickleggett
Where is this database server that you are wanting to pull the data to? It's not on the secure backend with the other database server? Explain the topology here. I don't want to be accidentally helping a hacker here.
|
|
|
|
|
|
|
autostart vpn for dts