On 21 Dec 2004, laststubborn wrote:
Thank you Dave
I chnaged the machine I tried to use domain account but I have still
problems and errors
As
Is it the same error? Did you make sure the domain account had
sufficient priviledges on each box? "Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'." really seems to indicate a security context
problem and that it's not trying to log in as a domain account. Look in
BOL for the sp_adddistpublisher (or MSDN, or just sp_helptext it). This
procedure has some parameters (@security_mode, @trusted, etc) which define
how the authentication should happen. You may need to adjust these values
(or if you are using enterprise manager to set things up, determine how it
is choosing these values and change your use of their wizards
accordingly). Also just for now I would create a local account on each
computer with the exact same name and password and make it an
administrator on each and then set the MSSQLSERVER and SQLSERVERAGENT to
run as that account. This will simplify things and remove any external
variables which could be causing a problem (for instance if your domain
authentication machine was down, or domain permissions misset). Once you
get things up and running you can change it back to a domain account and
straighten out any domain related issues.
Dave