SQL Server 2016 Part 1 - Getting Started and Installing SQL Server 2016 Developer Edition

[@TheJupiteL]

Still had this on my watch later list from 3 years ago. Just want to say thank you, I passed my database classes and currently working as a database developer.

[@WiseOwlTutorials]

That's fantastic, congratulations! So pleased to hear that the videos helped, thank you for taking the time to leave a comment and for watching!

[@mohamedgadallah4720]

I can not believe that you are offering all these videos with that quality in production and technicality for free. Honestly I’ve downloaded all videos in your channel in case it closed for any given reasons. If you are offering any courses for money count me in.

[@madezra64]

I haven't watched it all yet but I already am in agreement. These videos are very high quality for what they're offering. Good audio quality, well spoken and so far everything he talks about is correctly explained. Liking these :)

[@mohamedgadallah4720]

MadEzra64 I would recommend watching all videos more then once to get most benefits.

[@ahselina]

I am new to SQL related software. This series video is the clearest, the most comprehensive and well organized one I have found on KZbin! Thank you very much! ps: really like your accent!!!

[@WiseOwlTutorials]

Thank you so much! Very happy to hear that you found the video useful, thank you for watching and for taking the time to leave a comment!

[@michaelb1785]

There is a fountain of information in every video I watch.

[@Phlogiston2312]

BTW, I like the thoroughness of going through the install options and descriptions of all options

[@TonyTigerTonyTiger]

Warning. As of today (May 6, 2017) you need to be a bit careful when you go back and install, separately, SSMS. The page you are taken to is for SSMS 2017, only. The page claims that SSMS 2017 is compatible with all previous versions from 2008 through the newest, SQL Server 2017. However, what the page does not tell is that if you are going to be using SSIS, then SSMS 2017 won't work ... it is not compatible with SSIS 2016. This incompatibility may change in the future, but as of today, if you will be using SSIS, then instead of installing the only version that the page shows, you have to scroll down and find and click the link to go to previous versions, and download the latest SSMS version for 2016. PS: Nice video. Without it, I would have been frustrated by several other nonsensical things about installing SQL Server 2016.

[@jaymiracle5500]

DNAunion thank you so much for this

[@TonyTigerTonyTiger]

Just donated. I feel I've learned at least as much from your videos as I have from several books.

[@PinksAngel]

Very well done. Clear, concise, not too fast, not too slow. Thank you.

[@justinbanza4751]

Thank you for all the time and effort to produce this useful video...

[@WiseOwlTutorials]

You're welcome Justin, glad you enjoyed it!

[@bencole8301]

Another video completed. Albeit a simple one that unfortunately took a long time to complete as my download speeds must have been running in reverse? Anyway SQL Server 2019 downloaded and ready to go. Hope it isn’t too tricky learning from your 2016 version using the 2019 one. Thanks again for a great video Andrew. Love the comment from a previous viewer as database developer sounds like an amazing job. Maybe one day in many years from now...

[@WiseOwlTutorials]

That's definitely the tedious part over with, writing queries is the fun part! The techniques covered for 2016 will still work in 2019, heck even the older videos which use SQL Server 2012 will still be relevant! The series could definitely use a reboot but I hope you enjoy the videos anyway!

[@DanielBurrueco]

Terrific course, great contents, very good instructor, good pace, I couldn't ask for more. I now have a new favourite source of training material. Just looking forward to more content.

[@paulb3084]

Superb timing as just about to start my first SQL project (2016). Looking forward to watching this series.

[@pallabroybabu]

Andrew you are such an Awesome teacher ... Out of words to Thank You !!

[@KurtHokage]

Thank you for the in depth video! I look forward to finishing your series on this and I hope I can make a full database in this program by the end.

[@ronevans1229]

Very impressed with the videos I've watched to date. Something to be said for the precise organization and presentation of content materials, and most importantly the clear, concise language used to deliver the instructions-which is most refreshing. Frankly, I've watched other similar videos that have left me struggling to interpret the message and piece the puzzle together - which is somewhat puzzling, counterintuitive, nonsensical, etc. to me...enough said. Honestly these videos are by far the best I've watched. Kudos to WiseOwl for a well-done product! Wise indeed I say...clearly not an oxymoron thing going on here.

[@LazarRedDevil95]

Can't wait for next video. Keep them coming. Cheers

[@uyansainod959]

thank you very much. your tutorials are taught so much. good luck

[@DefaultUser3301]

Very detailed and elaborated tutorial, thank you for uploading sir.

[@bfakieh]

I believe that I should at least say: Thank you very much for this tutorial. God bless you!

[@callofdutymuhammad]

Im using SQL server 2014. It's pretty much the same with less features however there aren't any analysis services.

