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

Notes from an Internet Marketing Seminar

These are my notes from an internet marketing seminar I attended. Read through to see if you can figure out who delivered this and i promise you would be surprised :) Topic: Web & New Media: Emerging Trends 183 bn emails sent a day 49 mn internet users in India 7.5 hrs spent on internet/ week (18-35 Males) 1.2 bn searches / month- search increasing at 80% 80% online shop Online Time Spent in India: 23% – TV 30% Internet 26% Print 21 % Radio Advertising Money Spent: 41% TV 1% Internet 40% Print 12% Radio 1.4 bn online out of 6.6 bn in the world mobile is the next huge thing... computing cloud is the current stage after PC being personal era.. web is not US centric.. 211 still the largest.. inspite of the company being so "open source".. the presentation consistently says Confidential & PROPRIETARY .. paradoxical.. the presentation laptop from google is running Windows XP.. sweet.. and oh! the presenta...
Read more

Solving the multi-platform challenge in mobile devices

Image
The writing is on the wall is clear with mobile devices becoming mainstream business devices. In addition to the current workhorse – the PC, consumers and businesses are adopting internet connected smartphones and tablets in record numbers. The path for mobile device enablement for businesses is fragmented and full of challenging decisions. This starts from mobile application landscape being multi-platform and multi-resolution. While Android uses Java, iOS uses Objective-C, Windows Phones use .NET. Natively hitting all of these environments requires one to build multiple versions of an app and to learn multiple technology platforms. New challenges also open up with the client devices in deliver visualizations and touch enablement. How to work with multi-platform challenge Fortunately there exists a solution to this madness in HTML 5. This stack takes advantage of browser based technologies and hence can run on all of the major mobile platforms as well as desktop platforms. However, th...
Read more