""Bill Cheng [MSFT]"" <billchng@online.microsoft.com> wrote in message
news:GtbUgAXjDHA.2556@cpmsftngxa06.phx.gbl...
> Hi Jonathan,
>
> I found that the requirement is beyond the built-in function provided by
> SQL Server. The following article describes the process for automatically
> initiating replication over a dial-up connection. The process involves
> using a scheduled job to establish the dial-up connection and then perform
> the synchronization. This procedure is described in more detail in the
> "More Information" section of this article.
> 241149 HOW TO: Automate Replication over a Dial-Up Connection
> http://support.microsoft.com/?id=241149
>
> The article generally uses the command-line program RASDIAL to accomplish
> the function. However, I am not sure about your detailed configuration,
> e.g. if your VPN requires special methods to connect. Since it is related
> to Windows functionality, you may check if there is any unattended means
> with Windows newsgroups, e.g. microsoft.public.win2000.ras_routing (e.g.
> whether we can use Auto Connection Manager to connect without prompt).
> Generally if it has command-line tool provided, I think we can use some
> methods similar to above article.
>
> 254181 Description of the Functions of Remote Access Auto Connection
Manager
> http://support.microsoft.com/?id=254181
>
>
> Bill Cheng
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> --------------------
> | Content-Class: urn:content-classes:message
> | From: "Jonathan Lim" <jonathan@jamminc.com.my>
> | Sender: "Jonathan Lim" <jonathan@jamminc.com.my>
> | Subject: Auto Connection via internet for replication
> | Date: Tue, 7 Oct 2003 16:36:15 -0700
> | Lines: 26
> | Message-ID: <089001c38d2b$cc876000$a101280a@phx.gbl>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="iso-8859-1"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> | Thread-Index: AcONK8yH2C8H5+aOQ/uH3rMmn/rB8g==
> | Newsgroups: microsoft.public.sqlserver.replication
> | Path: cpmsftngxa06.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.replication:44019
> | NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
> | X-Tomcat-NG: microsoft.public.sqlserver.replication
> |
> | Hi,
> |
> | not sure if this is the right news group but it deals
> | with replication so.... here goes...
> |
> | I now have a sync job over the internet via VPN. The user
> | double click the VPN connection, connects and run the
> | sync job manually.
> |
> | I now want it to run automatically every night. How do I
> | start the connection to the server via VPN automatically??
> |
> |
> |
> | I have tried...
> | 1) started the auto conn mgr in the service
> | 2) setup all the connection .. internet and VPN to dial
> | without prompt.
> | 3) set dial default connection when need to VPN
> | 4) set the schedule for the agent.
> | but when the job starts.. it only connects to internet
> | and not the VPN...
> |
> | HELP :)
> |
> | Jonathan Lim
> |
>

| ""Bill Cheng [MSFT]"" <billchng@online.microsoft.com> wrote in message
| news:GtbUgAXjDHA.2556@cpmsftngxa06.phx.gbl...

