Issues with trying to run a local instance of sql server

I am trying to figure out how to run sql server on my local laptop.
I want to create a local database, and will not be connecting to a remote server. In management studio I can see a drum shaped icon with the name "Database Engine". If I expand that node, I see a folder named "Local Server Groups". If I expand that node, I can see another drum shaped icon with the name of my laptop. The icon has a red square with a white dot on it, to indicate that this service is not running. If I try and start this service it wont start and I get an error message. More specifically these are the steps I am doing, and the error message I receive.

1. right click on the database icon (Yellow Drum shaped) which has the name of my laptop next to it.
2. From the popup menu I select "Service Control" and then "Start"
3. I am now prompted with a dialog box "Are you sure you want to start the MSSQLSERVER service on KED-W-BOLGR". I select "Yes"
4. I get another dialog box with a gauge on it telling me that it is attempting to connect to the service
5. I now get an error dialog box which has the following message:
  Unable to start service MSSQLSERVER on server KED-W-BOLGR. (mscorlib)
 Additional Information:
 The MSSQLSERVER service on KED-W-BOLGR started and then stopped. (Object Explorer)

Anyway, the red dot remains on the drum icon indicating that the service is not connected. I cannot connect. Can someone help me out?
LVL 2
brgdotnetcontractorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
SSMS is just a tool for connecting to databases it is separate from the actual database engine which you need to install.  To check if you have SQL Server installed on your machine go to services.exe and check for the SQL Server service.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check the Windows Event Log for a detailed error message.
My guess is that you may have files missing and that's why SQL Server can't start.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.