distributor_admin Issue....But different than normal

I am having the common "distributor_admin does not exist" error when
trying to set up a machine as its own distributor. (First time after
setting up about 200 distributors). I get this whether I'm doing it
remotely, or on the machine itself.

The wrinkle is that the login "distributor_admin" does not exist at all
on the potential publisher (who, again, is going to be its own
distributor).

Do I need to reinstall MS-SQL to get that login created? Or can I do
it by hand somehow?

Or am I barking up the wrong tree?

Thank you!

-Joseph

.

Relevant Pages

  • RE: Subscriber Security Settings for Distributor and Publisher login b
    ... First of all - once you have a correctly configured publisher/subscriber/distributor and you have built and distributed your publication, you should not run into this problem. ... You are possibly running into another problem, which may or may not show up as the "login failure" error message. ... > I have setup merge replication with subscribers all synching up fine, but> all of a sudden one of teh subscribers wouldnt connect to the distributor,> it would say failed login. ...
    (microsoft.public.sqlserver.replication)
  • Re: Transactional Replication
    ... agent's login of the subscriber in trusted pull replication. ... that this windows login has permissions to access the distributor. ...
    (microsoft.public.sqlserver.replication)
  • Re: distributor_admin Issue....But different than normal
    ... Looking for a SQL Server replication book? ... trying to set up a machine as its own distributor. ... The wrinkle is that the login "distributor_admin" does not exist at all ... Do I need to reinstall MS-SQL to get that login created? ...
    (microsoft.public.sqlserver.replication)
  • Re: distributor_admin Issue....But different than normal
    ... setting distribution up. ... Looking for a SQL Server replication book? ... trying to set up a machine as its own distributor. ... Do I need to reinstall MS-SQL to get that login created? ...
    (microsoft.public.sqlserver.replication)
  • SQLCE Replication Issue
    ... All my merge rep stuff is setup. ... When i run the merge process i get the user could not login to the distributor. ... I have checked all my merge replication parameters and access profiles list, i have even tested the username and login through my SQL2000 client which logs in just fine. ...
    (microsoft.public.dotnet.framework.compactframework)