sql server replication: Try setting the account using services in Control Panel -
you have the option of browsing AD there.
HTH,

Hi guys,

I'm trying to setup replication from an SQL Server 2000 Enterprise database
to an MSDE 2000 database on one of my XP workstations. The server is running
Windows 2003 Enterprise Server. When (on the server) I try to setup the
server database as publisher, I get a message saying that because the agent
is running under the system account, replication between servers will fail.
I tried changing the agent account to the domain admin account, but another
message says it can't find that account.

Well obviously I'm doing something wrong, but needless to say, I don't know
what.

Can anyone shed some light on how to do it please?

Regards,
Graham

Paul,

Thanks for the advice. I'll give it a try and let you know what happens.

Regards,
Graham

[quoted text, click to view]

You can use the system account if you're doing
replication on one box, other than that the agent will
need a domain login in order to access things on other
boxes: snapshot files, the distribution database, and the
publication database in some cases.
If you open Control Panel, Administrative Tools, Services
and find the SQLSERVERAGENT and MSSQLSERVER services.
Their properties will allow you to browse to select a
user.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi Paul,

I poked around in Control Panel and Admin Tools, but couldn't see anywhere
to set the agent account using AD. Even if I supply the username/password of
a user with domain admin rights, I still get the same message (...not
found).

Before I go too far down the track of changing the agent account, can you
clear something up for me please? Why can't the system account be used for
replication (is it due to scope)? What should the agent account be?

Now I can ask... If I have to change the agent account, what's the best way
to do it?

Regards,
Graham


[quoted text, click to view]

Paul,

BINGO! Thanks for the info, and for being so patient.

Regards,
Graham

[quoted text, click to view]