MS SQL server default instance

How to install SQL Severver Management Studio Express
(using a proper server instance to connect to the server)

Before installing this make sure you have installed the visual studio pack that was downloaded from the MSDN site or the dreamspark site.

go and search in the google for sql server management studio express and you will be able to download it easily and for free ( EXPRESS editions are free)

I am not going to talk about downloading the software much. Its not that difficult

well then install it keeping everything as default, of course change if necessary, make sure to remember the server instance name.  

well after you install the software, when you run it for the first time, you will see a window like this,

you should enter the server name and instance.

Soooo, if you haven't changed any thing in the installation and kept every thing as default, the default server instance shout be SQLEXPRESS

so you should put, <server name>\<server instance>

localhost is when the server is in your own machine 

so the server name is 

localhost\SQLEXPRESS

then press connect

after you connect to the database server it should give a window as below.

 If you like to create a new database, right click on the Databases folder and create a new database

hope this helps
cheers