Solved

MSSQL$MSFW service does not start anymore

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

Suggested Solutions

Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
There are several problems reported according slow link speeds or poor performance in TMG 2010, UAG 2010 or ISA 2006. I want to collect here some of the common issues together to give a brief overview what can be the reason. Nevertheless, not all of…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now