replication on port 80 with sqlServer 2005

Can replication be done over port 80 with SQL Server 2005?
This would remove the "hotel firewall blocks port 1433" scenario.......
Thanks
You can run SQL server on any port including 1433, or 80. Causes havoc with
web servers running on this port though.
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
"astro" <astro@.bcmn.com> wrote in message
news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
> Can replication be done over port 80 with SQL Server 2005?
> This would remove the "hotel firewall blocks port 1433" scenario.......
>
> Thanks
>
|||that makes sense...but how do you deal with traveling sales staff that need
to replicate on their hotel connection when all ports except 80 (web) and 25
(smtp) and 110 (pop3) have been locked down? Has anyone else ran into this?
Or maybe this is some other issue.....
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OAc0HoM$FHA.272@.TK2MSFTNGP09.phx.gbl...
> You can run SQL server on any port including 1433, or 80. Causes havoc
> with web servers running on this port though.
> --
> 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
> "astro" <astro@.bcmn.com> wrote in message
> news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
>
|||I've noticed limitations are enforced if you enable web access in your
publication: first is the dynamic snapshots are not created or used as new
subs try to sync, 2nd you can use logical record, were replication can treat
joined tables as a transaction (order hdr/lines for example)
the new prepared dyn snap shots are awesome, our initial sync times went
from 40mins to ~ 2mins!! (and it was 2+ hours on sql2000) and its all
automatic...
also if you have the pub web enabled, yet still sync through the tradition
means (which you can, you can change it in the sub), dyn snapshouts still do
not work...
"astro" <astro@.bcmn.com> wrote in message
news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
> Can replication be done over port 80 with SQL Server 2005?
> This would remove the "hotel firewall blocks port 1433" scenario.......
>
> Thanks
>
|||sorry correction-- *CAN'T* use logical records
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:d10dc$439bed58$a227293d$4609@.ALLTEL.NET...
> I've noticed limitations are enforced if you enable web access in your
> publication: first is the dynamic snapshots are not created or used as new
> subs try to sync, 2nd you can use logical record, were replication can
> treat joined tables as a transaction (order hdr/lines for example)
> the new prepared dyn snap shots are awesome, our initial sync times went
> from 40mins to ~ 2mins!! (and it was 2+ hours on sql2000) and its all
> automatic...
> also if you have the pub web enabled, yet still sync through the tradition
> means (which you can, you can change it in the sub), dyn snapshouts still
> do not work...
> "astro" <astro@.bcmn.com> wrote in message
> news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
>
|||I'll have to look at this.....
Thanks.
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:d10dc$439bed58$a227293d$4609@.ALLTEL.NET...
> I've noticed limitations are enforced if you enable web access in your
> publication: first is the dynamic snapshots are not created or used as new
> subs try to sync, 2nd you can use logical record, were replication can
> treat joined tables as a transaction (order hdr/lines for example)
> the new prepared dyn snap shots are awesome, our initial sync times went
> from 40mins to ~ 2mins!! (and it was 2+ hours on sql2000) and its all
> automatic...
> also if you have the pub web enabled, yet still sync through the tradition
> means (which you can, you can change it in the sub), dyn snapshouts still
> do not work...
> "astro" <astro@.bcmn.com> wrote in message
> news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
>
|||cool!
sql2005 Merge replication speed is amazing now, makes sql2000 seem like the
stone age!!
"astro" <astro@.bcmn.com> wrote in message
news:hDhnf.9358$Dk.8912@.tornado.rdc-kc.rr.com...
> I'll have to look at this.....
> Thanks.
> "S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
> news:d10dc$439bed58$a227293d$4609@.ALLTEL.NET...
>