Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MSSQL$MSFW service does not start anymore

Posted on 2010-08-26
5
Medium Priority
?
1,814 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 2000 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 2000 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

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…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Integration Management Part 2
Screencast - Getting to Know the Pipeline

876 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