locked
FCS installation /Remote SQL DB RRS feed

  • Question

  • I have a single DB server ( SQL 2005) in my infrastucture and i does not wants to install the FCS on the same server.
    I am planning to manage less than 150 machines using FCS , which topology i should follow , in place of wsus i have SCEworking.
    please suggest me.

    Tuesday, December 30, 2008 11:26 AM

All replies

  • Hi!

    There are a few scenarios i can think of.
    Even if you don't want to install FCS on your SQL server. Do you want to use the SQL to host the FCS databases?
    if you want to use the SQL for FCS databases it has to be a SQL 2005 standard or enterprise edition (32 bit version)
    If your SQL server does not meet these requirements, you have to setup a separate SQL server

    Scenario 1 (using existing SQL)
    Setup FCS roles on a separate server (except the database roles which goes on your existing SQL server) according to a  3 server installation (explained in the setup doc)

    Scenarion 2 (using a new SQL)
    Install all roles on a single box (except distribution role) according to a 2 server installation.

    Setup docs are found here:
    http://technet.microsoft.com/en-us/forefront/clientsecurity/bb508813.aspx

    good luck
    /Johan
    MCSE, forefront spec | www.msforefront.com
    Thursday, January 1, 2009 11:35 AM
  •  Thanks for your valuable suggestions , I still have some questions in my mind
    1. Can i install FCS without hosting its Db to SQL ?
    2. As per documentation for three server topology

    To install a three-server topology, install the management server and the collection server and database on server A, the reporting database on server B, and then the distribution server on server C.

    "
    Now as my DB resides on another server . how can i install collection and DB server  with FCS management server ?
    3. While installing only management server role , it gives error " collection server components not found" 
     
    What i am understanding in my scenario is to install Mangement server ( FCS console ) on Server A , BD , collection and reporting on server B , and WSUS or SCE on server C.

    Does i am going right diection
    Friday, January 2, 2009 4:09 AM
  • Hi!

    1. No, the FCS central management roles needs a SQL server (enterprise or standard edition)
    2. Yes, you can install all the db roles on your SQL server Collection, collection db, reporting, reporting db (the 3:server setup decribes it a bit differently, sorry)
    just like you specify in your conlusion. 

    3. If you are getting this error yuo are probably installing it in the wrong order. the management server role should be installed last, since it relies on the other roles beeing present.

    /j 
    MCSE, forefront spec | www.msforefront.com
    Sunday, January 4, 2009 12:08 PM
  • thanks for clearing things , now i am trying to install the collection and DB role on my sql 2005 box but i got error while installing the reporting server. here is the log of the installation. I have checked for the error with the exit code but i am still not able to resolve it. FYI there was no other process running for msiexec.exe. How to resolve this error?

    Number of verifications started: [1/8/2009 4:30:16 PM]

    [1/8/2009 4:30:17 PM] Verification(Verifying operating system requirements)


    [1/8/2009 4:30:17 PM] Verification(Verifying hardware requirements)
    Warning: Having two or more processors is recommended for the specified component(s).  Recommended processor speed (in MHz): 2850
    Warning:  More disk space is recommended for the specified component(s).  Recommended available disk space on drive C (in MB): 76800

    [1/8/2009 4:30:23 PM] Verification(Verifying software prerequisites)


    [1/8/2009 4:30:24 PM] Verification(Verifying collection database)


    [1/8/2009 4:30:25 PM] Verification(Verifying access to reporting server)


    [1/8/2009 4:30:26 PM] Verification(Verifying reporting database configuration)


    [1/8/2009 4:31:46 PM] Verification(Verifying URLs for reports)


    [1/8/2009 4:31:46 PM] Verification(Verifying DAS account)


    [1/8/2009 4:31:47 PM] Verification(Verifying DTS account)


    [1/8/2009 4:31:47 PM] Verification(Verifying reporting database service startup)

    Number of verifications completed: [1/8/2009 4:31:47 PM]
    Tasks started: [1/8/2009 4:32:23 PM]
    Root Directory: G:\FCS\server
    Current Directory: G:\FCS\AUTORUN
    [1/8/2009 4:32:23 PM] Task(Install MOM Reporting Service)
    Starting Install MOM Reporting Service.
    [1/8/2009 4:32:23 PM] Task(Install MOM Reporting Service)
    Starting C:\WINDOWS\system32\msiexec.exe.
    [1/8/2009 4:32:23 PM] Task(Install MOM Reporting Service)
    Process command 'C:\WINDOWS\system32\msiexec.exe'
    [1/8/2009 4:32:23 PM] Task(Install MOM Reporting Service)
    Process arguments ' /i "g:\fcs\Server\MOMReporting.msi" ROSETTA_SERVER="GDC-SQL01-PC" SQLSVR_INSTANCE="GDC-SQL01-PC\fcs" TASK_USER_ACCOUNT="dharm.singh" TASK_USER_PASSWORD="*****" TASK_USER_DOMAIN="india" REPORTING_USER="dharm.singh" REPORTING_PASSWORD="*****" REPORTING_DOMAIN="india" MOM_DB_SERVER="GDC-SQL01-PC\fcs" INSTALLDIR="e:\Program Files\Microsoft Forefront\Client Security\Server\Reporting" REPORT_SERVER_VDIR="ReportServer$fcs" REPORT_MANAGER_VDIR="Reports$fcs" HttpConnectionType="http://" DB_SIZE="2048" AUTOMATICALLY_DETECT_ROSETTA_VDIRS="0" /qn /l*v "e:\Program Files\Microsoft Forefront\Client Security\Server\Logs\MOMReporting.log"'
    [1/8/2009 4:32:30 PM] Task(Install MOM Reporting Service)

    [1/8/2009 4:32:30 PM] Task(Install MOM Reporting Service)
    The following process failed.
    Process: C:\WINDOWS\system32\msiexec.exe
    Exit code: 1603Number of tasks completed: [1/8/2009 4:32:30 PM]



    Thursday, January 8, 2009 11:07 AM
  • Here is also some part of momreporting.log file for further ref
    PreReqResultDlg_Title_PreReq_Met = Prerequisite Check Passed
    Property(S): PreReqResultDlg_Title_PreReq_Recommended_Not_Met = Prerequisite Check Passed with Warnings
    Property(S): PreReqResultDlg_Title_PreReq_Not_Met = Prerequisite Check Failed
    Property(S): ButtonText_ViewLog = &View Log
    Property(S): ReportingUserDlg_Title = Reporting User Account
    Property(S): ReportingUserDlg_Desc = Specify the credentials that should be used by the MOM Reporting Server to connect to the MOM Reporting database.
    Property(S): This_Computer =  (this Computer)
    Property(S): VersionNT = 502
    Property(S): SecureCustomProperties = MOMX_REPORTING_FOUND
    Property(S): Redist.51D569E0_8A28_11D2_B962_006097C4DE24 = C:\WINDOWS\system32\
    Property(S): MS.51D569E0_8A28_11D2_B962_006097C4DE24 = C:\WINDOWS\system32\
    Property(S): System.51D569E0_8A28_11D2_B962_006097C4DE24 = C:\WINDOWS\system32\
    Property(S): Redist.51D569E3_8A28_11D2_B962_006097C4DE24 = C:\WINDOWS\system32\
    Property(S): MS.51D569E3_8A28_11D2_B962_006097C4DE24 = C:\WINDOWS\system32\
    Property(S): System.51D569E3_8A28_11D2_B962_006097C4DE24 = C:\WINDOWS\system32\
    Property(S): ReportingModuleDir.B8A67CEF_63FF_40C5_B79F_68FE309F3E50 = E:\Program Files\Microsoft Forefront\Client Security\Server\Reporting\
    Property(S): REPORTING_DIR.B8A67CEF_63FF_40C5_B79F_68FE309F3E50 = E:\Program Files\Microsoft Forefront\Client Security\Server\Reporting\Reporting\
    Property(S): RESOURCE_DIR.B8A67CEF_63FF_40C5_B79F_68FE309F3E50 = E:\Program Files\Microsoft Forefront\Client Security\Server\Reporting\Reporting\en\
    Property(S): DATABASE_DIR.B8A67CEF_63FF_40C5_B79F_68FE309F3E50 = E:\Program Files\Microsoft Forefront\Client Security\Server\Reporting\Database\
    Property(S): SCHEMA_DIR.B8A67CEF_63FF_40C5_B79F_68FE309F3E50 = E:\Program Files\Microsoft Forefront\Client Security\Server\Reporting\Schema\
    Property(S): ServerReportingCmnModuleDir.0FBCB50B_2336_4A38_9BCC_74F7EB32265C = E:\Program Files\Microsoft Forefront\Client Security\Server\Reporting\
    Property(S): PackageCode = {F51B3310-5805-4174-86B8-AF0013E818DD}
    Property(S): ProductState = -1
    Property(S): PackagecodeChanging = 1
    Property(S): HTTPCONNECTIONTYPE = http://
    Property(S): CURRENTDIRECTORY = G:\FCS\AUTORUN
    Property(S): CLIENTUILEVEL = 3
    Property(S): CLIENTPROCESSID = 7348
    Property(S): VersionDatabase = 200
    Property(S): VersionMsi = 3.01
    Property(S): WindowsBuild = 3790
    Property(S): ServicePackLevel = 2
    Property(S): ServicePackLevelMinor = 0
    Property(S): MsiNTProductType = 3
    Property(S): WindowsFolder = C:\WINDOWS\
    Property(S): WindowsVolume = C:\
    Property(S): System16Folder = C:\WINDOWS\system\
    Property(S): RemoteAdminTS = 1
    Property(S): TempFolder = C:\DOCUME~1\DHARM~1.SIN\LOCALS~1\Temp\
    Property(S): CommonFilesFolder = C:\Program Files\Common Files\
    Property(S): AppDataFolder = C:\Documents and Settings\dharm.singh\Application Data\
    Property(S): FavoritesFolder = C:\Documents and Settings\dharm.singh\Favorites\
    Property(S): NetHoodFolder = C:\Documents and Settings\dharm.singh\NetHood\
    Property(S): PersonalFolder = C:\Documents and Settings\dharm.singh\My Documents\
    Property(S): PrintHoodFolder = C:\Documents and Settings\dharm.singh\PrintHood\
    Property(S): RecentFolder = C:\Documents and Settings\dharm.singh\Recent\
    Property(S): SendToFolder = C:\Documents and Settings\dharm.singh\SendTo\
    Property(S): TemplateFolder = C:\Documents and Settings\All Users\Templates\
    Property(S): CommonAppDataFolder = C:\Documents and Settings\All Users\Application Data\
    Property(S): LocalAppDataFolder = C:\Documents and Settings\dharm.singh\Local Settings\Application Data\
    Property(S): MyPicturesFolder = C:\Documents and Settings\dharm.singh\My Documents\My Pictures\
    Property(S): AdminToolsFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Administrative Tools\
    Property(S): StartupFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
    Property(S): StartMenuFolder = C:\Documents and Settings\All Users\Start Menu\
    Property(S): DesktopFolder = C:\Documents and Settings\All Users\Desktop\
    Property(S): FontsFolder = C:\WINDOWS\Fonts\
    Property(S): GPTSupport = 1
    Property(S): OLEAdvtSupport = 1
    Property(S): ShellAdvtSupport = 1
    Property(S): Intel = 6
    Property(S): PhysicalMemory = 2048
    Property(S): VirtualMemory = 4027
    Property(S): AdminUser = 1
    Property(S): LogonUser = dharm.singh
    Property(S): UserSID = S-1-5-21-3234455216-262905174-1588703517-2492
    Property(S): UserLanguageID = 1033
    Property(S): ComputerName = GDC-SQL01-PC
    Property(S): SystemLanguageID = 1033
    Property(S): ScreenX = 800
    Property(S): ScreenY = 600
    Property(S): CaptionHeight = 19
    Property(S): BorderTop = 1
    Property(S): BorderSide = 1
    Property(S): TextHeight = 16
    Property(S): ColorBits = 32
    Property(S): TTCSupport = 1
    Property(S): Time = 16:51:10
    Property(S): Date = 1/8/2009
    Property(S): MsiWin32AssemblySupport = 5.2.3790.3959
    Property(S): RedirectedDllSupport = 2
    Property(S): DATABASE = C:\WINDOWS\Installer\b3b5eb0d.msi
    Property(S): OriginalDatabase = g:\fcs\Server\MOMReporting.msi
    Property(S): UILevel = 2
    Property(S): ACTION = INSTALL
    Property(S): ROOTDRIVE = g:\
    Property(S): CostingComplete = 1
    Property(S): OutOfDiskSpace = 0
    Property(S): OutOfNoRbDiskSpace = 0
    Property(S): PrimaryVolumeSpaceAvailable = 0
    Property(S): PrimaryVolumeSpaceRequired = 0
    Property(S): PrimaryVolumeSpaceRemaining = 0
    Property(S): CLUSTERED = 0
    MSI (s) (28:58) [16:51:10:289]: Note: 1: 1708
    MSI (s) (28:58) [16:51:10:289]: Product: Microsoft Operations Manager 2005 Reporting -- Installation failed.

    MSI (s) (28:58) [16:51:10:305]: Cleaning up uninstalled install packages, if any exist
    MSI (s) (28:58) [16:51:10:305]: MainEngineThread is returning 1603
    MSI (s) (28:A8) [16:51:10:414]: Destroying RemoteAPI object.
    MSI (s) (28:98) [16:51:10:414]: Custom Action Manager thread ending.
    === Logging stopped: 1/8/2009  16:51:10 ===
    MSI (c) (B4:24) [16:51:10:414]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (B4:24) [16:51:10:414]: MainEngineThread is returning 1603
    === Verbose logging stopped: 1/8/2009  16:51:10 ===


    Thursday, January 8, 2009 11:42 AM