[@kamjobmail]

When I clicked the download link, it didn't take me to "Download Results" page where it posted the prerequisites. It straight away downloaded. So I just proceeded like that.... Hope it will work fine....

[@harrisonwright3900]

hello hope the wise owl team had a good Christmas coming to the SQL introduction course in February I was just wondering if you could do a updated version of this as the 2016 nor 2017 wont install on my computer but the 2019 one does thankyou

[@WiseOwlTutorials]

Hi Harrison! I'd probably just skip straight to the 2022 version of SQL Server Developer Edition www.microsoft.com/en-us/sql-server/sql-server-downloads It's unlikely that we'll have a new version of this video before you attend your training course but the installation process is pretty similar to that shown in this video.

[@nastiashchedrova1238]

Hello, thx a lot for your video. You explain everything in a very clear form. Maybe you can help me with one problem. When I`m clicking on Download button (as it is shown min 3:40), my computer starts downloading file SQLServer2016-SSEI-Dev.exe and it doesn`t want to follow me to another sheet, so I can`t proceed as you do it. Hope you can help me.

[@M2dScientist]

great informational video! I hope all your videos are the same.

[@grigoriefimovic1547]

This was quite helpful....thanks alot

[@edduardoo]

Very good job! great Videos!

[@ANV_Automation]

Nice

[@WiseOwlTutorials]

Thanks!

[@flyingzeppo]

I signed up for Dev Essentials, but it looks like SQL Server is no longer being offered. It's nowhere on the list.

[@WeMakeVideosCA]

I keep getting complete with failures. Error installing SQL Server Database Engine Services Instance Features Could not find the Database Engine startup handle.

[@lonaosmani4106]

Thank you so much.

[@cjlowe1650]

These are great info! One question. If you install and configure a database with a coalitation type and want to change it later, what problems will that cause down the line?

[@vaskard666]

great...as always...

[@amitsahu2698]

Hey thanks, but After complete installation R-services were not installed, can you help me!

[@hasukumori]

Hi, I just took and passed my 98-364 DBA Fundamentals. I'm now ready to start studying for my 70-764 and 70-765. Will this video get me through those exams? Also, I am running on Windows 7. so if I use 2014 with this, I'm wondering how far off I'll be. I'm not doing the 2012/2014 because I'm trying not to take 3 tests.

[@hen_176]

your videos are always the best on youtube! you rock! could u help me with a problem? i installed too many sql instances (i tried intalleing a few times,and appearantly instaleed some extras) how to i delete the extra instances?

[@midhunchakravarthy6750]

Hi sir i got an error while opening the sql Server manager and sql server management studio which does not allow me to open ."cannot connect to wmi provider you do not have permission or the server is unreachable". could any one help me how to solve this problem.

[@zhenwang4108]

@WiseOwlTutorials thanks for the video, what if i missed add myself/current windows user as server administrator? can i also find the security folder from the SSMS tools and find myself's name and tick the 'serveradmin'? will it do the same thing?

[@Devin1pm]

Hi WiseOwlTutorials, Thanks for all the SQL videos and I had first handson experience installing sqlserver 2016 today and encountered following error message at the end of installation. I followed your guide except my instance is default name. "Wait on the Database Engine recovery handle failed. Check the SQL server error log for potential causes" .. according to google, Change the Account Name of Database Engine Service to NT AUTHORITY\NETWORK SERVICE and it should work..but i tried. it doesn't and it keeps failing to install. Im trying install evaluation version of sql2016 instead of developer. I hope you can help to advise me on this issue. Thanks alot

[@grzesminor]

Hi, been trying to install SQL2016 on my unit and have been getting failed installations on a few of the features all having the error as: 'attempted to perform an unauthorised operation'. Ive looked online for a resolution but nothing seems to help. have you come across something like this before?

[@theworstchannelever6640]

great video!

[@ivanvrabec7499]

In SQL Server Configuration Manager my "SQL Server Analysis Services(SQL2016TRAINING) is running and it's perfectly fine, but I can't start "SQL Server" .. I can't go on.. I tried everything and googled everywhere, but nothing.. it keeps saying "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." Any ideas? Thanks.

[@klgyal2010]

Thank you very much ☺☺☺

[@user-gn1ms9et5c]

Thank you!

[@ryanjefferis7598]

Before watching this I downloaded SQL Express. Is Express not as good as Developer? Should I uninstall and install Developer edition?

[@andreasmohr7054]

Really Hot, thanks a million! Now I am really looking forward to see the tutorials you offer on Reporting Services

[@Pranavmallavarapu]

I have installed SQL Server 2016, will SSMS 17 work with the SQL Server 2016?? Please help me out

[@utkuuuuuuu]

Thanks.

[@SrikanthBhospet]

Nice informative video.

[@noorhirjee2274]

Great videos. Do you have 2012 and 2014? thanks

[@elyass7514]

Hi, you are doing a good job.. is there any video for sql server 2016 new features of master data services in WiseOwlTutorials?

[@elyass7514]

Thanks for your reply.. Do you have any blogs regarding features of MDS..

[@claytonernsbarger8627]

In 2017, reporting services was not shown as a option when setting up a new instance, any feedback would be appreciated.

[@claytonernsbarger8627]

Thank you for the reply and link, and for the great videos! My hopes are that others will benefit from the question and reply. I was able to figure most of it out and have moved on to your SSRS videos. I am still working through some issues with properly displaying the SQL Server Reporting Services page on the web, but continue to review your videos as well as read through the information on the Web Service and Web Portal URL, it appears I have some permissions or path issues to resolve, but can at least get to my reports. Again thanks for what you do!

[@i.domingo8456]

Hi, I previously installed an instance of SQL express 2016. During the installation, I noticed there were only about 2 features, but i went through with it anyway. After watching this video i noticed that the installer size was 2GB, while mine was around 400MB. Is there a way i can add up the other features in the future without having to uninstall the whole thing and installing it again? Thanks

[@i.domingo8456]

Thank you so much for the response, sir. That helped greatly.

[@GameHiveInsights]

best tutorial

[@tomtrain1748]

For my installation I have the Distribulted replay controller and replay client, what are they

[@dragondragon2856]

tom train ث

[@riebebokoko5042]

Great videos mate, Just one thing, How do you set up the server for the reports to go to? I have been banging my head to make it happen. Is It all automated when setting the Native Mode Report Service upon installation of SQL server?

[@riebebokoko5042]

Yeah, done all that!! I'm just trying to do a fresh install and try customize it so I choose the native mode. A big ask, Would this work in a VM? (Virtual machine).

[@riebebokoko5042]

Thanks a lot mate!! I'll have a look at it as I'm reading through tons of docs :D

[@Trinisnapz]

Does the same installation process is the same for the Standard edition?

[@Trinisnapz]

thank you so much for the info

[@warunausgoda]

Great

[@pianoLee-sx9dx]

Hello! I can't find the microsoft sql server on that page... Have they changed the name? I can only see sql server....I am not sure which one I should use for my report builder on windows 10.. I also just noticed that I should be selecting the custom installation but will the basic be good enough?

[@WiseOwlTutorials]

Hi Lee! Microsoft have released SQL Server 2017 and 2019 since this video was recorded, for the latest free version (SQL Server 2019 at the time of writing) head to this page www.microsoft.com/en-ie/sql-server/sql-server-downloads and scroll down to find the link for the Developer Edition. You'll also need to install SQL Server Management Studio (SSMS) which you can grab here docs.microsoft.com/en-gb/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 I hope that helps!

[@pianoLee-sx9dx]

@@WiseOwlTutorials thanks... I actually went to the wrong place, I went to the marketplace instead.... Can you download it from there?

[@WiseOwlTutorials]

@@pianoLee-sx9dx Hi Lee, I honestly don't know, I've never tried to install it that way before!

[@pianoLee-sx9dx]

@@WiseOwlTutorials I noticed that you have missed out the polybase installation... it is asking me if I want to use the standalone head node or the port range?

[@pianoLee-sx9dx]

still am not sure which one to go for?

[@bosssoli11]

why spake quickly?

[@vlad_IT_87]

Hi! I just have 2 questions regarding MS SQL Developer Edition. I downloaded SQL Server Dev. edition and Visual Studio Comunity edition for learning purposes. I am creating a windows app using C# and would like to connect it to a database of SQL server developer edition as backend. Is that allowed as long as I don't use it for commercial purposes? My other question is If I create a database in SQL Server Developer edition is it allowed for the database to be exported (extracted) and imported in SQL Server Express edition for commercial use? Thank you in advance! Cheers!

[@sunealsblbrandt436]

denne tråd tilhører nu ZBC Ringsted

[@TheGoldenNick]

Hva faen? Hvor i ZBC Ringsted befinder man sig? :pp

[@Phlogiston2312]

Don't take this the wrong way, but you sound a little bit like Tom Felton. Maybe it's speech pattern or speed of speech

[@MiLLz830]

should i go with express or developer ?

[@Ellipse31]

go with developer buddy

[@uker7070]

for someone making a "tutorial" video, he really lacks in explaining a lot of things

[@skiptomylute5094]

For someone commenting on a "tutorial" video, you really lack the ability to describe what it is that needs to be further explained. The install went rather seamless on my end.