Solved

MSSQL$MSFW service does not start anymore

Posted on 2010-08-26
5
1,747 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
So the following errors occurs in 2 ways that I am aware of at this stage, and you receive one of the following error messages: ERROR 1. When trying to save a rule: No Web listener is specified for the Web publishing rule Autodiscovery Publishin…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

840 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