RE: ISA 2004 and MSDE

  • From: "josephk" <josephk@xxxxxxxxx>
  • To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
  • Date: Thu, 19 Aug 2004 13:14:52 -0700

Yes, there will be issues.  I will document as best I can and get that
to you folks.


-----Original Message-----
From: Jim Harrison [mailto:jim@xxxxxxxxxxxx] 
Sent: Thursday, August 19, 2004 1:07 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA 2004 and MSDE


http://www.ISAserver.org

ISA handles the problem of MSDE log size by creating multiple logs per
day. That's why they're named ISAFW_yyyymmdd_###._dx. The ### indicates
the log sequence number for a given date.

MSDE management is handle by ISA according to the log settings you
apply. Please don't try to "improve" the MSDE instance (there's only one
anyway) outside of ISA log manglement functionality (UI and COM).

If you perceive an issue with it, let MS and us know.  

  Jim Harrison
  MCP(NT4, W2K), A+, Network+, PCG
  http://isaserver.org/Jim_Harrison/
  http://isatools.org
  Read the help / books / articles!


On Thu, 19 Aug 2004 12:44:38 -0700
 "josephk" <josephk@xxxxxxxxx> wrote:
http://www.ISAserver.org

That's why I mentioned this. As to not sure what ISA installed as a
patch.  So, some people might have installed sp3 already? Still, we have
the limitations that I mentioned. Have the ISA team come up with a best
practice way of working with the different Instances yet? Is this
something that will be addressed in EE 2004? Will a site that generates
over 2GB of logs a day have an issue with performance?  Using the
standard reporting of ISA 2004, how then will different log instances be
tied together to generate appropriate reports?  

I guess, I have to get my ISA 2004 installed. I wanted to read the doc's
first and understand the object model. I still might wait for that.
However, I have worked with MSDE for a long time and it needs managing.

Joseph

-----Original Message-----
From: Jim Harrison [mailto:jim@xxxxxxxxxxxx] 
Sent: Thursday, August 19, 2004 12:48 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA 2004 and MSDE
Importance: High


http://www.ISAserver.org

NO.
Don't
Do
That.

ISA installs MSDE with the appropriate updates and patches.
We hit a snag with teh SLammer fix in teh ISA environment and the SQL
folks had to give us a "special" patch that we install during setup.

If / when the SQL team issues a patch, look for a statement of
compatability from the ISA team.

  Jim Harrison
  MCP(NT4, W2K), A+, Network+, PCG
  http://isaserver.org/Jim_Harrison/
  http://isatools.org
  Read the help / books / articles!


On Thu, 19 Aug 2004 12:07:25 -0700
 "josephk" <josephk@xxxxxxxxx> wrote:
http://www.ISAserver.org

Also, MSDE just like the rest of the SQL products needs to have SP3 for
SQL(MSDE) installed. 
I'm not sure what version that ISA 2004 installs.  I've not yet put 2004
onto any box. I will do so soon.  MSDE 2000 supports up to 2 gigabytes
(GB) per database. This limitation is per database, not per server. A
single computer can support multiple MSDE 2000 instances, each with
databases of up to 2 GB in capacity. So, with the instance in question,
without good management tools for working with MSDE on ISA then the
"<machinename>\msfw " Structure could break each time the DB reaches the
2GB limit.

Joseph

-----Original Message-----
From: Jim Harrison [mailto:jim@xxxxxxxxxxxx] 
Sent: Thursday, August 19, 2004 8:45 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA 2004 and MSDE


http://www.ISAserver.org

It's not a permanent fix; if yo log off and back on, it'll have
"forgotten". I'm looking into a more permanent fix.

  Jim Harrison
  MCP(NT4, W2K), A+, Network+, PCG
  http://isaserver.org/Jim_Harrison/
  http://isatools.org
  Read the help / books / articles!


On Thu, 19 Aug 2004 08:25:04 -0500
 "Paul Deen" <pdeen@xxxxxxxxxxxx> wrote: http://www.ISAserver.org

Thanks Jim! That seems to have done the trick!

-----Original Message-----
From: Jim Harrison [mailto:jim@xxxxxxxxxxxx] 
Sent: Wednesday, August 18, 2004 8:33 PM
Subject: Re: ISA 2004 and MSDE

This is a known, begnign and irritating problem.
1 - by default, ISA 2004 uses MSDE logging and so installs it
2 - the MSDE instance isn't properly registered with the SQL service
mangler 
3 - you can work around this by entering <machinename>\msfw in teh
"server" field and hitting <TAB>

  Jim Harrison
  MCP(NT4, W2K), A+, Network+, PCG
  http://isaserver.org/Jim_Harrison/
  http://isatools.org
  Read the help / books / articles!


On Wed, 18 Aug 2004 20:12:26 -0600
 "Paul" <pdeen@xxxxxxxxxxxx> wrote:
http://www.ISAserver.org

Hello,
 We recently installed ISA 2004 and I noticed it installed an instance
of SQL (MSDE). I am no expert with MSDE, but we do use it for a few
other databases, not loaded on our ISA of course.  My problem is that I
noticed it doesnt look like it is working. Usually the icon in the
system tray has a green arrow when it is running. Well ours just shows
the white empty circle. When I go into the MSDE manager by
double-clicking the systray icon and try to select the service running
on our ISA from the drop down list, nothing is listed for our ISA
server, but it does see/show our MSDE loaded on other servers.

Is this normal? If not any suggestions? 

Thanks!

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
josephk@xxxxxxxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
josephk@xxxxxxxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
josephk@xxxxxxxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx


Other related posts: