How to Install SQL Server 2019 (Step-By-Step Tutorial)

[@JoshBurnsTech]

► Freelance Mentoring & Private Discord (LIMITED): www.patreon.com/JoshBurnsTech ► Write 10x FASTER with AI (Get 10,000 Bonus Credits): jasper.ai/free-trial?fpr=joshburnstech ► Create your freelance portfolio with Hostinger: hostinger.com/joshburnstech (get up to 91% OFF with code: JOSHBURNSTECH)

[@scottcarey5573]

This is an EXCELLENT video. About every 4-5 years I have to migrate to a new SQL server (latest Windows, latest SQL). I set it up, configure it, and then it's off and running with minimal maintenance other than the occasional nimrod who decides to write a query that fills the entire hard-drive in 10-minutes, lol. Every time I do a new install, the setup is a little different and there are ALWAYS new options. Your video walked me through setting up what I need. You also provided the in-depth details where it was most helpful. I'm sure I'll be looking for your latest video in about 5-6 years when we move to SQL 2026!

[@prosilverplayer397]

Amazing content sir, I started following you a month ago and now I got a job with my company as DB Admin! Really appreciate your hard work. Cheers from Romania!

[@everythingflytv507]

Where do I get your SQL Best Practices doc?

[@itsjeffjackson1]

This video is incredible!!!!! I must admit...I am a bit behind on videos. With that said, this video is sooooo detailed. Incredible job!

[@JoshBurnsTech]

Thanks so much! 😃 I’ve been staying consistent with weekly videos so I’m sure you’re behind. Haha!

[@itsjeffjackson1]

@@JoshBurnsTech You are literally an inspiration. I spent my night learning Windows Server. Thank you for all the excellent content.

[@JoshBurnsTech]

Thanks Jeff! Glad you enjoy it.😃

[@fredecarlslund5407]

I really enjoyed the video, and I hope to see more of your content :3

[@JoshBurnsTech]

Appreciate you!

[@Jagan_Rohit]

Am successfully installed ....thank u so much

[@JoshBurnsTech]

Glad I was able to help! 👍

[@ivanalbano3192]

Excellent Content, I just started following you just because of this video. Looking forward to seeing more DBA Content in you channel.

[@deep87]

Having an issue getting this error and cannot seem to resolve it. this is coming at the time of installation - The login is from an untrusted domain and cannot be used with Integrated authentication.

[@haleonwheels4576]

links for downloads do not work. anywhere else I can obtain them?

[@johannilsson2778]

So in the document for best practice with disk you can se that it says that best practice is to keep binaries on C drive but then you proceed to changed it to the D drive. I know you said you would not follow the best practice layout in this video but why did you change something that was best practice by default? Or did I miss something?

[@bram3570]

Hi Johan, totally valid question. I'm facing this now as well. I would like to do it on best practice but Josh makes this part very confusing. As a sys admin of 10+ years of experience I don' get it ;-)

[@rlukinn]

at 8:47 was very confusing, many unknown terms. Other places of the tutorial are great and very well explained.

[@JoshBurnsTech]

What's confusing? The active directory service account?

[@johnhess7416]

Great video. Very easy to follow along.

[@JoshBurnsTech]

Glad you enjoyed it! 👍

[@parikshithgari]

Very informative video Josh. I have a question though: In my scenario, we did the install we put all MDF, LDF files in a separate drive other than C Drive. As you suggested that in the video I would like to move now Log files and Data files to their own drives. Does it mean that I need to move system databases such as Master, Model, MSDB databases as well to those folders? If I move at this stage are they any repercussions? Also, it would be soo helpful if you can make a video on service accounts and their permissions on the SQL side, AD/Domain side, and on the Server level.

[@SilentWarriorEU]

Wondering about file system for this additional disks... What about Windows Server 2016/2019 and ReFS as native filesystem for TempDB Drive, Log drive and backup drive ? Because everybody use NTFS as default not mentioning that we have other interesting options for file systems in these all additional drives :) Any comment for ReFS and SQL ?

[@JoshBurnsTech]

I've personally never worked with ReFS or have any experience with it. Like you said, most people use NTFS and that's the go-to from the sysadmins that setup the servers before they head over to me. lol

[@dimitristsoutsouras2712]

