sql server replication: The distribution server for my publisher is a live server, and the publisher is a test server that I wish to make it's own distributor. Whenever I try to select it as it's own distributor, I get an error that "distributor_admin" is not a local user. How do I go about fixing this

Thanks for your help

[quoted text, click to view]
No. The distributor is machine A, the publisher is machine B, I wish to
make machine B it's own distributor


[quoted text, click to view]
Same segment, but the subscriber (Machine C) is not on any domain, I
registered it by IP address. I'm not having any problems with the
subscriber, merely with making the publisher it's own distributor.

[quoted text, click to view]
I'll check, but I think so.

[quoted text, click to view]
I already set up a replication account, I merely wish to make the
publisher it's own distributor.



*** Sent via Developersdex http://www.developersdex.com ***

Where is your Distributor? Is it on the Publisher?

Is the Subscriber in the same domain as the Publisher?

How did you configure your Subscriber? Can you go to
Tools-Replication-Configure Publishers, Subscribers, Distributors, click on
the Subscribers tab, and click on the browse button (the three ellipses) to
the right of your server name?

Make sure you are using Impersonate the SQL Server Agent account on the
Publisher if you are in the same domain.

[quoted text, click to view]
publisher is a test server that I wish to make it's own distributor.
Whenever I try to select it as it's own distributor, I get an error that
"distributor_admin" is not a local user. How do I go about fixing this?
[quoted text, click to view]

The solution is easy!!! Register servers to SQL by using their names