Re: merge replication error

From: Benjamin (Benjamin_at_discussions.microsoft.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 05:35:02 -0700

Alright I added the IUser account to have access to the publication and
Everyone has full rights to the snapshot share, but it is still giving me the
same error. Along with the original error message I also get the error code
of: 80045901 and minor error code of: 29045

any ideas?

"mgarner1980" wrote:

> right click on your publication and make sure that the anonymous login user
> for your IIS is in the PAL. Also make sure that the same is true for your
> snapshot folder permissions as well.
> "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
> news:D0B4C4D7-DD05-4FA4-8223-C63BC15B94DE@microsoft.com...
> > I have fixed the snapshot problem, but I am still recieving the same error
> > when I try and sync the database. Any ideas?
> >
> > ""Brad Syputa - MS"" wrote:
> >
> > > Hi Brian,
> > >
> > > You can change the snapshot path to a non admin share. Something like
> > > \\brianp_dsk\snapshot will work. Then, for now, give everyone privileges
> to
> > > the share. Later, you can add specific permissions and users. Using the
> > > Admin share c$ for the snapshot makes it hard to configure security
> > > correctly.
> > >
> > > To change the snapshot share, I believe you can right click your
> > > publication and choose properties. There should be an option to use an
> > > alternate snapshot share.
> > >
> > >
> > > --------------------
> > > | Thread-Topic: merge replication error
> > > | thread-index: AcSEdr/1EFB6AvO8QZutSCx5aPnjAA==
> > > | X-WBNR-Posting-Host: 134.29.222.205
> > > | From: "=?Utf-8?B?QmVuamFtaW4=?=" <Benjamin@discussions.microsoft.com>
> > > | Subject: merge replication error
> > > | Date: Tue, 17 Aug 2004 09:25:03 -0700
> > > | Lines: 67
> > > | Message-ID: <5D2FDF4E-1F36-4F73-9CB8-3CF3769DB9A7@microsoft.com>
> > > | MIME-Version: 1.0
> > > | Content-Type: text/plain;
> > > | charset="Utf-8"
> > > | Content-Transfer-Encoding: 8bit
> > > | X-Newsreader: Microsoft CDO for Windows 2000
> > > | Content-Class: urn:content-classes:message
> > > | Importance: normal
> > > | Priority: normal
> > > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> > > | Newsgroups: microsoft.public.sqlserver.ce
> > > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> > > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
> > > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:13147
> > > | X-Tomcat-NG: microsoft.public.sqlserver.ce
> > > |
> > > | I am having problems setting up a way to replicate data from my pocket
> pc
> > > sql
> > > | database to sql server 2000 enterprise. I have set up a replication
> on
> > > the
> > > | server I think I have done it right, the only thing I am wondering
> about
> > > is a
> > > | message I get when I try and set the location of the snapshot folder.
> > > This
> > > | is the message that is displayed:
> > > | "The snapshot folder path, '\\BRIANP_DSK\C$\Program Files\Microsoft
> SQL
> > > | Server\MSSQL\ReplData', uses a special share name which can usually be
> > > | accessed only by a login with administrative priviliges on computer
> > > | 'BRIANP_DSK". This share may not be accessible by agents running on
> > > other
> > > | computers, such as the agents for pull subscriptions.
> > > |
> > > | I say ok the the message but I am not sure if that is what is causing
> the
> > > | problem with the sync. I have set up a subscription and I think that
> is
> > > all
> > > | I have done. I have named both the table on the pocket pc and the
> table
> > > on
> > > | the server StudentTbl. My question here is if the same name is what
> > > could be
> > > | causing the problem.
> > > |
> > > | Finally down to the error I am getting when I try to sync. The reason
> it
> > > is
> > > | so frustrating is because the error message is completely
> > > non-descriptive,
> > > | here it is:
> > > |
> > > | Initializing SQL Server Reconciler has failed [,,,,,]
> > > |
> > > | I have absolutly no Idea what this error means. The code I am using to
> > > sync
> > > | is written in vb.net here is what it looks like:
> > > |
> > > | 'Create a new instance of the SqlCeReplication class
> > > | Dim rep As SqlCeReplication = New
> > > | SqlCeReplication("http://134.29.222.205/medic/sscesa20.dll", "", "",
> > > | "BRIANP_DSK", "Medic", "sa", "pass", "Medic", "MedicSubscribers",
> "Data
> > > | Source = \My Documents\Test.sdf")
> > > |
> > > | Try
> > > |
> > > | ' Check if the database file already exists
> > > | If (Not System.IO.File.Exists("\My Documents\Test.sdf"))
> Then
> > > |
> > > | ' Add a new subscripton and create the local database
> file
> > > | rep.AddSubscription(AddOption.CreateDatabase)
> > > | 'rep.AddSubscription(AddOption.ExistingDatabase)
> > > | End If
> > > | ' Transfer the initial snapshot of data if this is the
> first
> > > | ' time is this called. Subsequent calls will transfer only
> the
> > > | ' changes to the data
> > > | rep.Synchronize()
> > > |
> > > | Catch ex As SqlCeException
> > > | ShowErrors(ex)
> > > | ' Display any errors in a message box
> > > | MessageBox.Show(ex.Message)
> > > |
> > > | Finally
> > > |
> > > | ' Dispose of the SqlCeReplication object, but donÃ,Â't
> drop
> > > the
> > > | ' subscription
> > > | rep.Dispose()
> > > | ' Notify the user that merge replication is complete
> > > | MessageBox.Show("Replication complete")
> > > |
> > > | End Try
> > > |
> > > | can anyone help me out with this problem. I have been looking at
> > > | walkthroughs for setting up replication. I am able to view my IIS
> page
> > > from
> > > | the pocket pc so I know that the connection is working. Any ideas
> would
> > > be
> > > | greatly appreciated.
> > > |
> > > |
> > > |
> > >
> > >
>
>
>

Relevant Pages

  • Re: New DTrace source snapshot
    ... A number of things were missing from the dtrace kernel ... This is a snapshot of current which contains lock order ... This snapshot extends the basic OpenSolaris DTrace functionality ... *** Error code 1 ...
    (freebsd-current)
  • Re: New DTrace source snapshot
    ... A number of things were missing from the dtrace kernel ... This is a snapshot of current which contains lock order ... will fail to build when hosted on RELENG_6. ... *** Error code 1 ...
    (freebsd-current)
  • problem on ath code - current from yesterday
    ... when trying to compile from source, this is the nov snapshot from current, ... I got this twice: ... *** Error code 1 ... We will call you cygnus, ...
    (freebsd-current)
  • Re: patch for zoneinfo to make release
    ... > This will be fixed in a new version of tzdata which should be imported ... It looks like my snapshot release box is still not happy with it: ... *** Error code 1 ... John ...
    (freebsd-current)
  • Re: Log wont Truncate when Publication is created
    ... deleted the publication, I first deleted the subscription. ... recreating the snapshot publication. ... database is almost completely rebuilt with each update, ...
    (microsoft.public.sqlserver.replication)