question

aashish77 avatar image
aashish77 asked

"REPLICATION USING SQL SERVER 2000"

Hi

Am new to SQL SERVER 2000 DBA.

Tried to explore the possibility of "REPLICATION USING SQL SERVER 2000" but not with much success.

Got the below mentioned error and am stuck.

SQL Server Agent on 'SRv01' currently uses the system account, which causes the replicationbetween servers to fail. In the following Dialog box, Specify another account for the sercive startup account

Any good resources to help in implementating "REPLICATION USING SQL SERVER 2000".

Please Suggest

sql-server-2000
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Oleg avatar image
Oleg answered

System account does not have any rights to network resources, and therefore, should not be used in replication environment (any version). This part is easy to change: start->run->services.msc /s, find SQL Server Agent service and change the account under logon tab.

SQL Server 200 replication Step by step example by Mahesh Kodli seems to be pretty good resource: http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/

Oleg

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.