[2005 beta 2] merge replication sql server to sql server mobile

Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo
You will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ################################################## ######################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ################################################## ######################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo
|||Hi Diemo
I am facing the same problem...check the newsgroup and could not find any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.

Quote:

Originally posted by dieweb
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo