asked on

Confused about ISA Server 2004 Log File Storage Configuration?

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

SOLUTION

Shreedhar Ette

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Keith Alabaster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Slator

ASKER

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

Slator

ASKER

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 Alabaster

Welcome

Slator

ASKER

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.