Solved

MSSQL$MSFW service does not start anymore

Posted on 2010-08-26
5
1,744 Views
Last Modified: 2012-05-10
Hello,

I am running ISA Server 2006 on a Windows Server 2003. Everything seems to be working. The firewall service starts, the publishing rules works and the VPNs. I can also make changes to the ISA Server configuration. But yesterday after patching the server I recognized that this service is set to start automatic but does not run. So I tried to start it manually but it right away stops with following warning:
" The MSSQL$MSFW service on <servername> started and then stopped. Some services stop automatically if they hae no work to do, for example, the Performance Logs and Alerts service.

I checked the event logs but there is nothing logged at all.

I wonder now if I should be concerned about the fact that the service does not run or is the SQL instance only being used for logging which we do not use?

Thank you
Mc2102
0
Comment
Question by:Mc2102
  • 3
  • 2
5 Comments
 

Author Comment

by:Mc2102
ID: 33534922
I should also say that I have no idea that since when we are not able to start the service anymore. Since everything seems to be working it could me month ago when the service broke.
0
 
LVL 31

Accepted Solution

by:
Justin Owens earned 500 total points
ID: 33541031
There are a couple options....

Make sure that the logging in the ISA is set to file, W3C.  Then modify the installation of the ISA and remove the Advance logging then reboot.  

If that doesn't work....

Export the ISA configuration.  Remove the service completely.  Add it back.  Restore the configuration.

Justin
0
 

Author Comment

by:Mc2102
ID: 33541966
Justin,

So is the SQL instance \ service used by ISA server only for logging?

Marcus

0
 
LVL 31

Assisted Solution

by:Justin Owens
Justin Owens earned 500 total points
ID: 33541984
As far as I know... Yes.  The caveat to that is, of course, no one can know everything.
0
 

Author Comment

by:Mc2102
ID: 33546869
One of the solutions above might work but since only the logging feature is being affected which we are not to much concerned about I decided to leave the ISA server alone. I might end up with a ISA server which does not work at all.

Thanks a lot of your help.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
Forefront Threat Management Gateway 2010 or FTMG comes with some very neat troubleshooting tools built-in when trying to identify what is actually happening behind the scenes within the product when traffic is passing through its interfaces. To the …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question