473,408 Members | 1,866 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

fail to configure my server for replication

Ref
Hi
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
Subscriber
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
message

From SQL Enterprise

__

That is list of error

Error 1:SQL Server Agent on 127.0.0.1 currently uses the system
account

which cause replication between servers to fail

// Hint I created new local account and gave it all Administration
Group
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
'distributer_admin'

is not defined as a remote login at the server

Last Message before error:

configure '127.0.0.1' as a Publisher. Use '127.0.0.1' as

the Distributor.

Configure the SQL Server Agent service on '127.0.0.1' 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 '127.0.0.1' for merge

replication:

pubs

Please if any one try with replication

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

Regards

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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Steve | last post by:
WIN2000 sp4, SQL2000 sp3 I created an alias on the local server for the SQL 2000 server installed there, I can view and modify most sql server properties using this alias, but when I attempt to...
1
by: KWilliams | last post by:
Hello, We are trying to set up replication between different versions of SQL Server (7 & 2000). This is how the 2 servers are now setup: DB1 - External web-server w/SQL Server 7 DB2 -...
1
by: Trent | last post by:
Hello,everyone. I'm setting a db2 replication environment using UDB version 8.1.5 running on Windows 2000 servers. The source server is on a Windows server with the capture program running while...
10
by: Daven Thrice | last post by:
I have a database that needs to be replicated over the Internet. I was hoping it would be a simple task, but apparently it is not. I've started browsing the msdn article on the topic. In the...
2
by: Danny J. Lesandrini | last post by:
I suspect this isn't possible, but I recently moved a app to SQL Server and it contains a Project table. Now I have a new CRM tool that needs to be mobile, but should also synch with the Project...
4
by: John | last post by:
Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards
1
by: Michael Swinarski | last post by:
I am working on setting up our new SQL Server 2005 servers. One of them will eventually be our Replication Distributor. However when I attempt to set this up within the wizard, I get the...
0
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged...
15
by: ingejg | last post by:
I am starting to study internet synchronization, and my head is still spinning since internet is not my forte, however my boss is breathing down my neck at the moment. Our company has only one...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.