SQL Mobile Query

On the paper:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

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)

------------------------------
BUTTONS:

OK


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)

Message
[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.

Comments

Jignesh Desai said…
Check out links at
http://207.46.248.238/msdn/showpost.aspx?postid=68707&siteid=1

and

http://www.jonathanmalek.com/blog/SQLServerServiceBrokerError15404Pain.aspx

Regards
Jignesh Desai

Popular posts from this blog

My family genealogy : Kurmi

How to report software piracy in India

Solving the multi-platform challenge in mobile devices