SQL Server service could not be run after installing Microsoft security essentials

0

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.

Shyju

Posted 2010-11-14T23:24:57.620

Reputation: 121

Answers

0

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

Ganesh R.

Posted 2010-11-14T23:24:57.620

Reputation: 4 869

that will take my databases away rite ? i dont want to do that – Shyju – 2010-11-14T23:57:25.500

If your master database is corrupt, you're already out of luck. Best go back to a backup of your database and restore that. – None – 2010-11-15T03:20:11.940

Also, it's unlikely that the Security Essentials is the cause of the problem. It's more likely coincidental. – None – 2010-11-15T03:20:52.987

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. – 2010-11-15T04:38:02.357

Asked: 2010-11-14T23:24:57.620

Viewed: 745 times

Active: 2011-06-24T01:24:05.900