Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I had a SQL server 2008 (Express edition) installation in my Windows 7 (64 bit) and it was working fine. Couple of days back,i installed Microsoft Security Essentials and now when i try to open my SQL management studio,it didnt work.So i went to services and found that it is Disabled.I changed it to "Automatic" and and click on the "Start" button to start the service. I am getting the following error then

alt text

I checked the event log and found this.

alt text

Any thoughts how to get rid of this problem ? Thanks in advance.

share|improve this question

This may be due to corruption of master database file. Try repairing the SQL Express installation and see if that helps.

share|improve this answer
    
that will take my databases away rite ? i dont want to do that – Shyju Nov 14 '10 at 23:57
    
If your master database is corrupt, you're already out of luck. Best go back to a backup of your database and restore that. – user3463 Nov 15 '10 at 3:20
    
Also, it's unlikely that the Security Essentials is the cause of the problem. It's more likely coincidental. – user3463 Nov 15 '10 at 3:20
    
Just copy over the ldf and mdf file of your database and then do a repair. I don't think a repair will destroy your database. All you may have to do is re-attach your databases. – Ganesh R. Nov 15 '10 at 4:38

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .