SQl Server Management studio is installed prior to installing Microsoft Visual Studio and SQl Server.
What is SQl Server Management studio?
Its a environment that has been integrated that allows developers to easily manage Sql Server easily.
Even though one can use Visual Studio to create/design and connect with databases,many developers like using SSMS for advanced management.
First thing you have to make sure you have is the right version of SSMS,For instance if you installed Visual Studio 2010,then you will be required to use SSMS version 2008.
Steps for Installing Microsoft SQl Server Management Studio
Step 1:Download Microsoft® SQL Server® 2008 Management Studio Express and Select either x64 or x86 on your operating system.If 64bit select X64 and if 32bit select X86
Step2:Ensure you are logged to the computer you are installing as the Administrator and right click on the set Up and “Run it as Administrator”7
Note:If you are using Windows 7,you will have compatibility issues that you will need to solve by installing SQL 2008 Service Pack 2.
Step 3:After that you should be able to see the “SQL Server Installation Center” and proceed by clicking “Installation” tab.
Step 4: This step you are required to select “New SQl Server Stand-alone Installation” or “add features to existing installation”.This will counter check to ensure there are no failures during the installation of SSMS.
Step5:Click on the Install button
Step6:If you are using the Server for remote access you will need to enable firewall so that it can be accessed remotely.
Step7:This is the step that most people mess up with.You have one selection to make from two choices that seem confusing.One is either to “Perform a new Installation of SQl Server 2008”
Or to Add features to existing SQl Server.
Select a New Installation of SQl Server and click next.
STEP 8:Since SQl Server Express is free,you will not be required to enter the product Key,just click Next.
STEP 9: In this step you will be Required to accept the Licence and click Proceed.
STEP 10: In this step a Window will pop Up and you will be Required to make Feature Selection.Check off “”
off “Management Tools – Basic” and then click Next.
Step11:You will be required to verify the Disk Space Requirements and then Click Next to proceed with Installation.
STEP 12: In this step Microsoft need your help inorder for them to improve their software by you reporting Error messages.Select one and click Next
STEP 13: Another step,Click Next
Step:14.Everything is now in order.Click Install Button.This will take atleast 5 minutes to complete.
Step15:After the installation has been completed click the Next Button to proceed to next stage.
Step16:Click the Close Button and you are now Ready to go
Step17:To fire Up the SQl Server Click Start Button and go to programs as show Below.
Photo Credits:Microsoft Blog