find a location for property in a new city

Monday 28 November 2011

Service 'SQL Azure Data Sync Preview' failed to start

While trying to install and start the SQL Azure Data Sync Preview Service I ran across the error message "Service 'SQL Azure Data Sync Preview' (SQL Azure Data Sync Preview) failed to start. Verify that you have sufficient privileges to start system services." Here are the step I had to take to make it start working.

You have to get all of these right to be able to install and start the service successfully. Most are not very obvious and the final step I seem to be the only person on the internet with this problem (hence the blog post)! Anyway, here goes:

Get your username and domain right

Although it says you can enter the account with examples of "domain\user, .\localuser", you can't; it is a lie! You should ensure that you fill out the "User Name" field like MACHINENAME\Username. So MYMACHINE\Colin if you were me.

Verify you have sufficient permissions

Your user may not have permission to log in to Windows Services so you need to make sure you can.

Go to:

  • Control Panel > Administrative Tools > Local Security Policy
  • Open Local Policies > User Rights Assignment
  • Click on Log on as a service
  • Click "Add User or Group..."
  • Set location to your machine
  • Type your user name into the box and click OK then Apply

Ensure you have a password

This was the problem I ran into. The installation just didn't seem to complete because my Windows user did not have a password. I Ctrl + Alt + Del > Change password. I gave myself an actual password rather than leaving it blank which I had done in the past. It then installed without a hitch.

Conclusion

So quite a few snags you may run into when installing the Data Sync service but hopefully with my little check list it wont take you as long as it took me. I'm guessing these sort of bits are just a symptom of the service being in Preview not RTM so they are understandable really.

For what it's worth the preview of SQL Azure Data Sync is a great service, installing this Windows Service was the only issue I had in an otherwise simple process. The benefits of using the service are great, you can sync multiple databases both inside or outside of the Azure data centres. You will only get charged for data leaving the data centre too so any SQL Azure to SQL Azure synchronisation within the same data centre is free! Well, free for now anyway since it is still in preview so I'd keep an eye out when it becomes production ready. Happy syncing!

Follow britishdev on Twitter