Nice Video indeed. I am new to this and I d like to know some general things apart from what you mentioned. -Is it a good practice to use more than one instance in the same installation of sql server? -If it is ok how much ram is needed for each instance. (By the way the size for now for our 4 company instances is around 6-8 gb yearly) -Does the number of the instances impacts on the number of MaxDOP ? --When you open the port to the firewall needs a service for that port too. Is it any specific one / ones? or it needs to be setup as any. Thank you in advance

[@teomcam]

I can't locate the link for the Best practice sheet.

[@tljstewart]

Great content Josh, what OS are you installing MSSQL on, Window Server or Window 10? What are your thoughts on containers or VMs for MSSQL?

[@RilwanKeshinro]

Thank you for this great video, HOWEVER, i could not find the link to download the document to configure the storage path.

[@JoshBurnsTech]

Thank you! I will work on storing it on notion and update the link.

[@ivanalbano3192]

@@JoshBurnsTech have you done it ?

[@xDejiax]

My installation for database engine keeps failing. I’ve deleted and reinstalled and still no fix. Pls help me. :,(

[@dimitristsoutsouras2712]

If you need to install 2019 standard edition and deploy it in a production environment, do I need the premise version or go down below where it mentions download sql server for windows. In both cases the downloaded file is the same 4.9mb executable. Is there afterwards a place where you put the serial you ve purchased (when the purchase happened after installation of sql)?

[@Mdatafication]

Very informative video!!! Thanks ..

[@JoshBurnsTech]

Very welcome! 👍

[@Kargil30]

Hello, I have been watching your Upwork videos. I am following what you have said. But upwork is not approving my account. Can you please guide me through. I will be very grateful. Thankyou

[@JoshBurnsTech]

Hey! Glad you enjoy my content. I can’t help with admissions, but if you follow my steps from the video regarding profile tips it will definitely put you in a great position to be approved.

[@Kargil30]

@@JoshBurnsTech Thankyou so much😁

[@waleedanwar5776]

Hello Some errors have occurred during the installation Sql server 2019, please find a way How do I fix the problem? I have also texted you on Facebook and Instagram.

[@khayal98]

Please do a video on sql server on RDS. Love your videos. thank you very much !

[@sabanaar]

Thanks Josh for this wonderful video, I could not locate your article on the "SQL Server Best Practice Drive Layout" would you please provide me with the article URL. Thanks again!!!

[@therrygene]

Hi Josh. Very informative video. Is your beginner course already available on Teachable?

[@JoshBurnsTech]

Not yet! I'm planning to start putting a lot more time into it in a few months from now.

[@spcommando7624]

@@JoshBurnsTechis jt available now ?

[@DCRAIDER05]

You lost me when you said mount it???? Your file looks different from what I downloaded

[@fregreggi6702]

Very nice video, so informative! Thanks! Hey are you the one who "burnt" Linus server?! Just kidding!

[@JoshBurnsTech]

😂😂😂 You have no proof.

[@harshdubey9166]

In your initial days how much time you spend on learning SQL server

[@JoshBurnsTech]

Not sure regarding specific hours but I was constantly learning. I put as much time into it as possible.

[@MImad-rv5gt]

thanks

[@JoshBurnsTech]

You're welcome! :)

[@zhefeng583]

hello Josh, thanks so much for your tutorial! Really helpful indeed! Btw I am looking for your SQL course you mentioned in the video, by any chance if you can shoot me a link? thanks so much!!!

[@harshdubey9166]

Plz Make a video on how and from where you start learning SQL dba

[@JoshBurnsTech]

I'm working on a full SQL Server DBA for Beginners course that will be hosted on Teachable. I will keep this in mind as well!

[@jsdid]

@@JoshBurnsTech when will this be done, and will it cost anything?

[@remmykesh5533]

​@@JoshBurnsTechIs this video available now? I mean becoming a SQL DBA for a Beginner?

[@stephend3961]

All you guys are the same - never complete instructions, don't explain the different services, don't show how to setup an AD service account -- how to set them on the local system and change them for the SQL service , etc... You just touch on the obvious stuff, time for some more research.

[@JoshBurnsTech]

At most companies, you will never setup an AD service account as a DBA. I've worked with 100s of clients and I've never configured an AD account for them, although I did work with AD during college as a junior network admin. Most companies have internal employees that manage AD, which means that you simply need to know what to request. Sounds like you're looking for a full course, so I would recommend finding one that also covers windows server admin and AD as well.