Re: Why ISA Before SQL?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Dave and Brandon,

It really doesn't matter if you install ISA first than SQL SP4 or the other
way around.
It hasn't got anything to do with the ISA 2004 MSDE either, because the SBS
installer will apply the SP4 for the ISA 2004 MSDE automagically.
SQL SP4 can only be applied to SQL server 2000 instances, like the default
instance and the upgraded Sharepoint. The SQL SP4 can't even be applied to
MSDE instances. There has always been difference between the SQL
Servicepacks for the SQL server instances and the instances that are using
the Desktop Engine (MSDE).

About Exchange SP2, I would suggest to install that before the SQL SP4, to
avoid the annoying 'do you want to replace the newer file' blah blah.


--
Regards,

Marina Roos
Microsoft SBS-MVP
One of the Magical M&M's
www.smallbizserver.net
Take part in SBS forum:
http://www.smallbizserver.net/Default.aspx?tabid=53

"Dave Nickason [SBS MVP]" <gwdibble@xxxxxxxxxxxxxxxxxxxxxx> schreef in
bericht news:OgVXjJ%23XGHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
Hi Brandon - I'm just speculating here because I don't think this
conversation has come up before, including during the SP testing or
preparation of those documents. IMO, it makes sense to install ISA 2004
before the SQL SP because that way, if ISA is using MSDE for logging, the
SQL SP will be applied to the ISA MSDE instance. For that reason, I'm
voting for the smallbizserver.net document (not to mention that a huge
number of people have installed the SP successfully with that document).

My recommendation on the Exchange question (this is just my personal
opinion):

If you're running the RTM of Exchange (no SPs), I'd install SBS SP1 but
substitute Exchange SP2 for Exchange SP1 in the process.

If you're running Exchange SP1, I'd install SBS SP1 and skip the Exchange
SP
step. Once you're sure the SBS SP install is stable, install Exchange
SP2.
And of course if you're already on Exchange SP2, just install SBS SP1 and
skip Exchange altogether.


"Brandon" <bsmith@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Otj2Ac9XGHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
WHY does smallbizserver.net suggest installing ISA 2004 before SQL SP 4
when updating a SBS server with SP1? Microsoft suggests installing the
SQL update before ISA.

Also, if I already have Exchange SP1 installed, do I have to reinstall
it
during this update or can I skip that step?

--
Brandon
Presentations Direct - "Document Finishing Solutions"
http://www.presentationsdirect.com





.

Relevant Pages

  • Re: Verify disk is SBS 2003 Premium?
    ... With 2K you could Install ISA as part of the wizard, can't remember if SQL ... "David Elders" wrote: ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange/ISA issues possible
    ... Recommend: ... Assign the Exchange SMTP Virtual Server a specific LAN ... Enable your ISA SMTP application filter ... Highly recommended but optional is to install ISA ...
    (microsoft.public.windows.server.sbs)
  • Re: Offline application for reporting and collect data
    ... Build one user interface that points to either you SQL Server database (when ... Build custom synchronization routines to deal with 'data exchange / ... to install SQL server and restore the database backup in the system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ISA and Exchange
    ... The ISA will add much greater functionality as it will inspect ... traffic before it even reaches exchange. ... have access directly to the exchange server, it doesn't care that the attack ... server, so install the certificate on the exchange box, but make sure the ...
    (microsoft.public.isa.enterprise)
  • Re: Limitations and restrictions of SBS 2003 ?
    ... simple answer is yes you can install additional. ... SQL very easy (don't forget the extra CALs or processor options for SQL. ... Exchange is different matter. ... SBS installation of Exchange helps with the ...
    (microsoft.public.backoffice.smallbiz2000)