Welcome to ISAserver.org

SQL Engine in system tray.

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 General ] >> Installation >> SQL Engine in system tray.

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Engine in system tray. - 25.Jan.2008 3:01:34 AM

mypass604

Posts: 47
Joined: 25.Jan.2008
Status: offline

Iam new in ISA server . pease guide me that if we choose typical installation of ISA 2004 it also install SQL iserver engine in the system tray. what is the purpose of SQL engine in ISA?

Post #: 1

Featured Links*

RE: SQL Engine in system tray. - 25.Jan.2008 9:34:36 AM

Rotorblade

Posts: 1002
Joined: 27.Feb.2007
Status: offline

Hi,

MSDE (Microsoft SQL server Desktop Engine) is for logging and monitoring. It can be a resource hog so you man need to tame it down a bit. It�s optional if you don�t want to use text file logging.

http://support.microsoft.com/kb/909636

HTH

RB

_____________________________

David Melvin
Ohio
MCSE: Security 2003, MCSA:Security 2003

(in reply to mypass604)

Post #: 2

RE: SQL Engine in system tray. - 25.Jan.2008 10:14:15 PM

mypass604

Posts: 47
Joined: 25.Jan.2008
Status: offline

thanks "Rotorblade" for yours kind reply. As you tell that "MSDE (Microsoft SQL server Desktop Engine) is for logging and monitoring .it is optional and i can use text file."

Please guide me that how can i do that.i.e the way to see my logging and monitoring in ISA !.Should i disable the MSDE . It really eat all my memory and computer too much slow.

(in reply to mypass604)

Post #: 3

RE: SQL Engine in system tray. - 26.Jan.2008 4:14:04 PM

Rotorblade

Posts: 1002
Joined: 27.Feb.2007
Status: offline

quote:

Should i disable the MSDE . It really eat all my memory and computer too much slow.

Hi,

Here�s the issue that you will be facing. If you try to disable it while in use, ISA is going to stop taking requests because it needs MSDE for logging. Removing it is an option but you need to configure logging to use flat file logging first before you do so. Taming its memory use is another option that I mentioned in my pervious thread to you. I guess it�s a matter of personal preference on what you use but I prefer to use it.

Changing the logging options (Firewall and Web Proxy) is done using the MSC by clicking on Monitoring and selecting Configure Firewall Logging or Web Proxy Logging.

Removing MSDE if you choose to do so can be done by going to Add/Remove programs, select Microsoft ISA, click �change� and when you're prompted, choose "Modify". Expand "Firewall Services" and click "Advanced Logging" and click and select "This feature will not be available". Follow the rest of the wizard. MSDE should be uninstalled.

HTH

RB

_____________________________

David Melvin
Ohio
MCSE: Security 2003, MCSA:Security 2003

(in reply to mypass604)

Post #: 4