sql server replication: How to create a suscription? -- sql server replication

How to create a suscription?

Juan Manuel Porras GÃ¡lvez
10/28/2007 12:38:01 PM

sql server replication:

Hello, after fighting to SQL Server replication, I'd like to know how to
create a suscriptor on a machine "B" for a publication make on a machine "A".
Distributor is placing on the machine "A".

The problem is the new suscriptor on the machine "B" cannot view the "A"
machine publication. Sometimes, I did it but more often I can't do the same.

Are there any relationship between remote servers autenthication and this
problem?. What can I do and where to watch the publication from the machine
"B" (to create the suscriptor)?

Thanks very much.

RE: How to create a suscription?

Juan Manuel Porras GÃ¡lvez
10/28/2007 1:25:01 PM

I'm writing abot pull suscriptions.

[quoted text, click to view]

Re: How to create a suscription?

Hilary Cotter
10/31/2007 10:41:27 PM

They need to be able to connect to server A. create an alias to it using
Client Network Utility (SQL 2000) or SQL Configuration Manger (SQL 2005).

Then try to register the Publisher (Server A) in SQL Server Management
Studio, once this is done the subscriber will be able to see the publisher.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
"Juan Manuel Porras Gálvez" <jmpgalvez@jmporrasg.jazztel.es> wrote in
message news:11B9DF80-B941-43A7-B5FC-77DEE42DB16C@microsoft.com...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.