-
Notifications
You must be signed in to change notification settings - Fork 10
Sample Completion Report
EdVassie edited this page Feb 11, 2020
·
3 revisions
| Previous Configuration Report File |
|---|
A sample SQL FineBuild Completion 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$"
SQL FineBuild Configuration Report
SQL FineBuild process started 2020/02/11 at 11:44:33
Configuration Report produced 11/02/2020 at 13:57:03
********************************************
*
* SQL2019 FineBuild Install Complete
*
********************************************
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 5
/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
WARNING: (5BB) Unable to find Mail Server, DB Mail profile not created
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
Service start time allowance increased to 1 minute for Reporting Services
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 Complete
/SetupNetName: N/A
/SetupNetBind: N/A
/SetupNoTCPNetBios: YES Complete
/SetupNoTCPOffload: YES Complete
/SetupTLS12: YES Complete
/SetupNoSSL3: YES Complete
/SetupKerberos: YES Complete
/SetupNoWinGlobal: YES Complete
/SetupNoDriveIndex: NO
/SetupShares: YES Complete
/SetupTempWin: YES Complete
/SetupSlipstream: N/A
/SetupKB2919442: N/A
/SetupKB2919355: N/A
/SetupDTCCID: YES Complete
/SetupDTCNetAccess: NO
/SetupDTCCluster: N/A
/SetupKB3090973: N/A
/SetupJRE: YES Bypassed, no media
/SetupNet3: YES Complete
/SetupIIS: YES Complete
/SetupMSI45: N/A
/SetupPS1: N/A
/SetupPS2: N/A
/SetupKB925336: N/A
/SetupKB933789: N/A
/SetupKB937444: N/A
/SetupKB956250: N/A
/SetupNet4: YES Already Configured
/SetupKB4019990: N/A
/SetupNet4x: YES Complete
/SetupRSAT: N/A
/SetupPSRemote: YES Complete
/SetupSQLDB: YES Complete
/SetupSQLDBCluster: N/A
/SetupSQLDBAG: YES Complete
/SetupSQLDBRepl: YES Complete
/SetupSQLDBFS: YES Complete
/SetupSQLDBFT: YES Complete
/SetupDQC: YES Complete
/SetupSQLAS: YES Complete
/SetupSQLASCluster: N/A
/SetupSQLIS: YES Complete
/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 Bypassed, included in SQL install
/SetupSPCU: YES Bypassed, included in SQL install
/SetupSPCUSNAC: YES Bypassed, no media
/SetupBOL: YES Complete
/SetupSQLPowershell: YES Complete
dbatools Complete
SqlServer Complete
/SetupVS2005SP1: N/A
/SetupKB932232: N/A
/SetupKB954961: N/A
/SetupVS2010SP1: N/A
/SetupMBCA: YES Complete
/SetupReportViewer: YES Bypassed
/SetupSQLBC: YES Complete
/SetupSQLCE: NO
/SetupSSMS: YES Complete
/SetupKB2862966: N/A
/SetupVC2010: YES Complete
/SetupAlwaysOn: YES Complete
/SetupAOAlias: YES Complete
/SetupSSDTBI: N/A
/SetupMDXStudio: YES Complete
/SetupBIDSHelper: YES Complete
/SetupDTSDesigner: N/A
/SetupDTSBackup: N/A
/SetupDimensionSCD: YES Complete
/SetupRawReader: N/A
/SetupPowerBI: YES Complete
/SetupRSIndexes: YES Complete
/SetupRSAdmin: YES Complete
/SetupRSExec: NO
/SetupSQLRSCluster: N/A
/SetupRSAlias: YES Complete
/SetupRSKeepAlive: YES Complete
/SetupRptTaskPad: YES Complete
/SetupRSScripter: YES Complete
/SetupRSLinkGen: YES Complete
/SetupPowerBIDesktop: NO
/SetupBPAnalyzer: YES Complete
/SetupJavaDBC: YES Complete
/SetupDB2OLE: YES Complete
/SetupCacheManager: YES Complete
/SetupIntViewer: N/A
/SetupMDS: YES Complete
/SetupPerfDash: N/A
/SetupSystemViews: YES Complete
/SetupSQLNS: N/A
/SetupStreamInsight: NO
/SetupSemantics: YES Complete
/SetupDQ: YES Complete
/SetupDistributor: NO
/SetupABE: YES Complete
/SetupXEvents: N/A
/SetupPDFReader: YES Complete
/SetupProcExp: YES Complete
/SetupProcMon: YES Complete
/SetupRMLTools: YES Bypassed
/SetupSQLNexus: YES Bypassed
/SetupTrouble: YES Complete
/SetupXMLNotepad: YES Complete
/SetupPlanExplorer: YES Complete
/SetupPlanExpAddin: YES Complete
/SetupZoomIt: YES Complete
/SetupSQLTools: YES Complete
/SetupDCom: YES Complete
/SetupNetwork: YES Complete
/SetupParam: YES Complete
/SetupServices: YES Complete
/SetupServiceRights: YES Configure Manually
/SetupAPCluster: N/A
/SetupSQLServer: YES Complete
/SetupDBMail: YES Bypassed, no Mail Server
/SetupSQLMail: N/A
/SetupSQLInst: YES Complete
/SetupSQLAgent: YES Complete
/SetupOLAPAPI: YES Complete
/SetupOLAP: YES Complete
/SetupSSISDB: YES Complete
/SetupStdAccounts: YES Complete
/SetupSAAccounts: YES Complete
/SetupNonSAAccounts: NO
/SetupDisableSA: YES Complete
/SetupCmdshell: NO
/SetupSysDB: YES Complete
/SetupTempDb: YES Complete
/SetupSysIndex: YES Complete
/SetupSysManagement: YES Complete
/SetupStartJob: YES Complete
/SetupBPE: NO
/SetupDBAManagement: YES Complete
/SetupManagementDW: YES Complete
/SetupPBM: YES Complete
/SetupGenMaint: YES Complete
/SetupGovernor: YES Complete
/SetupDBOpts: YES Complete
/SetupAODB: NO
/SetupAOProcs: YES Complete
/SetupMenus: YES Complete
/SetupOldAccounts: YES Complete
/SetupAutoConfig: YES Complete
KerberosConfigMgrX64 Complete
/SetupCMD: YES Complete
/SetupVS: YES Complete
/SetupNetTrust: YES Complete
/SetupWindows: YES Complete
/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 (\\cp24800\sql install\Additional Components\)
/PathAutoConfig: AutoConfig (\\cp24800\sql install\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\MSSQL15.MSSQLSERVER\MSSQL)
/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\AdHocBackup)
/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