Skip to content

Sample ReportOnly Report

EdVassie edited this page Feb 11, 2020 · 2 revisions
Previous Configuration Report File

A sample SQL FineBuild /ReportOnly report is shown below.This report was produced using the following parameters, with other options allowed to use default values:

/IAcceptLicenseTerms                                    
/Type:Workstation                                       
/SAPWD:"UseAL0ngPa55phrase!"                            
/GroupDBA:"GBGGDBAS01"                                  
/SetupAlwaysOn:Yes                                      
/AGName:PDGB01SQLS7181                                  
/SQLSVCAccount:"ROOT\ServGB_SQLDB_1$"                   
/RSSVCACCOUNT:"ROOT\ServGB_SQLRS_1$"                    
/ReportOnly
SQL FineBuild Configuration Report
  
  SQL FineBuild process started 2020/02/11 at 14:02:09
  Configuration Report produced 11/02/2020 at 14:02:39
  
  
SQL FineBuild Execution Environment
  
  SQL FineBuild Version      V3.5.0B1
  Server Name                PDGB01SQLS0081
  Operating System Name      Windows Server 2019 Standard
  Operating System Level     RTM
  Operating System Platform  X64
  
  SQL Server Version         SQL2019
  /Type:                     WORKSTATION
  /Action:                   INSTALL
  /Edition:                  ENTERPRISE EVALUATION (Assumed)
  /Instance:                 MSSQLSERVER
  /SPLevel:                  RTM
  Reboot count               0
  
  /IAcceptLicenseTerms is present
    This means that you accept the license terms of FineBuild and the licence terms of all products that FineBuild installs
  
  SQL FineBuild Log File     "C:\Program Files\Microsoft SQL Server\FineBuildLogs\FineBuildInstallWORKSTATIONMSSQLSERVER.txt"
  

SQL FineBuild Messages

  ERROR Messages
    None

  WARNING Messages
    None

  INFO Messages
    SetupNonSAAccounts       set to NO: Non-sa Accounts can not be configured when /GroupDBANonSA: is blank
    SetupIIS                 set to YES: IIS mandatory for Master Data Services
    SetupRSAlias             set to YES: RS Alias required if IIS installed
    /RSAlias: set to PDGB01SQLS7181
    The following Parameters set to N/A due to OS Windows Server 2019 Standard
      SetupMSI45
    The following Parameters set to N/A due to SQL Version SQL2019
      SetupPerfDash SetupSSDTBI

