Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL Server 2014 : Creating a Sysadmin Using a Windows 8.1 Account

Saturday, May 29, 2021

SQL Server 2014 : Creating a Sysadmin Using a Windows 8.1 Account

The one of thing that Windows 8 forces you to do is to sign in with an e-mail account.  I am not here to debate if it's a good thing or a bad thing.  But I just wanted to say, Microsoft why do you make our lives so complicated.  I just wanted Windows 7 with a touchscreen.  I digress :(   Anyways, if you install SQL Server on Windows 8 there is a little quirk that you have to deal with.  When you search for an account to add to your dba user login, you have to search on the entire username including the stuff after the @ sign.  Once again, I digress :(

Anyways here is how you add a dba to SQL Server 2014 on a Windows 8 machine.

1.  Connect to your instance of SQL Server, then expand the "Logins" node




2. Right click on "Logins" node, and then select "New Login"


3. Click on the "Search" button


4. Type in the account you want to add in the "Enter the object name to select" text box.  That is my e-mail, feel free to e-mail me.  The only gripe I have with this whole process is that, before we were able to do a partial search.  For example I could have just typed in "tech.junkie.jh" and SQL Server would be smart enough to figure out I am close enough.  Now I have to type in the whole account.  It feels like Microsoft is moving backward.  Anyways click on "Check Names"




5.  On the left hand side you will see a navigation panel, that says "Select a page", you want to select "Server Roles".  Check everything, and the kitchen sink.
  

6. Click "OK" then you have yourself another sysadmin, or what we like to call a db god.  DB God:  I shall grant you INSERT if you bring me donuts and coffee in the morning.....evil laugh sold separately


15 comments:

  1. At Filhaal, we aim to provide traditional attire and accessories of all types to Pakistani females including small girls, teenagers, adults and even old ladies in an easy and fast way. The best thing about us is that we are unbeatable when it comes to price and quality. We feel proud to announce that we provide you with the dresses of your choice on the most competitive prices all over the UK. Visit our website to learn more!

    ReplyDelete
  2. This sql tutorial was super helpful, thanks for sharing

    ReplyDelete
  3. if you are looking for the best multimeter for the money, to pick the best one, but you worry which one is best and meet your requirements.
    For this purpose, you don`t need to take tension about choosing a digital multimeter in your budget.
    Best Multimeter under 100

    ReplyDelete
  4. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. for more info read the blog as mention.

    ReplyDelete
  5. Hi,
    Thanks for sharing this beautiful and informative article.
    I have really enjoyed reading the article and of course learned several new things from your content.
    I would definitely share this blog on my social media pages.
    Looking forward and waiting for your new blogs
    Thank you

    ReplyDelete
  6. Hi,
    Thanks for sharing this beautiful and informative article.
    I have really enjoyed reading the article and of course learned several new things from your content.
    I would definitely share this blog on my social media pages.
    Looking forward and waiting for your new blogs
    Thank you

    ReplyDelete
  7. Everything is very open with a precise description of the challenges. It was truly informative. Your site is useful. Thanks for sharing!

    ReplyDelete
  8. PSL Tuning specialize in chip tuning, engine remapping, and Vehicle Diagnostics. Increase your vehicle performance by 30-40%. We have gained the recognition of the best remap company. For providing the services in a better way to all the people here in the region. Visit our website to learn more!

    ReplyDelete
  9. We have created this website to provide users or readers useful and authentic information about the top clothing brands in the world.
    The readers will find credible and competent clothing brands. The list of brands will give the readers an idea about which company is best for clothes in their country. Visit our website to learn more!

    ReplyDelete
  10. पांचवें भाव में बृहस्पति-पंचम भाव में बृहस्पति जिस भाव में बैठता है उस पर ध्यान नहीं देता है और इस प्रकार जातक के लिए बच्चों की प्रधानता में देरी करता है, लेकिन यह जातक को मुआवजे में बुद्धि और उच्च शैक्षणिक शिक्षा देता है। ... पंचम भाव में बृहस्पति किसी भी चीज का प्रतिनिधित्व करता है जो दार्शनिक, धार्मिक या सांस्कृतिक है।

    ReplyDelete
  11. Looking for car wreckers in Melbourne, Victoria? VIC wreckers are the fastest and the easiest Melbourne auto wreckers to deal with. To arrange a car removal anywhere in Melbourne, just give us a call on 0411 704 458 or fill out the form on our website.

    ReplyDelete
  12. Weld-delux LTD is a leading provider of Metal Fabrication and mobile welding services based in Glasgow. Applying our expertise to bring you the best solutions to all your Metal Fabrication needs. We are here to help you find the best mobile welders near me with our mobile welding equipment and qualified welders. We offer efficient, prompt and reliable metal fabrication services to customers throughout the UK. Our metal fabrication services include brake repair, vehicle body work and other auto body work, we provide a complete solution for all your steel fabrication needs.

    ReplyDelete
  13. Spectrophotometer cuvettes are used for measuring absorbance and transmission of light. Spectrophotometers are used to measure the intensity and spectrum of light. You can buy this from our online ecommerce store name CotsLab.

    ReplyDelete
  14. This anti-wrinkle device is a simple solution to help you achieve smoother and younger looking skin. It contains active ingredients that help maintain elastic and firmness of the skin. In addition, it also protects the skin from UV rays and other environmental assaults.

    ReplyDelete
  15. Lahore Hair Transplant offers the FUE to the patients. The patients hair are taken from the donor area and then holes are created in the bald area. The separated hair follicles are then implanted in these tiny holes. All of these procedures are performed under the supervision of highly qualified and experienced medical staff.

    ReplyDelete

Search This Blog