Access Denied when setting up a Subscriber for replication

i verified that the server settings and authentication is
the same for both servers/
i am trying to configure a windows 2003 server running sql
server 2000 to be a subscriber to a publisher runnign
win2k and sql 2000.
when I try to register the server, i get access denied.
any thoughts?
thanks
Jeff,
can you test network connectivity using PING and NET VIEW
(http://www.microsoft.com/resources/d...2003/standard/
proddocs/en-us/Default.asp?url=/resources/documentation/WindowsServ/2003/sta
ndard/proddocs/en-us/sag_TCPIP_pro_PingConnect.asp).
Can you also use QA on hte subscriber and test this tool, using a SQL user
(assuming mixed mode authentication).
Can you check that the SQL Server Service is started on the publisher
(sounds obvious but it's better if I ask).
Regards,
Paul Ibison
|||Hi Paul,
i can connect to the server using QA and specifying the IP
of the server. I can also ping using host name and IP.
thanjks

>--Original Message--
>Jeff,
>can you test network connectivity using PING and NET VIEW
>
(http://www.microsoft.com/resources/d...tion/WindowsSe
rv/2003/standard/
>proddocs/en-us/Default.asp?
url=/resources/documentation/WindowsServ/2003/sta
>ndard/proddocs/en-us/sag_TCPIP_pro_PingConnect.asp).
>Can you also use QA on hte subscriber and test this tool,
using a SQL user
>(assuming mixed mode authentication).
>Can you check that the SQL Server Service is started on
the publisher
>(sounds obvious but it's better if I ask).
>Regards,
>Paul Ibison
>
>.
>
|||Jeff,
can you connect using QA and the host name with trusted / non-trusted
security (logging into windows using the same account as the sql server
agent).
If you can connect using trusted security and host name then check that the
Account is in the PAL for the publication.
Finally, I did read in a thread that DTC needs enabling, which it isn't by
default in Win 2003
(http://support.microsoft.com/default...5bLN%5d;817064). I
understand the need for DTC in immediate updating subscribers but haven't
testes whether this thread was correct or not. Anyway, if it's not enabled
and the above comments don't lead to the solution, please try this also.
HTH,
Paul Ibison
|||I'd check your Client Network Utility Settings and verify that they are
pointing to the correct server.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:u1BBBRLaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Jeff,
> can you connect using QA and the host name with trusted / non-trusted
> security (logging into windows using the same account as the sql server
> agent).
> If you can connect using trusted security and host name then check that
the
> Account is in the PAL for the publication.
> Finally, I did read in a thread that DTC needs enabling, which it isn't by
> default in Win 2003
> (http://support.microsoft.com/default...5bLN%5d;817064). I
> understand the need for DTC in immediate updating subscribers but haven't
> testes whether this thread was correct or not. Anyway, if it's not enabled
> and the above comments don't lead to the solution, please try this also.
> HTH,
> Paul Ibison
>
|||Hilary and Paul,
i have looked at the client network util. and verified
they are pointing to the right server.
The issue now is, I cannot even register the server from
the Publisher in the ACL list. This is getting weirder by
the minute. I can verify connectivity by ping with no
issues.
In the Client util, i configure the server name on the
alias and the IP and also specify the port the SQL server
is listening on at the Subscriber. So at this point, i am
not sure what the issue is...
thanks for your help

>--Original Message--
>I'd check your Client Network Utility Settings and verify
that they are[vbcol=seagreen]
>pointing to the correct server.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
>news:u1BBBRLaEHA.4092@.TK2MSFTNGP11.phx.gbl...
trusted / non-trusted[vbcol=seagreen]
as the sql server[vbcol=seagreen]
then check that[vbcol=seagreen]
>the
enabling, which it isn't by[vbcol=seagreen]
5bLN%5d;817064). I[vbcol=seagreen]
subscribers but haven't[vbcol=seagreen]
if it's not enabled[vbcol=seagreen]
please try this also.
>
>.
>