-
Notifications
You must be signed in to change notification settings - Fork 10
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