Getting Started with SQL Server Management Studio (SQL Server 2012 Express)
Introduction
Microsoft SQL Server 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
Download Link:
Download SQL Server here!
Procedure to Install
1) Run this file "SQLManagementStudio_x64_ENU"
2) Select "New SQL Server stand-alone installation or add features to an existing installation" option.
https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F3.bp.blogspot.com%2F-LYUuOVSojE4%2FVCRF_o1MXRI%2FAAAAAAAAAdo%2Fg6y15epSZF0%2Fs1600%2Fwpb5ad139d_06.png&container=blogger&gadget=a&rewriteMime=image%2F*
3) Then let the setup check for product updates.
4) Then wait for the tasks operation to be completed.
https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F1.bp.blogspot.com%2F-CudOk8gxKsY%2FVCRFwFTsXUI%2FAAAAAAAAAdk%2FodthC564BPM%2Fs1600%2Fwp80eb740a_06.png&container=blogger&gadget=a&rewriteMime=image%2F*
5) Then accept the license terms to continue and click NEXT.
https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F2.bp.blogspot.com%2F-p62U3GZvCdk%2FVCRFtVCgvjI%2FAAAAAAAAAdM%2F_UF_G2LD2cc%2Fs1600%2F3.png&container=blogger&gadget=a&rewriteMime=image%2F*
6) Then on the next windows Select ALL the check boxes and click NEXT.
https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F4.bp.blogspot.com%2F-nSrZOkl5Bbo%2FVCRFtVY9HXI%2FAAAAAAAAAdQ%2FfQa8-CPb9bU%2Fs1600%2F4.png&container=blogger&gadget=a&rewriteMime=image%2F*
7) Then setup will install some important files and then you are DONE!.
Problem (Rarely occurs):
During Installation if the setup asks you for the Server Name, Instance Name and Password and Databases Name then its fine but if setup doesn't asks for it, then you should do some steps to create your instances for the local db and set up your Server Name.
8) Open Command Prompt and type this command.
SqlLocalDb create "MyInstance" -s
then it will be expected result:
LocalDB instance "MyInstance" created with version 11.0.
LocalDB instance "MyInstance" started.
https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F2.bp.blogspot.com%2F-854esn_Hz5g%2FVCRG4PuoT9I%2FAAAAAAAAAdw%2FnYbPdv09XX0%2Fs1600%2F2694_ldbC.png&container=blogger&gadget=a&rewriteMime=image%2F*
9) Now Open SQL Server Management Studio.
https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F3.bp.blogspot.com%2F-2ATRah4Rt-s%2FVCRFv9i7VNI%2FAAAAAAAAAdg%2FEgD3XveqtLA%2Fs1600%2F5.png&container=blogger&gadget=a&rewriteMime=image%2F*
10) Then type this name in Server Name text box. "(localdb)\MyInstance-s"and select **Windows Authentication **and click CONNECT.
https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F4.bp.blogspot.com%2F-0KuwR2xk-fo%2FVCRG4FiEXxI%2FAAAAAAAAAd8%2Fap0Y5lrTq94%2Fs1600%2F6.png&container=blogger&gadget=a&rewriteMime=image%2F*
Now you are connected to SQL server and can create new Databases.
Happy Coding :)