Solved

MSSQL$MSFW service does not start anymore

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Event ID: 1202 / Source: SceCli 6 143
ticket bloat 3 70
Adding 2008 R2 server to 2003 domain:  2003 DC to 2008 R2 DC 6 24
NTP time source for DC 3 41
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

713 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