Replicated table. Access denied -- sql server replication

Don
9/18/2003 2:02:57 PM

SQL 2000 Transact replication. Immediate updating
subscribers.

On 2 of 3 subscripion servers, I can't modify user tables
even if I'm "sa" on that server. I get the error:

"SQL server does not exist or access denied."

All is well on one of the subscibers. Replication is
working. I can delete all of the records on the publisher
in a user table and they are immediately deleted at all
subscribers. Weird. I just can't modify the tables in QA
on those 2 servers.

Any help appreciated.

Thanks,

Darren
9/19/2003 8:44:54 AM

It sounds like you are having remote login problems on some of your
machines.

If you go directly to that machine, can you login as "sa" and create tables,
modify etc?

Look in BOL under the"remote loging mapping" section. It has two areas with
more info "Establishing Security for Remote Servers" and "sp_addremotelogin"

Hope that helps get you at least pointed in the right direction.

Darren [MSFT]
--
This message is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server replication : Replicated table. Access denied