SQL Mobile Query

On the paper:

While trying to complete the exercise, I encountered the following unexpected behaviour:

While configuring the subscription for the SQL Mobile (from the tutorial – To complete the subscription) section, I encountered the following error –

TITLE: Microsoft SQL Server Management Studio

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)



So I confirmed that the SQL Server Agent is running, went to the publication, right clicked and clicked on “View Snapshot Status”. The result is “The agent has never been run.” Even when I Click on Start, it starts to run the agent but terminates with the same message as mentioned before.

The SQL server Agent runs under “NetworkService” account. I have tried changing the Agent Security (on Publication properties) to specifying my network credentials explicitly as well with no success..

On checking the SQL Server Agent logs, following error is reported:
ate 12/21/2005 5:20:02 PM
Log SQL Agent (Current - 12/21/2005 5:20:00 PM)

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'xxxxx\xxxxx', error code 0xea. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

Any help?
This posting is provided "AS IS" with no warranties, and confers no rights.


Anonymous said…
Check out links at



Jignesh Desai

Popular posts from this blog

Community Star Discussions and Future

Technocratical Society

Making Vista Search your PST Files