How to Install and Use SQL Express

In this episode, we're going to take our first steps at setting up SQL Express, our robust, local back end database that has an incredible number of uses - one of those being a hyper-compatible, awesome backend for MS Access applications! Whether you are creating that MS Access backend, databases that you will deploy in Azure, or simply robust network databases, SQL Express should definitely be in your sights if you work in the Microsoft environment. If I could recommend just ONE free tool for any Access developer to learn right now, it would be SQL Express. Hands down. It is truly incredible what you can do with it. It is one way to "level up" in database development, and opens development pathways for you with SQL Server AND Azure SQL.

We'll download and install SQL Express and the (also free) SQL Server Management Studio, a tool that will help you to build and manage your SQL Express, SQL Server, and Azure SQL databases.

Related Videos:
How I Reacted When I First Converted a MS Access App to Use a SQL Server Backend
How to Install and Use SQL Express
You are watching this video now!
How to Design Tables in SQL Express for Use with MS Access

Join me on Patreon!

Demo of my BZ RDP Cloaker:

Check out some tech (and support my channel!):

Want the code from this video?

For developers looking for a new role, check out and sign up:

Needing to hire technical resources for your project? Get the best:

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

[seanmackenziedataengineering]

In that one I talk about the first time I used SQL Server/Express as a backend and was blown away by how good it was.

[rocketi]

Thanks so much for the concise walkthough!

[davidskilbeck]

Thank you! Great lesson, would like to learn more about how to use SQL EXPRESS, keep those lessons coming please ;)

[pspk]

Very good explanation ! Tq Mr.MacKenzie

[josmaitconsult]

Your video has helped a lot. Is there a way that i can bind the Sql database( table - back end) to access database (front end) and install them as one file? Hope you will be of help.

[amankazu]

hello and thank you for your help with the creation of this video but I have a problem that after I download the server management studio the restart button didn't appear. however I closed and restarted my computer anyways just In case but once i got back when i open either of the two applications you downloaded neither shows me the option you have at 11:46 to open the server manager. is there any advice you can give

[Staytrue]

could u elaborate more on how did the sql express start running once the ssms connect to it ? or does the sql express server starts on its own when the ssms is opened ?

[dagthewog]

Thank you! Subscribed. Clear and concise instructions that I can follow along, step by step.

[zuyderrathaman]

Hi, while trying to upload data using the import wizard, I get errors, I've tried installing the Microsoft Access Database Engine 2016 Redistributable and nothing changes, kindly assist.

[btjlsup]

I see SQL Express 2022 is available in your search results. Should I stay away from that version and just choose 2019 ?

[PramodKumar-drnn]

Getting below error:
The MOF Compiler could not connect with the WMI server.

Please suggest next step.

[odukoyayetunde]

hi, i cannot install sql server, i need your help

[usmankhan-sdqe]

Sure more topics with fully priject deployment

[deanbullen]

I don't understand why you have got the name of the product wrong every single time you mention it. It's very clear from the whole video that the product is called SQL Server, Express Edition, not SQL Express.