Showing posts with label settings. Show all posts
Showing posts with label settings. Show all posts

Tuesday, March 20, 2012

Remote servers

I am trying to use a remote distributor and I think my settings are wrong
for RPC and mapping. How should these be mapped so that the publisher can
see the SQL Server Agent on the distributor?
--Kristy
Whats the error message?
"Kristy" <pleasepostreply@.here.com> wrote in message
news:OCz1FewMFHA.2736@.TK2MSFTNGP09.phx.gbl...
>I am trying to use a remote distributor and I think my settings are wrong
> for RPC and mapping. How should these be mapped so that the publisher can
> see the SQL Server Agent on the distributor?
> --Kristy
>
|||Publisher can not connect to ditributor because it is not configured for
remote access. I looked in the sysservers table and it is configured for rpc
and data access on both machines.
--Kristy
"ChrisR" <noemail@.bla.com> wrote in message
news:%23GX4QgHNFHA.1308@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Whats the error message?
> "Kristy" <pleasepostreply@.here.com> wrote in message
> news:OCz1FewMFHA.2736@.TK2MSFTNGP09.phx.gbl...
can
>

Wednesday, March 7, 2012

REMOTE DISTRIBUTOR / FTP SETTINGS

Hello.
I have this problem.
I have 2 servers X and Y.
X is only Publisher
Y is Publisher and Distributor for X and Y.
My question. When i make a publication in X, do i have to set the ftp server
parameter for the snapshot in X or Y.
I'm having errors on Connections.
Thanks in Advance
The ftp server can be anywhere, publisher, subscriber, distributor or
another server altogether. What you need to be able to do make sure the ftp
server has the snapshot files and the subscriber can resolve the ftp
servername. This is normally done by creating a snapshot share on the
distributor.
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
"Jose Fernandez" <ppcuban@.hotmail.com> wrote in message
news:OJdjyFqLGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hello.
> I have this problem.
> I have 2 servers X and Y.
> X is only Publisher
> Y is Publisher and Distributor for X and Y.
> My question. When i make a publication in X, do i have to set the ftp
> server parameter for the snapshot in X or Y.
> I'm having errors on Connections.
> Thanks in Advance
>
|||Jose,
I'm not too sure I follow. The FTP settings are on a publication basis is
SQL 2000/2005. In SQL 7.0 they were done on a subscription basis.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)