Re: merge replication error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Wed, 18 Aug 2004 05:21:03 -0700

So are you saying I should create a new user on the server named
"IUSER_BRIANP_DSK"? I thought I wouldn't need to do this because I am
logging in to the server with the "sa" user account, as shown in my dim
statement in vb.net

"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

  • Cookies & Camera Problem
    ... Yesterday I recently started recieving a message when ... logging onto hotornot.com saying that I have to have ... violation at address 0149BOC in module 'CamcapEX.dll' ...
    (microsoft.public.security)
  • No /var/log/messages File
    ... Most who are helping me with my Realtek NIC problem are saying to look ... command. ... after logging in I see no /var/log/messages file and thus ...
    (comp.os.minix)
  • Re: Group Policy Password controls
    ... Are you saying it can't be done or it shouldn't be done? ... "Danny Sanders" wrote: ... > will only take affect when logging on locally to a computer in that OU. ... >> Can the GP Password controls be applied at OUs below the domain level? ...
    (microsoft.public.windows.server.active_directory)
  • Re: bash v3 from Solaris 10 does not read bashrc
    ... Firstly I am logging in as root - appologies for not ... saying that in my original post. ...
    (comp.unix.solaris)
  • Re: CDE problem
    ... Are you saying you are not getting a login screen at all or are logging ... in but the CDE is not coming up? ... You will get a terminal window to work from. ...
    (comp.sys.hp.hpux)