Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / July 2004

Tip: Looking for answers? Try searching our database.

fail to configure my server for replication

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ref - 30 Jun 2004 09:52 GMT
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
Steven Parsons [MSFT] - 20 Jul 2004 18:59 GMT
Hi  -

This is Steven from Microsoft Access Technical Support replying to your
newsgroup post.

You may get the help you need if you post your question on Microsoft SQL
Server newsgroup, instead of Microsoft Access. Please see:

   microsoft.public.sqlserver.replication

Please let me know if this solves your problem or if you would like further
assistance. I look forward to hearing from you.

Sincerely,
Steven Parsons [MSFT]
Microsoft Access Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! (http://www.microsoft.com/security)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.