Wednesday, March 7, 2012

Problem with distributor

In the replication wizard, the first menu "SELECT DISTRIBUTOR", have two
options
a) Make the "Myserver" its own distribuitor, SQl Server will create a
distribuiton database server and log.
b) Use the following Server, ( The selected server must already be
configured as Distribuitor).
When i select the first option pop-ups a window with this text :
"SQL Server Agent on SERVER1\Macuco" currently uses the system account ,
which causes replication between servers to fail, In the following dialog
Box, specy another account for the service startup account "
In the SQL Server Agent Properties which account i need to choose?
Thanks in ADvance
Alejandro Carnero
Brazil-Santos
Ideally use a local admin account.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"alecarnero" <alecarnero@.uol.com.br> wrote in message
news:OTGvbxcAGHA.740@.TK2MSFTNGP12.phx.gbl...
> In the replication wizard, the first menu "SELECT DISTRIBUTOR", have two
> options
> a) Make the "Myserver" its own distribuitor, SQl Server will create a
> distribuiton database server and log.
> b) Use the following Server, ( The selected server must already be
> configured as Distribuitor).
> When i select the first option pop-ups a window with this text :
> "SQL Server Agent on SERVER1\Macuco" currently uses the system account ,
> which causes replication between servers to fail, In the following dialog
> Box, specy another account for the service startup account "
> In the SQL Server Agent Properties which account i need to choose?
> Thanks in ADvance
> Alejandro Carnero
> Brazil-Santos
>

No comments:

Post a Comment