How to Install SQL Server 2008 R2 Express

This video walks you through the installation process for SQL Server 2008 R2 Express. Note that many of the options also apply to other editions of SQL Server 2008, but there are differences. The goal is to make the setup process as easy as possible, so that you can start working with and learning SQL Server quickly. Due to time and complexity, the video does not address setup troubleshooting or errors. It does talk about your experience if SQL Server is already installed. This video should also apply to installing SQL Server 2008 Express (non-R2). For more information about installation, versions, and instances, see: http://learningsqlserver.wordpress.com

Category:

Education

Tags:

• SQL Server
• SQL Server 2008
• SQL Server 2008 R2 Express
• Install
• Setup
• Installing
• How to
• Getting Started
• SQLEXPRESS
• Database
• LearningSQLServer
• Instances
• Instance
• Express
• SQL

[skumrock]

haha Ive been at this for DAYS MS's site doesn't look anything like this tutorial anymore, it is terrible, i'm ready to give up on this SHIT

[learningsqlserver]

@skumrock -- the web site look and feel does change, which makes it hard to the videos current, especially if they've been linked to. Sorry its caused you headaches. Once you find the right install that has SQL Server Express 2008 R2 + Management Tools, you should find the rest of the video fairly accurate.

[learningsqlserver]

@ieL223, on the Start Menu in the search box, type "Management Studio". See if it finds it there somewhere that you missed. If not, click the "All Programs" link on the Start Menu and look for "Microsoft SQL Server 2008 R2". Is it under there? I know it's frustrating, but you could try uninstalling SQL Server 2008 from your machine and then reinstall, making sure you select the option "With Tools". There are other download options that don't say "With Tools", and you won't get SSMS with those.

[learningsqlserver]

@ravemania100, I see that the web page has changed for the link I'm going to. I'll have to consider creating an updated video. For this video, you'll have to select the database with tools option on the new page. I'm not yet going to make any Denali videos while it is in CTP. Thanks for pointing this out.

[learningsqlserver]

@kevsrikanth, the management tools is what you use to run queries, create tables, or do any other database tasks. There is an installation that does not have this feature. You have to download the version of the installation that includes the management tools. It appears in the start menu as SQL Server Management Studio. @0ElectroMad0, thanks, again!

[learningsqlserver]

@RastaBruh and @keeezz...Im not sure about the answers to these problems you are seeing. I recommend going the the MSDN forums for SQL Server and searching for similar problems from other users or posting your own question there.

[sharifa345]

Thank you! I could not figure out why I could not do anything on SQL (was missing management tools), this cleared all my frustrations!!

[baghul]

Nice Video, just submitted a video on SSRS for your subscribers to check out. Thanks

[VegasGenung]

@learningsqlserver following up on post (3-1-12). I was able to install SQL Server 2012 RC0 Management Studio. It would be helpful to see your video series for the 2012 upgrade. Thanks for the helpful info on 2008.

[VegasGenung]

@learningsqlserver I am having the same issue as @mobyby where I followed all the steps and management studio is not in the SQL Server 2008 R2 folder. All that appears there is the Configuration Manager, Import Data, and Installation Center. I've tried twice on my laptop (after uninstalling all of the SQL modules that were apparently there) and on my desktop.

[mobyboy]

@learningsqlserver I did everything he said and it installed me everything without the management. why ??

i tried to install it seperetally but I couldnt

[TiagoDM]

great video thankx

[kevinragel]

this video helped me a lot! thank you very much!

[rockyman27]

Thanks! this video helped me a lot

[murtaza3113]

i was offline. after watching this helpful video i got online just for liking this video . thanks-alot for uploading useful stuff.

.

[dillinger9999]

yes clear and to the point, but what is SQL for? i hear him say "servers" but I have some files to open that have a file Extension of .CUB and I was lead to SQL Server to open it with.