Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.