Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2002-10-07 : 06:22:58
|
| Hi,I am trying to do replication first time and i am facing some problems.When I am running wizard for new Replication->Publication.In 'Select Distributor' option it is saying thatSQL Server Agent on 'ServerName' is currently uses the system account, which causes replication between servers to fail.And while specifying the new account it is saying that :The SQL Server does not sufficient permissions to verify the SQL Server Agent start-up account. Are you sure new SQL Server start-up accout is vaild?While going more ahead... in 'Specify Article' I am getting all the Table key with CROSS sign.I need to know how to setup SQL Server Agent Start-up Account. And what are the permission for that. Where I am doing mistake.Help needed thankx and waiting... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-07 : 07:42:18
|
| The user needs access to both servers. Easiest to start off with a domain administrator account to get things working.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Replication Problem