How to get Start Microsoft SQL Server?

How to Download Microsoft SQL Server Express (Microsoft SQL Server for beginners)

How to get Start Microsoft SQL Server?To start with it we need to download and use a free version/Express edition of Microsoft SQL Server. I am going to use Microsoft SQL Server 2012 Express.

How to get Start Microsoft SQL Server? Part – 2

Download Microsoft SQL Server 2012 Express edition

The first thing I would like to know you that you need to get started with a FREE version or copy of Microsoft SQL Server 2012 Express Edition, in this way please click here to navigate to download it absolutely free from Microsoft official Servers, once opened Microsoft page please click on the orange “Download” button (if you are unable to reach at Microsoft’s official website then follow the link: https://www.microsoft.com/en-us/download/details.aspx?id=29062). Referring the below snapshot –

Download Microsoft SQL Server 2012 Express edition 1

When you click on the download button a popup window will appear “Choose the download you want”, you have to click the checkbox next to “ENUx64SQLEXPRWT_x64_ENU.exe” if you have a 64-bit machine. Referring the below snapshot –

Download Microsoft SQL Server 2012 Express edition - 2

If you have a 32-bit machine then download the file named “ENUx86SQLEXPR_x86_ENU.exe”. Referring the below snapshot –

Download Microsoft SQL Server 2012 Express edition - 3

And then click on the “Next” button to download the executable file. Referring the below snapshot –

Download Microsoft SQL Server 2012 Express edition - 4

Once downloaded executable file, please run it as administrator and follow the on-screen instructions to install Microsoft SQL Server 2012 Express Edition.

Download Microsoft SQL Server 2012 Express edition - 5

Be ensuring to install both the database engine and SQL Server Management Studio (SSMS) which is the tool that we will be used to complete our queries.

Download and Attach AdventureWorks database into SQL Server Management Studio (SSMS)

Once you have the Microsoft SQL Server 2012 Express Edition successfully installed on your machine, you will need to download the sample AdventureWorks2012 database. in this way please click here to navigate to download it absolutely free from Google drive location, once opened Drive location page please click on the “Download Anyway” button (if you are unable to reach Drive location then follow the link: https://drive.google.com/uc?id=1Rk2B3Uj1vj_14gnjhbJ2upEFpN6iQHYm&export=download). Referring the below snapshot –

Download and Attach AdventureWorks database into SQL Server Management Studio-1

And download the file named “AdventureWorks2012_Data.zip”. Once downloaded please extract the files in the zipped folder. Move the file “.mdf” Extention to the SQL Servers root folder – C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESSMSSQLDATA. Referring the below snapshot –

Download and Attach AdventureWorks database into SQL Server Management Studio-2

Open SQL Server Management Studio (SSMS) once the file is finished downloading. Once SSMS is open please connect to your newly installed SQL Server Express instance. You can type “.SQLEXPRESS” in the “Server Name” field when first opening SQL Server Management Studio. Referring the below snapshot –

Download and Attach AdventureWorks database into SQL Server Management Studio-3

Once connected SQL Server Management Studio 2012 please click on the folder named “Databases”, and then select “Attach”. Referring the below snapshot –

Download and Attach AdventureWorks database into SQL Server Management Studio-4

The “Attach Databases” screen will appear as shown below –

Download and Attach AdventureWorks database into SQL Server Management Studio-5

Click on the “Add” button to open the “Location Database Files” screen where you will select the file named “AdventureWorks2012_Data.mdf”. This is the AdventureWorks SQL database file that we downloaded previously. Referring the below snapshot –

Download and Attach AdventureWorks database into SQL Server Management Studio-6

Click on the “OK” button once you have selected the correct file. Information will populate into the “Attach Databases” screen based on what *.mdf file you have selected. Since we downloaded the database file but not any log file associated with it please click on the row with the word “Log” in the “File Type” column. As an extra step to make sure you selected the correct file, the log row will contain the text “Not Found” in the “Message” column. After confirming you have selected the correct row please click the “Remove” button and then press the “OK” button. Referring the below snapshot –

Download and Attach AdventureWorks database into SQL Server Management Studio-7

Now right click on the “Databases” folder and select refresh, expand the “Databases” folder. The AdventureWorks2012 database will appear in the expanded list and now it’s ready as you can start your next work. Referring the below snapshot –

Download and Attach AdventureWorks database into SQL Server Management Studio-8
Download and Attach AdventureWorks database into SQL Server Management Studio-9

Assuming this tutorial post has well-acquainted aspiring to the complete requirement. If you want to download a PDF format file of this tutorial then please click here to download PDF.

Also requesting, if you have any ideas or suggestions for me or you need some important blogs/Videos or guidelines related to SQL Server, Excel, WordPress, SEO, Website technologies then please feel free to write me on below comment section or you can go through the Contact Page. I will definitely come back to you with your desired requirements.

Hope this tutorial post was helpful for you and you liked very well, I am happy to serve you better. If you liked really this tutorial post, please don’t forget to share on social media like – Facebook, Whatsapp, LinkedIn, Twitter, Instagram, etc

This Post Has One Comment

  1. Rajshree P

    Very helpful this notification to me and may be every one of us.

Leave a Reply