SQL FineBuild Setup Parameters

  Parameters are described at https://github.com/SQL-FineBuild/Common/wiki/FineBuild-Setup-Parameters

  Parameter                  Value     Status

  /SetupPowerCfg:            NO       
  /SetupNoDefrag:            NO       
  /SetupWinAudit:            N/A      
  /SetupFirewall:            YES      
  /SetupNetName:             N/A      
  /SetupNetBind:             N/A      
  /SetupNoTCPNetBios:        YES      
  /SetupNoTCPOffload:        YES      
  /SetupTLS12:               YES      
  /SetupNoSSL3:              YES      
  /SetupKerberos:            YES      
  /SetupNoWinGlobal:         YES      
  /SetupNoDriveIndex:        NO       
  /SetupShares:              YES      
  /SetupTempWin:             YES      

  /SetupSlipstream:          N/A      
  /SetupKB2919442:           N/A      
  /SetupKB2919355:           N/A      
  /SetupDTCCID:              YES      
  /SetupDTCNetAccess:        NO       
  /SetupDTCCluster:          N/A      
  /SetupKB3090973:           N/A      
  /SetupJRE:                 YES      
  /SetupNet3:                YES      
  /SetupIIS:                 YES      
  /SetupMSI45:               N/A      
  /SetupPS1:                 N/A      
  /SetupPS2:                 N/A      
  /SetupKB925336:            N/A      
  /SetupKB933789:            N/A      
  /SetupKB937444:            N/A      
  /SetupKB956250:            N/A      
  /SetupNet4:                YES      
  /SetupKB4019990:           N/A      
  /SetupNet4x:               YES      
  /SetupRSAT:                N/A      
  /SetupPSRemote:            YES      
  /SetupSQLDB:               YES      
  /SetupSQLDBCluster:        N/A      
  /SetupSQLDBAG:             YES      
  /SetupSQLDBRepl:           YES      
  /SetupSQLDBFS:             YES      
  /SetupSQLDBFT:             YES      
  /SetupDQC:                 YES      
  /SetupSQLAS:               YES      
  /SetupSQLASCluster:        N/A      
  /SetupSQLIS:               YES      
  /SetupISMaster:            NO       
  /SetupISWorker:            NO       
  /SetupSQLNS:               N/A      
  /SetupBIDS:                N/A      
  /SetupDRUClt:              NO       
  /SetupDRUCtlr:             NO       
  /SetupPolyBase:            NO       
  /SetupAnalytics:           NO       
  /SetupRServer:             NO       
  /SetupPython:              NO       
  /SetupClusterShares:       N/A      
  /SetupPolyBaseCluster:     N/A      
  /SetupSSISCluster:         N/A      

  /SetupSP:                  YES      
  /SetupSPCU:                YES      
  /SetupSPCUSNAC:            YES      
  /SetupBOL:                 YES      

  /SetupSQLPowershell:       YES      
  /SetupVS2005SP1:           N/A      
  /SetupKB932232:            N/A      
  /SetupKB954961:            N/A      
  /SetupVS2010SP1:           N/A      
  /SetupMBCA:                YES      
  /SetupReportViewer:        YES      
  /SetupSQLBC:               YES      
  /SetupSQLCE:               NO       
  /SetupSSMS:                YES      
  /SetupKB2862966:           N/A      
  /SetupVC2010:              YES      
  /SetupAlwaysOn:            YES      
  /SetupAOAlias:             YES      
  /SetupSSDTBI:              N/A      
  /SetupMDXStudio:           YES      
  /SetupBIDSHelper:          YES      
  /SetupDTSDesigner:         N/A      
  /SetupDTSBackup:           N/A      
  /SetupDimensionSCD:        YES      
  /SetupRawReader:           N/A      
  /SetupPowerBI:             YES      
  /SetupRSIndexes:           YES      
  /SetupRSAdmin:             YES      
  /SetupRSExec:              NO       
  /SetupSQLRSCluster:        N/A      
  /SetupRSAlias:             YES      
  /SetupRSKeepAlive:         YES      
  /SetupRptTaskPad:          YES      
  /SetupRSScripter:          YES      
  /SetupRSLinkGen:           YES      
  /SetupPowerBIDesktop:      NO       
  /SetupBPAnalyzer:          YES      
  /SetupJavaDBC:             YES      
  /SetupDB2OLE:              YES      
  /SetupCacheManager:        YES      
  /SetupIntViewer:           N/A      
  /SetupMDS:                 YES      
  /SetupPerfDash:            N/A      
  /SetupSystemViews:         YES      
  /SetupSQLNS:               N/A      
  /SetupStreamInsight:       NO       
  /SetupSemantics:           YES      
  /SetupDQ:                  YES      
  /SetupDistributor:         NO       
  /SetupABE:                 YES      
  /SetupXEvents:             N/A      
  /SetupPDFReader:           YES      
  /SetupProcExp:             YES      
  /SetupProcMon:             YES      
  /SetupRMLTools:            YES      
  /SetupSQLNexus:            YES      
  /SetupTrouble:             YES      
  /SetupXMLNotepad:          YES      
  /SetupPlanExplorer:        YES      
  /SetupPlanExpAddin:        YES      
  /SetupZoomIt:              YES      
  /SetupSQLTools:            YES      

  /SetupDCom:                YES      
  /SetupNetwork:             YES      
  /SetupParam:               YES      
  /SetupServices:            YES      
  /SetupServiceRights:       YES      
  /SetupAPCluster:           N/A      
  /SetupSQLServer:           YES      
  /SetupDBMail:              YES      
  /SetupSQLMail:             N/A      
  /SetupSQLInst:             YES      
  /SetupSQLAgent:            YES      
  /SetupOLAPAPI:             YES      
  /SetupOLAP:                YES      
  /SetupSSISDB:              YES      
  /SetupStdAccounts:         YES      
  /SetupSAAccounts:          YES      
  /SetupNonSAAccounts:       NO       
  /SetupDisableSA:           YES      
  /SetupCmdshell:            NO       
  /SetupSysDB:               YES      
  /SetupTempDb:              YES      
  /SetupSysIndex:            YES      
  /SetupSysManagement:       YES      
  /SetupStartJob:            YES      
  /SetupBPE:                 NO       
  /SetupDBAManagement:       YES      
  /SetupManagementDW:        YES      
  /SetupPBM:                 YES      
  /SetupGenMaint:            YES      
  /SetupGovernor:            YES      
  /SetupDBOpts:              YES      
  /SetupAODB:                NO       
  /SetupAOProcs:             YES      
  /SetupMenus:               YES      
  /SetupOldAccounts:         YES      
  /SetupAutoConfig:          YES      

  /SetupCMD:                 YES      
  /SetupVS:                  YES      
  /SetupNetTrust:            YES      
  /SetupWindows:             YES      
  /SetupMyDocs:              NO       

