471,853 Members | 1,842 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

fail to configure my server for replication

I am new with Replication

I develop Now the Microsoft Server 2000 Replication

And I chose Snapshot type for replication

All I need to copy Part of db from Publisher via distributor to
I tried with Windows xp pro
with sql server
and I want to do puplisher and distributer at the same server

But the problem that I could net configure it due a lot of error

From SQL Enterprise


That is list of error

Error 1:SQL Server Agent on currently uses the system

which cause replication between servers to fail

// Hint I created new local account and gave it all Administration
then did not recognize new acount
Error 2:the new service startup account name you have supplied

is invalid or dose not exist

Error 3:Error 18483 could not connect to server IWS-DEV because

is not defined as a remote login at the server

Last Message before error:

configure '' as a Publisher. Use '' as

the Distributor.

Configure the SQL Server Agent service on '' to

start automatically when the computer is started.

Use 'C:\Program Files\Microsoft SQL

Server\MSSQL\REPLDATA' as the root snapshot folder

for Publishers using this Distributor.

Store the distribution database 'distribution'

in ‘C:\Program Files\Microsoft SQL Server\MSSQL\Data'.

Store the distribution database log file in 'C:\Program

Files\Microsoft SQL Server\MSSQL\Data'.

Enable the following databases on '' for merge



Please if any one try with replication

Tell me How I configure the Server as Publisher and distributor and
finally little subscribers


Any one can help me and tell me How step by step to configure the db
Jul 20 '05 #1
0 2036

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Danny J. Lesandrini | last post: by
reply views Thread by NeoPa | last post: by
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.