""Bill Cheng [MSFT]"" <billchng@online.microsoft.com> wrote in message
news:MsAETcYkDHA.2624@cpmsftngxa06.phx.gbl...
> Hi Jonathan,
>
> I understand you are using Internet Explorer to view the post. Recently I
> hear similar issues. Please try to use Outlook Express to view the
> newsgroup post instead.
>
> In addition, have you checked http://support.microsoft.com/?id=241149? It
> seems to address your concerns, its process is
> 1) RADIAL to connect
> 2) Wait for some time enough for RASDIAL to connect
> 3) start another job
> 4) Wait for enough time for job to complete
> 5) RASDIAL to disconnect
>
> You may let me know which part does not address your specific needs.
Thanks.
>
> Step Command type Command Comments
>
> Step 1 Operating System Command (CmdExec) RASDIAL
> -entryname- This command starts the dial-up process.
>
> Step 2 Transact-SQL Script (TSQL) WAITFOR DELAY
> '00:02:00' This step initiates a delay to ensure that the connection is
> stable.
>
> Step 3 Transact-SQL Script (TSQL) EXEC
> sp_start_job @job_name = 'Distribution job name' This step starts the
> distribution job.
>
> Step 4 Transact-SQL Script (TSQL) WAITFOR DELAY
> '00:20:00' This delay allows the distribution task to complete.
>
> Step 5 Operating System Command (CmdExec) RASDIAL
> -entryname- / DISCONNECT This step closes the connection and disconnects.
>
>
> Bill Cheng
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> --------------------
> | From: "Jonathan Lim" <jonathan@jamminc.com.my>
> | References: <089001c38d2b$cc876000$a101280a@phx.gbl>
> <GtbUgAXjDHA.2556@cpmsftngxa06.phx.gbl>
> | Subject: Re: Auto Connection via internet for replication
> | Date: Mon, 13 Oct 2003 10:15:09 +0800
> | Lines: 127
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> | Message-ID: <usy#K7SkDHA.3312@tk2msftngp13.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.replication
> | NNTP-Posting-Host: 219.95.128.158
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.replication:44158
> | X-Tomcat-NG: microsoft.public.sqlserver.replication
> |
> | Hi Bill,
> |
> |
> |
> | I been having some problem logging on to the news server.. it keeps
> | saying -- Newsgroup not available
> |
> | ** finally got back via using outlook express.. rather than using web
> | browser ***
> |
> |
> |
> | Anyway, the suggestion works.. I am now using 4 batch files with the
> | following command line
> |
> |
> |
> | 1st Connect internet - rasdial internetServer username password
> |
> | 2nd Connect VPN - rasdial VPNServer username password
> |
> | 3rd Connect internet - rasdial internetServer /disconnect
> |
> | 4th Connect VPN - rasdial VPNServer /disconnect
> |
> |
> |
> | internetServer and VPNserver both already defined in the connection
> folder.
> |
> |
> |
> | then in the merge job, I added 1 and 2 before the merge job and 3 and 4
> | after to disconnect.. it works..:)
> |
> | only drawback now is that when the dial to internet is successful, the
job
> | is already mark successfully.. even though the sync job is just started.
> Is
> | there anyway to run another job from the first job.. so I can create
> another
> | job with the connection and call the merge job. This will eliminate
the
> | affect to the status reporting on replication monitor?
> |
> |
> |
> |
> |
> | ""Bill Cheng [MSFT]"" <billchng@online.microsoft.com> wrote in message
> | news:GtbUgAXjDHA.2556@cpmsftngxa06.phx.gbl...
> | > Hi Jonathan,
> | >
> | > I found that the requirement is beyond the built-in function provided
by
> | > SQL Server. The following article describes the process for
> automatically
> | > initiating replication over a dial-up connection. The process involves
> | > using a scheduled job to establish the dial-up connection and then
> perform
> | > the synchronization. This procedure is described in more detail in the
> | > "More Information" section of this article.
> | > 241149 HOW TO: Automate Replication over a Dial-Up Connection
> | > http://support.microsoft.com/?id=241149
> | >
> | > The article generally uses the command-line program RASDIAL to
> accomplish
> | > the function. However, I am not sure about your detailed
configuration,
> | > e.g. if your VPN requires special methods to connect. Since it is
> related
> | > to Windows functionality, you may check if there is any unattended
means
> | > with Windows newsgroups, e.g. microsoft.public.win2000.ras_routing
(e.g.
> | > whether we can use Auto Connection Manager to connect without prompt).
> | > Generally if it has command-line tool provided, I think we can use
some
> | > methods similar to above article.
> | >
> | > 254181 Description of the Functions of Remote Access Auto Connection
> | Manager
> | > http://support.microsoft.com/?id=254181
> | >
> | >
> | > Bill Cheng
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | > This posting is provided "as is" with no warranties and confers no
> rights.
> | > --------------------
> | > | Content-Class: urn:content-classes:message
> | > | From: "Jonathan Lim" <jonathan@jamminc.com.my>
> | > | Sender: "Jonathan Lim" <jonathan@jamminc.com.my>
> | > | Subject: Auto Connection via internet for replication
> | > | Date: Tue, 7 Oct 2003 16:36:15 -0700
> | > | Lines: 26
> | > | Message-ID: <089001c38d2b$cc876000$a101280a@phx.gbl>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="iso-8859-1"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> | > | Thread-Index: AcONK8yH2C8H5+aOQ/uH3rMmn/rB8g==
> | > | Newsgroups: microsoft.public.sqlserver.replication
> | > | Path: cpmsftngxa06.phx.gbl
> | > | Xref: cpmsftngxa06.phx.gbl
> microsoft.public.sqlserver.replication:44019
> | > | NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
> | > | X-Tomcat-NG: microsoft.public.sqlserver.replication
> | > |
> | > | Hi,
> | > |
> | > | not sure if this is the right news group but it deals
> | > | with replication so.... here goes...
> | > |
> | > | I now have a sync job over the internet via VPN. The user
> | > | double click the VPN connection, connects and run the
> | > | sync job manually.
> | > |
> | > | I now want it to run automatically every night. How do I
> | > | start the connection to the server via VPN automatically??