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!
Thanks for the information. I did not have a password, so I created one and the installation went through. Thanks again!
ReplyDeleteAvriq
ReplyDeleteAvriq
Avriq USA
CCTV Camera
PC Optimization
Pest control services
CP Plus
Termite control services
Amazing Information. I really Like it.Mobilism
ReplyDeletesimcity buildit mod apk
dead trigger mod apk
I love your publications.
ReplyDeleteanal fuck
Rat Control in Southall - Pest & Vermin Control Services in Southall
ReplyDeleteInformation Scientists taking quite a while and need to put a great deal of exertion for setting up their expository surroundings. ExcelR Data Science Courses
ReplyDeleteHi 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
ReplyDeleteGood 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
ReplyDeleteHi, 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
ReplyDeleteDigital Marketing Services in delhi
ReplyDeleteseo services in delhi
web development services in delhi
content marketing services in delhi
ppc services in delhi
Website Designing services in delhi
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.
ReplyDeleteAfter 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.
ReplyDeletedata analytics courses
business analytics course
data science interview questions
data science course in mumbai
This is a wonderful article. I really enjoyed reading this article. Thanks for sharing such detailed information.
ReplyDeleteData Science Course in Marathahalli
Data Science Course Training in Bangalore
The concept has been explained very well. Gained clear knowledge about the prominence of AWS
ReplyDeleteAWS Training in Hyderabad
The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea.
ReplyDeleteData Science Training In Hyderabad
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.
ReplyDeleteArtificial Intelligence Training In Hyderabad
Artificial Intelligence Course In Hyderabad
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.
ReplyDeletedata science course
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.
ReplyDeleteData Science Course
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
ReplyDeleteData Science Training In Hyderabad
Data Science Course In Hyderabad
I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.
ReplyDeletedata science course
Thank you sharing such wonderful Articles
ReplyDeleteAI Training In Hyderabad
Good Article .we are sharing a such wonderful information
ReplyDeleteAWS Training In Hyderabad
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.
ReplyDeletedata analytics course in Bangalore
I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
ReplyDeletedata science course
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.
ReplyDeleteCorrelation vs Covariance
Excellent article useful to all the aspirants
ReplyDeleteDevOps Training in Hyderabad
DevOps Course in Hyderabad
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.
ReplyDeleteCorrelation vs Covariance
Simple linear regression
I think about it is most required for making more on this get engaged
ReplyDeleteData Science Course in Bangalore
We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work
ReplyDeleteData Science Training in Bangalore
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.
ReplyDeleteData Science Course in Bangalore
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.
ReplyDeleteData Science Training in Bangalore
Hi, Thanks for sharing wonderful articles...
ReplyDeleteAI Training In Hyderabad
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.
ReplyDeleteCorrelation vs Covariance
Simple linear regression
data science interview questions
Nice blog Post ! This post contains very informative and knowledgeable. Thanks for sharing the most valuable information.
ReplyDeleteData Science Training in Hyderabad
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.
ReplyDeleteData 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..
Excellent article useful to all the aspirants.
ReplyDeleteDevOps Course Training in Hyderabad
Best DevOps Course Training in Hyderabad
Hi, Thanks for sharing nice articles...
ReplyDeleteData Science Training in Hyderabad
Great blog!!! It is very impressive... thanks for sharing with us...keep posting.
ReplyDeletePython Training in Hyderabad
Best PythonTraining Institutes in Hyderabad
Thanks for sharing great information. I like your blog and highly recommend. We also offer best data science training in Hyderabaddata scientist courses
ReplyDeleteVery 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.
ReplyDeleteData Science Training in Hyderabad
The concept has been explained very well. Gained clear knowledge about the prominence of AWS
ReplyDeleteAWS Training in Hyderabad
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.
ReplyDeletedata science interview questions
Wholesale printed custom perfume boxes with the highest quality and affordable prices. Free worldwide Delivery and free Custom Perfume Boxes design.
ReplyDeleteThis 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.
ReplyDeleteSimple Linear Regression
Correlation vs covariance
KNN Algorithm
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,
ReplyDeleteAI Training in Hyderabad
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.
ReplyDeleteData Science Training in Hyderabad
If you don't mind, then continue this excellent work and expect more from your great blog posts
ReplyDeleteartificial intelligence courses in delhi
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.
ReplyDeleteCorrelation vs Covariance
Simple Linear Regression
data science interview questions
KNN Algorithm
Logistic Regression explained
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.
ReplyDeleteSimple Linear Regression
Correlation vs Covariance
This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data science course in hyderabad with placements
ReplyDeleteBuy online wholesale custom eyeshadow palette packaging and packaging at seashore packaging at the easy price Free shipping worldwide with 24/7 customer support.
ReplyDeleteBuy online wholesale printed candle boxes and packaging at easy prices and shipping worldwide, with 24/7 customer support. Get a free custom quote now!!
ReplyDeleteBlackbird packaging provide you with any size, shape design, cbd boxes sooner than any other packaging competitor in the market
ReplyDeleteThrough 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.
ReplyDeleteData Analyst Course
Blackbird packaging provide you with any size, shape design, cbd vape oil cartridge boxes sooner than any other packaging competitor in the market
ReplyDeleteGreat Article
ReplyDeleteCloud 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
This blog gives worthy information to me. Thanks for sharing a useful blog.
ReplyDeletesoftware testing skills
robotic process automation in banking
programming languages for data science
why php is used in web development
interview questions on digital marketing
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.
ReplyDeletedata scientist course in pune with placement
Data science courses
Data scientist certification
Data scientist courses
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.
ReplyDeletedata science course
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.
ReplyDeletedata science online course
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.
ReplyDeletebest online data science courses
Very informative content and intresting blog post.Data science course in Nashik
ReplyDeletevery informative blog
ReplyDeletedata science training in Pune
Very informative content and intresting blog post.Data science course in Thiruvananthapuram
ReplyDeletevery informative blog
ReplyDeletedata analytics training in Pune
Thanks for posting the best information and the blog is very informative.Data science course in Faridabad
ReplyDeletevery informative blog
ReplyDeletedata science training in Patna
Informative blog
ReplyDeletedata analytics training in Patna
Blackbird packaging provide you with any size, shape design, cbd bath bombs wholesale sooner than any other packaging competitor in the market
ReplyDeleteThanks for posting the best information and the blog is very informative.Data science course in Faridabad
ReplyDelete
ReplyDeleteNice Blog. Thanks for Sharing this useful information...
Data science training in chennai
Data science course in chennai