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

Anonymous 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
December 28, 2005 at 2:27:00 PM GMT+5:30
Post a Comment

Popular posts from this blog

Community Star Discussions and Future

In my continuing discussion with Community Stars across the country, I had a discussion today with Sadashiv. Though he works out of chennai and was here for a short trip, he found time today to discuss the opportunities for Community Star program to improve on. Some of thoughts we generated out of the discussion are as follows: 1. Community Stars are disengaged 'cause of lack of communication with them from MS. Better communication channels need to be developed. 2. Award experience and delivery of the Community Star benefits leave a lot to be desired. 3. Community Stars feel that MS is not laying enough importance on Community Stars and do not value their contributions much. More information needs to flow to CSs. From our end, we are doing the following: 1. Launch an extranet portal exclusively for Community Stars. We will host issue submission on this site. Also, we will share opportunities via this site e.g. beta opportunities 2. Re-launch the Community Star distributi
Read more

Making Vista Search your PST Files

Vista can index a lot of files and for some reason it doesn’t index the MS Outlook files.. maybe it is as Outlook is already doing the same.. in case you still want to search PST from Vista Search here is what you can do: Go to the Control Panel Choose "Indexing Options" Click on the "Advanced" button Click on the "File Types" tab Check the checkbox next to "PST" to include it in the search Select the bullet next to the option "Index Properties and File Contents" Click OK and OK again on the message that appears. This is especially useful for information workers like me who have large PST files and are forced to archive from time to time … indexing the archives would return the information from these forgotten folders as well :) Tip taken from On10.net Technorati tags: Outlook , PST , search
Read more

Technocratical Society

In the past days, I haven’t been blogging. A lot has happened in that time – terrorist attack in Mumbai, MNS lost track, global recession set in and Congress advanced in the country. Here’s an ode to the state of the society as viewed by my nephew, Shantanu Chandra who is in Class XII, Amity International, Gurgaon. The lines below capture the times prevailing and the need for us to drop the “chalta hai” attitude but with caution: This techie world of gizmo and gadget This eerie feeling of incongruous widget Which gives us pleasure and takes pain Along with it makes us insane; Absurdness to such a horizon from where one would never fall And still people call you “Microsoft—…That’s all” A teen like me can’t do without a mobile-call Even though I know it is killing my brain cells, after all; This techie world of gizmo and gadget Makes a non-techie guy weird and hollow The bureaucrat are more concerned about their Sunday meal Than to serve the poor people whose w
Read more