all groups > sql server replication > march 2007 >
You're in the

sql server replication

group:

Access Internet from Replication Server through Prosy Server


Access Internet from Replication Server through Prosy Server Mario Barro
3/20/2007 12:00:00 AM
sql server replication:
Hi;

I have a push suscriptions server that need acces to Internet (publisher)
through proxy server computer.
So I need configure proxy server account in Sql Server Suscriptions machine,
because it run without desktop user sesion.

How can configure it?

Thanks in advanced
M. Barro


Re: Access Internet from Replication Server through Prosy Server Hilary Cotter
3/20/2007 12:00:00 AM
For push a drive is mapped to a local folder, i.e. \\servername\c$\program
files\Microsoft sql server\mssql\repldata

As long as the push agent can access this share you are golden. Now you need
to register the subscribers on the publisher, you do this through enterprise
manager. Register them, and then go to tools, replication, configure
distributor, publishers, subscribers, click on the subscriber tab and add
them there.

--
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



[quoted text, click to view]

Re: Pull Anonymous Transactional Suscription need access to Internet behind a proxy server Mario Barro
3/20/2007 7:04:50 PM
Hi;
Thanks Hilary;

I´m sorry because my english isn´t very well

SCENARY:

· Publisher and Distributor server accesibles through Internet (behind a
router ADSL with mappingSql Server ports)
(Transactional Publications)

· Suscriber with pull Transactional suscription anonymous over Internet
and snapshot over FTP
All work OK and Suscriber connect to Publish and distributor without
problems, Distributor Agent has a valid acount (sql autentication) to access
Publisher and Distributor.


But now, Suscriber is behind a proxy server (I think ISA server).
With a session initializate I can use Internet Explorer to use a valid proxy
acount, but I don´t know how do it for Sql server Suscriber without windows
session.
Where I can configure thoses parameters?

I hope my explanation will be better.

Thanks in advanced.

Mario Barro





"Hilary Cotter" <hilary.cotter@gmail.com> escribió en el mensaje
news:uyN334vaHHA.4772@TK2MSFTNGP05.phx.gbl...
[quoted text, click to view]


AddThis Social Bookmark Button