By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,225 Members | 2,170 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,225 IT Pros & Developers. It's quick & easy.

fail to configure my server for replication

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.