SQL FineBuild Run Time Parameters

  Parameters are described at https://github.com/SQL-FineBuild/Common/wiki/FineBuild-Run-Time-Parameters
  Note: Not all Run Time parameters are shown on this report

  Parameter                  Value

  /PathSQLMedia:                       (Z:\SQL2019\SQL2019_Eval\)
  /PathSQLSP:                ..\Service Packs (\\cp24800\SQL Install\SQL2019\Service Packs\)
  /PathAddComp:              ..\Additional Components (Z:\Additional Components\)
  /PathAutoConfig:           AutoConfig (Z:\Additional Components\AutoConfig\)

  /VolSys:                   C         (C:\Windows) 
  /VolProg:                  C         (C:\Program Files\Microsoft SQL Server) 
  /VolTempWin:               C         (C:\Temp) 
  /VolDBA:                   C         (C:\DBAFiles) 
  /VolData:                  C         (C:\SQLFiles\MSSQL.MSSQLSERVER.Data) 
  /VolDataFS:                C         (C:\SQLFiles\MSSQL.MSSQLSERVER.Filestream) 
  /VolDataFT:                C         (C:\SQLFiles\MSSQL.MSSQLSERVER.FTData) 
  /VolSysDB:                 C         (C:\Program Files\Microsoft SQL Server) 
  /VolLog:                   C         (C:\SQLFiles\MSSQL.MSSQLSERVER.Log) 
  /VolLogTemp:               C         (C:\SQLFiles\MSSQL.MSSQLSERVER.Log) 
  /VolTemp:                  C         (C:\SQLFiles\MSSQL.MSSQLSERVER.Data) 
  /VolBackup:                C         (C:\SQLFiles\MSSQL.MSSQLSERVER.Backup) 
  /VolDataAS:                C         (C:\SQLFiles\MSAS.MSSQLSERVER.Data) 
  /VolLogAS:                 C         (C:\SQLFiles\MSAS.MSSQLSERVER.Log) 
  /VolTempAS:                C         (C:\SQLFiles\MSAS.MSSQLSERVER.Temp) 
  /VolBackupAS:              C         (C:\SQLFiles\MSAS.MSSQLSERVER.Backup) 

  /DBOwnerAccount:           DBOwner
  /NTAuthAccount:            NT AUTHORITY\NETWORK SERVICE
  /SqlAccount:               ROOT\ServGB_SQLDB_1$
  /RsAccount:                ROOT\ServGB_SQLRS_1$
  /GroupDBA:                 ROOT\GBGGDBAS01

  /AGName:                   PDGB01SQLS7181
  /ASServerMode:             TABULAR
  /SPCULevel:                CU1
  /TF12:                     T1222
  /TF13:                     T3604
  /TF14:                     T845
  /TF15:                     T3023
  /TF16:                     T4199
  /TF17:                     T2371
  /TF18:                     T2422
  /TF19:                     T9567
  /TF20:                     T460


End of Report

Copyright FineBuild Team © 2014 - 2020. License and Acknowledgements

Previous Configuration Report File Top

Key SQL FineBuild Links:

SQL FineBuild supports:

  • All SQL Server versions from SQL 2019 through to SQL 2005
  • Clustered, Non-Clustered and Core implementations of server operating systems
  • Availability and Distributed Availability Groups
  • 64-bit and (where relevant) 32-bit versions of Windows

The following Windows versions are supported:

  • Windows 2022
  • Windows 11
  • Windows 2019
  • Windows 2016
  • Windows 10
  • Windows 2012 R2
  • Windows 8.1
  • Windows 2012
  • Windows 8
  • Windows 2008 R2
  • Windows 7
  • Windows 2008
  • Windows Vista
  • Windows 2003
  • Windows XP
Clone this wiki locally