"John" <john_corangamite@hotmail.com> wrote in message
news:uK8ffKEZGHA.1580@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> Can anyone point me to some details on how to setup a Pull Subscription? I
> have tried and get the same error each time. "Enterprise Mgr could not
> retrieve info about the Distributor or the Database". I'm sure i'm doing
> something wrong so a step by step guide is what I need. I have already
> followed one from "The Code Project" to create the Merge Replication which
> worked well.
>
> Thanks in advance.
>
> John
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:%234tCtnFZGHA.3972@TK2MSFTNGP04.phx.gbl...
> John,
> on the distributor, please try:
>
> Use Master
> go
> Select @@Servername
>
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
>
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:Ohj7dWGZGHA.5116@TK2MSFTNGP03.phx.gbl...
> Sounds like your app can't connect to the distributor. Make sure you
> specify the relevant parameters in the distributor properties and the
> account your app is running under is in the dbo_role on the distributor.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> 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
>
>
>
> "John" <john_corangamite@hotmail.com> wrote in message
> news:uK8ffKEZGHA.1580@TK2MSFTNGP02.phx.gbl...
>> Hi,
>>
>> Can anyone point me to some details on how to setup a Pull Subscription?
>> I have tried and get the same error each time. "Enterprise Mgr could not
>> retrieve info about the Distributor or the Database". I'm sure i'm doing
>> something wrong so a step by step guide is what I need. I have already
>> followed one from "The Code Project" to create the Merge Replication
>> which worked well.
>>
>> Thanks in advance.
>>
>> John
>>
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:uxzLJ1RZGHA.4884@TK2MSFTNGP02.phx.gbl...
> John - can you connect to the publisher/distributor (ping) from the
> subscriber? How about registering the server in enterprise manager?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:OG0vCXSZGHA.3684@TK2MSFTNGP05.phx.gbl...
> John,
> please can you post up the complete error message.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
>
>
>

John Wrote:
> Hi
>
> Can anyone point me to some details on how to setup a Pul
> Subscription?
> have tried and get the same error each time. "Enterprise Mgr could no
> retrieve info about the Distributor or the Database". I'm sure i'
> doin
> something wrong so a step by step guide is what I need. I have alread
> followed one from "The Code Project" to create the Merge Replicatio
> whic
> worked well
>
> Thanks in advance
>
> Joh