Re: Problem with creating new Subscription.

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

The error indicates that there is not a valid snapshot on the
publisher. From within SQL Server 2005 Management Studio,
right click on the Replication node for your publication and
select 'View Snapshot Agent Status'. Then click on the Monitor
button and see if the SQL Agent reported any errors generating
the snapshot.

A common mistake here is not granting the IIS default user
(IUSR_{yourservername}) permissions on the publication
and the published databases.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com


"Shahin" <Shahin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F960A550-9436-41ED-ACDE-E881107E6A0C@xxxxxxxxxxxxxxxx
> Hi,
> Iam new with SQL 2005, iam trying in the lab to create a mobile
> Application
> with SQL mobile,i was used the SQL server mobile Tutorials, every thing
> want
> fine but
> When i try to create new subscription in SQL 2005 i reciecve this Error:
> Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
>
> The initial snapshot for publication 'SQLMobile' 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)
>
> Any idea?
>
> Thanks,
>
> Shahin.


.

Quantcast