"casy" <mailkerry@gmail.com> wrote in message
news:1164788470.730057.227460@80g2000cwy.googlegroups.com...
> Hi all,
>
> Cannot seem to find an answer to my proposed setup;-
>
> HQ Server
> SBS Server 2003 (Premium) R2 ie SQL 2005 Workgroup
> Remote Server
> SBS Server 2003 (standard) with SQL 2005 Express
>
> Need to sync the two databases(merge) thru an internet broadband
> connection, cannot use a VPN as there can ony be one SBS on the
> network.
>
> I have read that with SQL2000 we can publish the DB thru the ISA on HQ
> Server
> , but for this to work I would also need to give access (open ports ?)
> to the DB on the Remote Server which does not have ISA. Does this still
> apply to 2005 or is there a better way?
>
> I have seen mention of Web Sync but is this only for SQl Enterprise-
> not Workgruop?
>
> Hope it makes sense and somone can help-- my head is spinning...
>
> Thanks
> Casey
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:exN7$x7EHHA.420@TK2MSFTNGP06.phx.gbl...
> Yes you will need Enterprise Edition for Web Sync. However if you have an
> ftp server you can download the snapshot via ftp. You will need to open up
> port 1433 for inbound communication on your firewall, or use proxy server
> as you suggest.
>
> --
> Hilary Cotter
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "casy" <mailkerry@gmail.com> wrote in message
> news:1164788470.730057.227460@80g2000cwy.googlegroups.com...
>> Hi all,
>>
>> Cannot seem to find an answer to my proposed setup;-
>>
>> HQ Server
>> SBS Server 2003 (Premium) R2 ie SQL 2005 Workgroup
>> Remote Server
>> SBS Server 2003 (standard) with SQL 2005 Express
>>
>> Need to sync the two databases(merge) thru an internet broadband
>> connection, cannot use a VPN as there can ony be one SBS on the
>> network.
>>
>> I have read that with SQL2000 we can publish the DB thru the ISA on HQ
>> Server
>> , but for this to work I would also need to give access (open ports ?)
>> to the DB on the Remote Server which does not have ISA. Does this still
>> apply to 2005 or is there a better way?
>>
>> I have seen mention of Web Sync but is this only for SQl Enterprise-
>> not Workgruop?
>>
>> Hope it makes sense and somone can help-- my head is spinning...
>>
>> Thanks
>> Casey
>>
>
>

Mahesh [MSFT] wrote:
> No, workgroup can support Web Synchronization. It is not a Enterprise only
> feature.
>
> Hope that helps
> --Mahesh
>
> [ This posting is provided "as is" with no warranties and confers no
> rights. ]
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:exN7$x7EHHA.420@TK2MSFTNGP06.phx.gbl...
> > Yes you will need Enterprise Edition for Web Sync. However if you have an
> > ftp server you can download the snapshot via ftp. You will need to open up
> > port 1433 for inbound communication on your firewall, or use proxy server
> > as you suggest.
> >
> > --
> > Hilary Cotter
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
> >
> >
> > "casy" <mailkerry@gmail.com> wrote in message
> > news:1164788470.730057.227460@80g2000cwy.googlegroups.com...
> >> Hi all,
> >>
> >> Cannot seem to find an answer to my proposed setup;-
> >>
> >> HQ Server
> >> SBS Server 2003 (Premium) R2 ie SQL 2005 Workgroup
> >> Remote Server
> >> SBS Server 2003 (standard) with SQL 2005 Express
> >>
> >> Need to sync the two databases(merge) thru an internet broadband
> >> connection, cannot use a VPN as there can ony be one SBS on the
> >> network.
> >>
> >> I have read that with SQL2000 we can publish the DB thru the ISA on HQ
> >> Server
> >> , but for this to work I would also need to give access (open ports ?)
> >> to the DB on the Remote Server which does not have ISA. Does this still
> >> apply to 2005 or is there a better way?
> >>
> >> I have seen mention of Web Sync but is this only for SQl Enterprise-
> >> not Workgruop?
> >>
> >> Hope it makes sense and somone can help-- my head is spinning...
> >>
> >> Thanks
> >> Casey
> >>
> >
> >