Re: Error 18456 Login failed for user 'distributor_admin'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Giacomo (anonymous_at_msnewsgroups.com)
Date: 07/18/04


Date: Sun, 18 Jul 2004 07:31:16 -0400

Dave,
You're in over my head, but it sounds like a permissions error.

If you go to services and select the properties of your server, you'll see
the account that the machine starts in. Check to see that account is
someone who is in the 'distributor_admin' group. You can browse for it
there - and both sides need to be members of that group since it appears to
have the permission to run the transaction.

Hope this helps.
Giac

"Dave" <dave.cartlidge@gmail.com> wrote in message
news:9401f534.0407180039.1d325c91@posting.google.com...
> Sorry, I should have given a bit more info. I'm trying to set up one
> machine to replicate the contents of one table to a second machine
> (not located in the same place)
>
> I figured I needed to set Machine A up as a distibutor and then allow
> Machine B to have a subscription.
>
> I don't have the 'Publisher's tab' as I have not configured it to be a
> publisher yet, this I can't do as I get the aforementioned error.
>
> I can't see a login 'distributor_admin' in Ent Mgr.
>
> I was assuming (maybe incorrectly) that I don't need to do anything on
> Machine B in order to be able to set up the publishing side on Machine
> A.
>
> Hope this helps you to help me :)
>
> Dave



Relevant Pages

  • Re: Problem using the offload agent parameters
    ... Is the account you are using part of the PAL, or does it have rights to ... Looking for a SQL Server replication book? ... involves one server acting as the Publisher and Distributer. ...
    (microsoft.public.sqlserver.replication)
  • Re: Still having DMZ Problems
    ... I think you need to make whatever account you are using to connect to your ... publisher from your subscriber in the dbo_role on the distribution database ... Looking for a SQL Server replication book? ... The Subscriber can connect to the Publisher in the DMZ, ...
    (microsoft.public.sqlserver.replication)
  • Re: Cant send email
    ... What does this have to do with Publisher? ... MVP Microsoft [Publisher] ... Server: 'mailout.htc.net', Protocol: SMTP, Server Response: '550 Barracuda ... I have deleted and reset up the account through my server and still did not ...
    (microsoft.public.publisher)
  • Re: linksysdata.com gone
    ... This URL formely has simulations of all Linksys ... You don't have permission to access /ui/ on this server. ... so it is probably a permissions error. ... John Navas FAQ for Wi-Fi: ...
    (alt.internet.wireless)
  • Re: PDF generation error
    ... I haven't used this component before, but it sounds like a permissions error ... IUSR_MachineName account, and it may not have the privileges to do what you ... > I am using the Report.NET to generate PDF reports. ...
    (microsoft.public.dotnet.framework)