Showing posts with label distribuitor. Show all posts
Showing posts with label distribuitor. Show all posts

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
>