We help IT Professionals succeed at work.

Confused about ISA Server 2004 Log File Storage Configuration?

Slator
Slator asked
on
What does it mean when the ISA Server 2004 configuration for logs = MSDE but there is no indication an instance of MSDE is installed/running?

I can only see one instance of a database running:  Microsoft SQL Server Workgroup Edition (9.0.4053 SP3) - which is part of SBS Premium.

Environment:
Small Business Server 2003 R2 Premium
ISA Server 2004
SQL Server 2005 Workgroup Edition
Comment
Watch Question

Shreedhar EtteTechnical Manager
Top Expert 2010
Commented:
Hi,

Refer this:
http://support.microsoft.com/kb/838241

Hope this helps,
Shree
Enterprise Architect
Top Expert 2008
Commented:
The MSDE instance used by ISA is not the same as a straight forward MSDE install, the ISA services and the MSDE are bound together, effectively masking the existence in the sense of sql client browsing and the like. The main reason being that the instance is responsible for logging ISA activity and needs to be secure meaning that you can not add another database to that instance of MSDE.

Author

Commented:
Keith,
Can I take you response to mean the following:
--The ISA Server 2004 install created a (private/special) instance of MSDE
--This ISA instance will not be visible in any manner whatsoever - including any SQL management console
--There is no (supported) method available to connect (e.g., OBDC) to the ISA Server 2004 .mdf log files
--ISA Server 2004 does not use SQL Server 2005 Express, only MSDE or the "real" SQL

Thanks,
Slator

Author

Commented:
OK, I think I got it...
My problem (or confusion) was that the SQL management/configuration consoles were showing different SQL version numbers which led me to believe that I had more than one instance of SQL installed/running - in addition to the MSDE version for ISA Server 2004.  This led me to believe ISA Server 2004 was using an SQL Express version instead of MSDE.

I finally realized all the SQL version numbers were referencing the same {root path} and {instance ID}.  I have no idea why Microsoft would report different version numbers for the dsame instance of SQL.

In any case, it appears I have 1 instance of {SQL Server 2005 - Workgroup} and 1 instance of MSDE running for ISA Server 2004.

Thanks for the help!
Keith AlabasterEnterprise Architect
Top Expert 2008

Commented:
Welcome

Author

Commented:
Shree's response did not (actually) answer my question but the information/KB article was so informative I decided to award her 100 points.

Thanks everyone.