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

118 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. But if you are a Hotmail user, I think Hotmail login account is the website you should bookmark, in case you have email problem or want to learn some helpful tips to use email more effectively.

    ReplyDelete
  8. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.

    data analytics courses

    business analytics course

    data science interview questions

    data science course in mumbai

    ReplyDelete
  9. This is a wonderful article. I really enjoyed reading this article. Thanks for sharing such detailed information.
    Data Science Course in Marathahalli
    Data Science Course Training in Bangalore

    ReplyDelete
  10. The concept has been explained very well. Gained clear knowledge about the prominence of AWS
    AWS Training in Hyderabad

    ReplyDelete
  11. The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea.
    Data Science Training In Hyderabad

    ReplyDelete
  12. This is the information that ive been looking for. Great insights & you have explained it really well. Thank you & looking forward for more of such valuable updates.
    Artificial Intelligence Training In Hyderabad

    Artificial Intelligence Course In Hyderabad

    ReplyDelete
  13. 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.

    data science course

    ReplyDelete
  14. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  15. You have explained the concept really well. Was looking for this information from a while & luckily I stumbled upon your post. Looking forward for more of such informative updates from you

    Data Science Training In Hyderabad
    Data Science Course In Hyderabad

    ReplyDelete
  16. I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.

    data science course

    ReplyDelete
  17. Good Article .we are sharing a such wonderful information
    AWS Training In Hyderabad

    ReplyDelete
  18. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
    data analytics course in Bangalore

    ReplyDelete
  19. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    data science course

    ReplyDelete
  20. 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.

    Correlation vs Covariance

    ReplyDelete
  21. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  22. I think about it is most required for making more on this get engaged
    Data Science Course in Bangalore

    ReplyDelete
  23. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work
    Data Science Training in Bangalore

    ReplyDelete
  24. Its as if you had a great grasp on the subject matter, but you forgot to include your readers. Perhaps you should think about this from more than one angle.
    Data Science Course in Bangalore

    ReplyDelete
  25. They're produced by the very best degree developers who will be distinguished for your polo dress creating. You'll find polo Ron Lauren inside exclusive array which include particular classes for men, women.
    Data Science Training in Bangalore

    ReplyDelete
  26. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression
    data science interview questions

    ReplyDelete
  27. Nice blog Post ! This post contains very informative and knowledgeable. Thanks for sharing the most valuable information.
    Data Science Training in Hyderabad

    ReplyDelete
  28. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

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

    Python Training in Hyderabad

    Best PythonTraining Institutes in Hyderabad

    ReplyDelete
  30. Thanks for sharing great information. I like your blog and highly recommend. We also offer best data science training in Hyderabaddata scientist courses

    ReplyDelete
  31. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.

    Data Science Training in Hyderabad

    ReplyDelete
  32. The concept has been explained very well. Gained clear knowledge about the prominence of AWS
    AWS Training in Hyderabad

    ReplyDelete
  33. 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.

    data science interview questions

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

    ReplyDelete
  35. 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
  36. The content is utmost interesting! I have completely enjoyed reading your points and have come to the conclusion that you are right about many of them. You are great,

    AI Training in Hyderabad

    ReplyDelete
  37. I am very happy to read this. This is the kind of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this best posting.

    Data Science Training in Hyderabad

    ReplyDelete
  38. If you don't mind, then continue this excellent work and expect more from your great blog posts
    artificial intelligence courses in delhi

    ReplyDelete
  39. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  40. 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

    ReplyDelete
  41. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data science course in hyderabad with placements

    ReplyDelete
  42. 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
  43. Buy online wholesale printed candle boxes and packaging at easy prices and shipping worldwide, with 24/7 customer support. Get a free custom quote now!!

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

    ReplyDelete
  45. 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
  46. Blackbird packaging provide you with any size, shape design, cbd vape oil cartridge boxes sooner than any other packaging competitor in the market

    ReplyDelete
  47. Great Article
    Cloud Computing Projects




    Networking Projects



    Final Year

    Projects for CSE





    JavaScript Training in Chennai



    JavaScript

    Training in Chennai




    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals,

    Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer.

    Angular Training

    ReplyDelete
  48. 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
  49. 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
  50. 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
  51. 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.
    best online data science courses

    ReplyDelete
  52. Very informative content and intresting blog post.Data science course in Nashik

    ReplyDelete
  53. Thanks for posting the best information and the blog is very informative.Data science course in Faridabad

    ReplyDelete
  54. Blackbird packaging provide you with any size, shape design, cbd bath bombs wholesale sooner than any other packaging competitor in the market

    ReplyDelete
  55. Thanks for posting the best information and the blog is very informative.Data science course in Faridabad

    ReplyDelete
  56. 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
  57. 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
  58. Thanks for posting the best information and the blog is very helpful.Data science course in Varanasi

    ReplyDelete
  59. I Want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging endeavors.
    business analytics course in bangalore

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

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

    ReplyDelete
  62. 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
  63. Blackbird packaging provide you with any size, shape design, essential oil packaging boxes sooner than any other packaging competitor in the market

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

    ReplyDelete
  65. Blackbird packaging provide you with any size, shape design, custom bottle neckers wholesale sooner than any other packaging competitor in the market

    ReplyDelete
  66. Thanks for posting the best information and the blog is very helpful.data science institutes in hyderabad

    ReplyDelete
  67. Really wonderful blog completely enjoyed reading and learning to gain the vast knowledge. Eventually, this blog helps in developing certain skills which in turn helpful in implementing those skills. Thanking the blogger for delivering such a beautiful content and keep posting the contents in upcoming days.

    data science training institute in bangalore

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

    ReplyDelete
  69. Blackbird packaging provide you with any size, shape design, custom bath bomb boxes sooner than any other packaging competitor in the market

    ReplyDelete
  70. Blackbird packaging provide you with any size, shape design, wholesale cookie boxes sooner than any other packaging competitor in the market

    ReplyDelete
  71. There is obviously a lot to know about this. I think you made some good points in Features also. Keep working, great job!
    data scientist training and placement in hyderabad

    ReplyDelete
  72. Blackbird packaging provide you with any size, shape design, cookie box packaging sooner than any other packaging competitor in the market

    ReplyDelete
  73. Thanks for posting the best information and the blog is very helpful.artificial intelligence course in hyderabad

    ReplyDelete
  74. Thanks for posting the best information and the blog is very important.digital marketing institute in hyderabad

    ReplyDelete
  75. This is a wonderful article. Given so much info in it, These types of articles keep the users interested in the website, and keep on sharing more ... good luck
    data scientist training in hyderabad

    ReplyDelete
  76. Impressive blog to be honest definitely this post will inspire many more upcoming aspirants. Eventually, this makes the participants to experience and innovate themselves through knowledge wise by visiting this kind of a blog. Once again excellent job keep inspiring with your cool stuff.

    data science certification in bangalore

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

    ReplyDelete
  78. Thanks for posting the best information and the blog is very important.digital marketing institute in hyderabad

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

    ReplyDelete
  80. Thanks for posting the best information and the blog is very important.data science institutes in hyderabad

    ReplyDelete
  81. Terrific post thoroughly enjoyed reading the blog and more over found to be the tremendous one. In fact, educating the participants with it's amazing content. Hope you share the similar content consecutively.

    data science course in varanasi

    ReplyDelete
  82. 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
  83. Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.

    data science course in faridabad

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

    ReplyDelete
  85. 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. data scientist course in delhi

    ReplyDelete

  86. Great to become visiting your weblog once more, it has been a very long time for me. Pleasantly this article i've been sat tight fosuch a long time. I will require this post to add up to my task in the school, and it has identical subject along with your review. Much appreciated, great offer. data science course in nagpur

    ReplyDelete
  87. Thanks for bringing such innovative content which truly attracts the readers towards you. Certainly, your blog competes with your co-bloggers to come up with the newly updated info. Finally, kudos to you.

    Data Science Course in Varanasi

    ReplyDelete
  88. I will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more.
    data scientist course in hyderabad

    ReplyDelete
  89. Thanks for posting the best information and the blog is very good.data science course in Lucknow

    ReplyDelete
  90. Thanks for posting the best information and the blog is very good.artificial intelligence course in hyderabad

    ReplyDelete
  91. I really enjoyed this blog. It's an informative topic. It helps me very much to solve some problems. Its opportunities are so fantastic and the working style so speedy.
    data scientist training and placement in hyderabad

    ReplyDelete