Replication -- New Subscription Wizard SQL Mobile error, please help..

I'm following the steps of sample SQL Server Mobile Tutorials..
error on my replication subscription wizard :

"Initialiazing 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 syncronization.
HRESULT 0x80045003 (0)"

error while waiting synchronizing Data in New Subcription Wizard!!
anyone can help?how to solve this problem?the error says the snapshot wasn't available. Did you create the snapshot already?|||of course I did create the snapshot (I succeed create publication on database engine), like I said..I exactly followed the instruction from the SQL Server Mobile tutorial (MSDN Help).
but when I came to New Subscription Wizard step, It fail to synchronize.

please help me "_"|||

Hi feby,

Check and do the following:

1) Open SQL Server 2005 Management Studio

2) In Object Explorer; expand Replication ==> Publications Tab

3) Right Click on the publication you are interested to subscribe to

4) Choose 'View Snapshot Agent Status'

5) Make sure that 'Snapshot is 100% generated'. If it is already, regenerate again!

Just finishing 'New Publication Wizard' does not complete generation of snapshot. When you complete the above wizard, a snapshot agent job is created + started. Please make sure that the snapshot agent job is completed with 100% with above 'View Snapshot Agent Status'.

If you are getting some errors in generating snapshot, check the credentials of snapshot agent and make sure that snapshot (share or folder) has write security permissions for that user.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

[Please move this thread to SQL Server Mobile forum]

|||Hi there
I've got the same problem: I can't generate the snapshot.
ErrorMessage:
The replication agent failed to create the directory '\\<pcname>\snapshot\unc\<pcname>_SQLMOBILE_SQLMOBILEPUBLICATION\20060426091803\'.

I 've set the security permission for the snapshot folder according to the tutorial:
http://msdn2.microsoft.com/en-us/library/ms171908.aspx
for both users (just to make sure)

What i am unsure of, is why they create 2 users: the snapshot_agent (for the snapshot folder) an the IUSR_pcname (for securing the publication)
Which user is doing what and are they related to each other?

According to the MS tutorial (securing Publication step 6) you should see the IUSR in this list, well I couldn't see that user until I gave him the db_owner role, so is that correct, does that user need more roles?
Well I couldn't retrieve the publication, so I added the snapshot_agent user in step 6 an received the errormessage above.

I would be glad, if anyone could help me!
Thanks
Florian Weber, University of Computerscience, Rapperswil, Switzerland

|||Hi
well it seems clearer now, the snapshot_agent is for acessing the snapshot folder an the IUSR_pcname for the anonymous accessing over the IIS.
I also reconfigured the login accounts according to the tutorial.

Unfortunately I still receive the error message that the replication agent fails to create the directory for the snapshot.
The sharing and security settings should be right (write access for the snapshot_agent and the IUSR_pcname)

Has anyone an idea what could be the problem?

Another thing which I am not sure is if the snapshot directory must be the same directory as the virtual directory of the IIS (well I suppose so, because I should access the snapshot from a mobile sql database)

Florian Weber, University of Computerscience, Rapperswil, Switzerland|||

Hi, it looks like you don't have the write permission to the snapshot share. you can find the what is the snapshot folder by running sp_helpdistributor or from the UI to check the publisher's properties.

you will need to give the accout that run the snapshot agent the write permission to this folder.

thanks

yunwen

|||Hi Yunwen
firstly thanks for your fast reply!
I've checked the publisher's properties and the permissions, the account does have the write permission. I even tried to use the admininstrator account, still the same problem.

In my desperation i tried it on another machine and surprisingly it was running perfectly. So it seems that I have some kind of configuration problem with windows on my machine. I think I have to set it up and try it again.
At least I know now how it's working. so thank you!

Greets Florian
|||now my replication & agent are running, but when I deployed the sample program from the tutorial it shows error "Could not connect the database server through IIS" (or error something like that).
I have VS2003 installed on my computer. after my replication running,
I can't create new web project from VS2003. it say : "The Web server reported the following error when attemping to create or open the Web project located at the following URL 'http://localhost/WebApplication'. 'A connection with the server could not be established'."
(like tag IMG below "http://img142.imageshack.us/img142/5429/errorestablished3ma.jpg") any idea why it happen?coz before adjusting replication I can create project, I tried make a virtual directory but it doesn't help (all I know the IIS is still running)|||any body here?|||

i have the exactly same problem and i just have made a clean install i have formated the hard drive but i still having that problem

any advise for solving it?

|||It seem my shared folder can't be accessed, it say about permission!but the strange is..when I plug my LAN cable, that share folder can be accessed!!any clue?|||

Seems like we are all having the same problem. I need to run LAN and Web Sync, so I am using RMO to build out the LAN system now. I have permissions for the share and system at full for testing. When the pull subscription is created from the subscriber machine the subscription is left uninitialized the only feedback I have is a failure to create a new snapshot directory.

Event Type: Error
Event Source: <MS SQL SERVER 2005 Instance Name>

Event Category: (2)
Event ID: 14151
Date: 9/20/2006
Time: 10:31:15 AM
User: N/A
Computer: <MS Windows Server 2003 Machine Name>
Description:
Replication-Replication Snapshot Subsystem: agent <merge replication snapshot agent name> failed.

The replication agent had encountered an exception.

Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
Exception Message: The replication agent failed to create the directory <new sub directory name within replication shared directory>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.