41 comments:

  1. Thanks for the information. I did not have a password, so I created one and the installation went through. Thanks again!

    ReplyDelete
  2. Rat Control in Southall - Pest & Vermin Control Services in Southall

    ReplyDelete
  3. Information Scientists taking quite a while and need to put a great deal of exertion for setting up their expository surroundings. ExcelR Data Science Courses

    ReplyDelete
  4. Hi there! This article could not be written any better! Reading through this post reminds me of my previous roommate! He continually kept preaching about this. I'll forward this post to him. Pretty sure he'll have a very good read. Thank you for sharing! onsite mobile repair bangalore Howdy, I think your blog may be having internet browser compatibility issues. When I take a look at your site in Safari, it looks fine however, when opening in IE, it's got some overlapping issues. I just wanted to give you a quick heads up! Aside from that, excellent site! asus display repair bangalore Having read this I believed it was extremely informative. I appreciate you finding the time and energy to put this content together. I once again find myself personally spending a significant amount of time both reading and leaving comments. But so what, it was still worth it! huawei display repair bangalore

    ReplyDelete
  5. Good day! I could have sworn I’ve visited this web site before but after browsing through many of the posts I realized it’s new to me. Regardless, I’m definitely happy I discovered it and I’ll be bookmarking it and checking back often! online laptop repair center bangalore I want to to thank you for this good read!! I definitely enjoyed every little bit of it. I've got you book-marked to look at new stuff you post… dell repair center bangalore

    ReplyDelete
  6. Hi, I do think this is a great site. I stumbledupon it ;) I'm going to revisit once again since i have saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to help others. macbook repair center bangalore Your style is unique in comparison to other people I've read stuff from. Thanks for posting when you've got the opportunity, Guess I'll just book mark this site. acer repair center bangalore

    ReplyDelete
  7. Great blog!!! It is very impressive... thanks for sharing with us...keep posting.

    Python Training in Hyderabad

    Best PythonTraining Institutes in Hyderabad

    ReplyDelete
  8. Wholesale printed custom perfume boxes with the highest quality and affordable prices. Free worldwide Delivery and free Custom Perfume Boxes design.

    ReplyDelete
  9. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    Simple Linear Regression

    Correlation vs covariance

    KNN Algorithm


    ReplyDelete
  10. Buy online wholesale custom eyeshadow palette packaging and packaging at seashore packaging at the easy price Free shipping worldwide with 24/7 customer support.

    ReplyDelete
  11. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing.
    Data Analyst Course

    ReplyDelete
  12. Blackbird packaging provide you with any size, shape design, cbd vape oil cartridge boxes sooner than any other packaging competitor in the market

    ReplyDelete
  13. ExcelR provides data scientist course in pune with placement. It is a great platform for those who want to learn and become a data scientist. Students are tutored by professionals who have a degree in a particular topic. It is a great opportunity to learn and grow.

    data scientist course in pune with placement
    Data science courses
    Data scientist certification
    Data scientist courses

    ReplyDelete
  14. I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.
    data science course

    ReplyDelete
  15. I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.
    data science online course

    ReplyDelete
  16. Packaging town is a one stop solution for the short-run custom beverage packaging needs and supplies. At affordable prices. Request a free quote now.

    ReplyDelete
  17. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. ExcelR Data Analytics Course Any way I’ll be subscribing to your feed and I hope you post again soon. Big thanks for the use

    ReplyDelete
  18. buy electronics online in lahore from alfatah at best prices. Get free shipping

    ReplyDelete
  19. buy men zipper hoodie online from wild goat clothing at best pricces. Get Free shipping

    ReplyDelete
  20. Shop for the leading trends in Men's Jogger Pants online. Buy the best quality Men's Jogger and Sweat Pants from Wild Goat. Shop for finest Men's Jogger Pants, Sweat Pants and Trousers at affordable rates. Style your Gym Look in Wild Goat's Jogger and Sweat pants the way you want. Shipping available all across Pakistan.

    ReplyDelete
  21. buy water dispenser online from Al-Fatah at best prices. Get Free shipping

    ReplyDelete
  22. buy exercise cycles online from Al-Fatah at best prices. Get free shipping

    ReplyDelete
  23. buy baby food online from medisense at easy prices delivered at your doorstep. get free shipping

    ReplyDelete
  24. Buy mens gym bottoms from dshred at easy prices delivered at your doorstep. get free shipping

    ReplyDelete
  25. The best trousers are in town only at Ndure. Log onto our site or visit our stores to get your hands on the best trousers for women suitable for all occasions. Each trouser is manufactured keeping in mind comfort, luxury, and ease, casual hangouts. Ndure’s trousers for women are the key to every day comfortability.

    ReplyDelete
  26. Buy t-shirts online from ndure at best prices delivered at your doorstep. Get free shipping

    ReplyDelete
  27. I have checked this link this is really important for the people to get benefit from. data science training in mysore

    ReplyDelete
  28. I would also motivate just about every person to save this web page for any favorite assistance to assist posted the appearance. data science course in mysore

    ReplyDelete
  29. Wonderful blog post. This is absolute magic from you! I have never seen a more wonderful post than this one. You've really made my day today with this. I hope you keep this up! data scientist course in kanpur

    ReplyDelete
  30. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.business analytics course in warangal

    ReplyDelete
  31. cool stuff you have and you keep overhaul every one of us data scientist course in mysore

    ReplyDelete
  32. Hackett London imported quality products are available online at Enem Mall. Now you can get Hackett London Product Prices, Hackett London Products Reviews and Hackett London Products Specifications. Buy Latest Range of Hackett London Products An Enem Mall.

    ReplyDelete
  33. We need to look into it more closely. Download suoneriemp3gratis for free great ringtones

    ReplyDelete
  34. A single person cannot do the entire job of a data analyst; it requires multiple people to divide the task between them for getting a quick decision.

    ReplyDelete
  35. Data Science is a dynamic domain with a promising future, start your Data Science Course today with 360DigiTMG and become a Data Scientist without hassle.
    best data science courses in chennai

    ReplyDelete
  36. descargue los últimos tonos de llamada gratis 2022 aquí hay miles de música nueva actualizada diariamente y son de uso completamente gratuito

    ReplyDelete

  37. It’s super powerful content. I have been aware of your stuff previously and you’re just too fantastic. I really like what you have got here. Thanks so much for sharing. fce kano pgde admission list

    ReplyDelete