Sign in
Microsoft.com
 
Forefront Client Security TechCenter
 
 
 
Forefront Client Security TechCenter > Forefront Client Security Forums > Forefront Client Security Setup and Configuration > SQL 2005 Express
Ask a questionAsk a question
Search Forums:
 

AnswerSQL 2005 Express

  • Friday, August 28, 2009 10:48 PMricdgr Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi.
    I realize that using Forefront with SQL Express 2005 is unsupported, but will it work (even with lower performance) or is it totally impossible to make both work (Forefront+SQL Express) together?

    Thanks.
     

Answers

All Replies

  • Saturday, August 29, 2009 5:49 AMJohan Blom, Forefront MVPMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Hi!

    I'm afraid that it won't work at all. Go with SQL 2005 x86 (Ent or Std)

    /Johan

    MCSE, forefront spec | www.msforefront.com
     
  • Monday, August 31, 2009 6:07 AMNick Gu - MSFTMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Hi,

     

    Thank you for your post.

     

    I agree with Johan.

     

    Based on my experience, if deploying FCS server roles(Collection server & Report server), you have to have SQL 2005 Enterprise or Standard(32 bit). For more information, please see:

    http://www.microsoft.com/forefront/clientsecurity/sysreqs.mspx

     

    Regards,

     

    Nick Gu - MSFT
     
  • Thursday, October 15, 2009 1:22 PMMathieu Alain Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi,

    Could you give us some arguments about SQL. My customer read in the prerequise that SQL EXPRESS is supported...

    This is in the Version 10 FSSMC_USERGUIDE_ENG

    User Prerequisites

    The following must be present before FSSMC can be installed:

    ·      Internet Information Services (IIS) 6.0. For security reasons, it must be installed and updated manually by an administrator.

    ·      ASP.NET version 2.0

    ·      SQL Server 2005 Standard Edition (and above), SQL Server 2005 Express Edition, or SQL Server 2000



    Thanks guys, Actually I gotta try this configuration for my customer on a virtual server. But I would take any suggestion so my customer use the good configuration for the system to be stable. My customer got 65 computer on his domain. This will be a one server configuration with all roles.

    Regards,

    My english isnt perfect so please apologize :)

    Mathieu ALain,
    MCITP 2008 ENT/Server admin, MCSE2003
     
  • Saturday, October 17, 2009 1:17 PMKurt FaldeMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    FSSMC != FCS  This is the forum for Forefront Client Security which has different requirements then Forefront Server Security Management Console.
    CSS Security Support Engineer (FCS/MBSA/WUA/Incident Response) Check out my blog http://blogs.technet.com/kfalde
     
  • Saturday, October 17, 2009 8:20 PMMathieu Alain Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Yeah, now I know you are right after trying it for my customer!!

    Thanks!