×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: C++
Posted by: Frank Czap
Added: Jun 21, 2017 6:53 PM
Views: 3
FineBuild SQL server documenttion
  1. The following items are installed because they are pre-requisites for SQL Server
  2.  
  3. Item    Comment
  4. Setup Slipstream Install Media  Merge SP and CU into install media for SQL 2008 and SQL 2008 R2
  5. Install Windows 2012 R2 KB2919442       Update 1 Pre-requisite for Windows 2012 R2
  6. Install Windows 2012 R2 KB2919355       Update 1 for Windows 2012 R2
  7. Setup MSDTC CID Create new CID (GUID) for local MDTC
  8. Setup MSDTC Network Access      Allows MSDTC to be accessed over the network
  9. Setup MSDTC Cluster     Create MSDTC Cluster(s) for SQL cluster installs
  10. Register MSDTC Cluster  Register MSDTC Cluster Resource Name within FineBuild
  11. Check MSDTC Cluster Service     Check MSDTC Cluster Service is operational
  12. Install Windows 2012 R2 KB3090973       Windows MSDTC fix for Windows 2012 R2
  13. Install JRE     Install Java Runtime Engine
  14. Install .Net 2.0        Install .Net 2.0 for SQL Server 2005
  15. Install .Net 3.5        Install .Net 3.5 SP1 for all SQL Server versions
  16. Install IIS     Install IIS on Windows 2008 and above if needed by other components
  17. Install Windows Installer 4.5   Install Windows Installer 4.5 for SQL 2008 onwards
  18. Install PowerShell V1   Install PowerShell V1 for SQL Server 2008 and 2008 R2
  19. Install PowerShell V2   Install PowerShell V2 for all SQL Server versions
  20. Install Windows 2003 KB925336   Windows Installer fix for Windows 2003
  21. Install Windows 2003 KB933789   Registry permissions fix for Windows 2003
  22. Install Windows 2003 KB937444   Filestream compatibility fix for Windows 2003
  23. Install Windows 2008 KB956250   Preparation fix for .Net 4 for Windows 2008
  24. Install .Net 4.0        Install .Net 4.0 on Windows 2008 and above
  25. Install .Net 4.x        Install .Net 4.x on Windows 2008 and above
  26. Setup Distributed Replay        Setup Distributed Replay Utility (DRU)
  27. Setup RSAT      Setup Remote Server Administration Tools (RSAT)
  28. Setup PoSh Trusted Host Setup PowerShell Trusted Host to allow PS remote execution
  29. Pre-Requisites Reboot   Reboot if needed after pre-requisites installed
  30. SQL Install
  31. Install SQL Server
  32.  
  33. SQL FineBuild will run one of the Standard Builds listed below:
  34.  
  35. Item    Comment
  36. FineBuild Main Instance Server Build    The normal build for SQL Server database server machines
  37. FineBuild Additional Named Instance Server Build        Used if an additional SQL Server Named Instance is required on a database server
  38. FineBuild Workstation Build     The normal build for Development Workstations
  39. FineBuild Client Tools Build    The normal build for DBA Administration machines
  40. SQL Install
  41. Install SQL Post Install Tasks
  42.  
  43. The following items are performed after the SQL Server install
  44.  
  45. Item    Comment
  46. Check SQL Edition Data  Check data for the SQL Server Edition that has been installed
  47. Install Visual Studio 2005 SP1  Install VS 2005 SP1 if SQL 2005 and BIDS installed
  48. Install Windows 2008 KB932232   VS 2005 SP1 fix for Windows 2008
  49. Install VS 2005 SP1 KB954961    VS 2005 SP1 fix for SQL Server 2008 and SQL Server 2008 R2
  50. Setup Analytics Setup R Services Configuration
  51. Install Visual Studio 2010 SP1  Install VS 2010 SP1 if SQL2012 or SQL2014 is installed
  52. Setup SSMS      Setup SQL 2016 SSMS
  53. Install Windows 2012 R2 KB2862966       Cyptography update for Windows 2012 R2
  54. Setup PolyBase Cluster  Create PolyBase cluster
  55. Setup SSIS Cluster      Create SSIS cluster
  56. Setup Cluster Bindings  Cluster post-install configuration
  57. Post-Install Reboot     Reboot if needed after SQL Server and post-requisites installed
  58. SQL Install
  59. SQL Fixes Install
  60.  
  61. The following items are included in the SQL Fixes install. All tasks in this process are performed by the FineBuild3InstallFixes script.
  62.  
  63. Item    Comment
  64. Install SQL Service Pack        Install requested Service Pack if not already included in Slipstream processing
  65. Install SQL Cumulative Update   Install requested Cumulative Update if not already included in Slipstream processing
  66. Install SNAC Update     Install SQL Server Native Client (SNAC) update
  67. Install SQL Books Online Update Install latest SQL Server Books Online (BOL) update
  68. Post-Fix Tasks  Tasks required after fixes have been installed
  69. Top
  70. Extra Components Install
  71.  
  72. The following Community and Microsoft components can be optionally be installed by SQL FineBuild. If you do not want to install a given product, then do not download it. The extra components are all installed by the FineBuild4InstallExtras script.
  73.  
  74. Authors of some of the Community components have donation links. If you use a component then please pay what it is worth to you.
  75.  
  76. Item    Comment
  77. Pre-Requisite Components
  78. Install Baseline Configuration Analyzer Data collection framework for Best Practice Analyzers
  79. Install Report Viewer   Enables viewing of Reports in .Net applications
  80. Install SQL 2005 Backward Compatibility Allows legacy DMO applications to run and is a pre-requisite for DTS Designer support
  81. Install SQL Compact Edition (SQLCE)     Install SQLCE Embedded Database 4.0
  82. Business Intelligence Components
  83. Install SSDT-BI Install SQL Server Data Tools for BI
  84. Install MDX Studio      Significant extra functionality for developers of MDX queries
  85. Install BIDS Helper     Adds extensive functionality to developers of SSIS packages using the Business Intelligence Development Studio
  86. SSIS and DTS Components
  87. Install DTS Designer    Provides the ability to create and edit DTS packages in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2
  88. Install DTS Backup 2000 The most effective way of exporting, importing and backing up DTS packages
  89. Install SSIS Dimension Merge SCD        A major building block within SSIS for implementing the Kimball methodology
  90. Install SSIS Raw File Reader    Examine the contents of SSIS Raw Files
  91. Report Services Components
  92. Install Taskpad View Report     A report similar to the Taskpad View in SQL Server 2000
  93. Install Reporting Services Scripter     Enables scripting of all Microsoft SQL Server Reporting Services catalogue items
  94. Install Linked Report Generator Enables automatic generation of linked reports to any number of Reporting Services folders based on a single base report
  95. SQL Database Components
  96. Install SQL Best Practice Analyzer      Allows various aspects of the SQL Server configuration and database configuration to be checked against Microsoft best practice
  97. Install Java DBC Driver Allows Java applications to access SQL Server
  98. Install OLE Provider for DB2    Allows SQL Server to access DB2 databases
  99. Install SQL Cache Manager       Allows the DBA to view and manage the SQL Server Plan Cache
  100. Install SQL Internals Viewer    Monitoring tool that looks into the SQL Server storage engine and database internals to see how data is physically allocated, organised and stored
  101. Install Master Data Services    Provides a framework and repository for managing the key reference data of an organisation
  102. Install SQL Performance Dashboard       Provides a number of Custom Reports that assist the management of SQL Server
  103. Install System Views Map        Provides a visual summary of the key system views included in SQL Server and the relationships between them
  104. Install Notification Services   Allows real-time analysis of streams of data. SQLNS is now obsolete and is replaced by StreamInsight
  105. Install StreamInsight   Allows real-time analysis of high-volume streams of data
  106. Install Semantic Search Discover statistically relevant insight through prominent words and similar content in documents stored in Full-Text indexes
  107. Install Data Quality Services   Provides a knowledge-driven data cleansing solution
  108. Install Replication Distributor Configures the Distribution databases needed when using SQL Server Replication
  109. SQL Tools Components
  110. Install Access Based Enumeration (ABE)  Prevents users who do not have access to the server from discovering information about shares and other details for the server
  111. Install Extended Events Manager Simplifies creating and viewing metadata for Extended Events Sessions
  112. Install PDF Reader      Lightweight and stable PDF Reader
  113. Install Process Explorer        Helps troubleshoot failures in SQL Server components, SSIS packages, etc.
  114. Install Process Monitor An advanced tool that shows real-time file system, registry and thread activity, often vital in troubleshooting problems within executable code
  115. Install RML Utilities   Provides analysis of SQL Server dump information
  116. Install SQL Nexus       Helps identify the root cause of SQL Server performance issues
  117. Install Troubleshooting Guide   Provides Microsoft best practice information on troubleshooting problems with SQL Server
  118. Install XML Notepad     Easy way to edit XML files
  119. Install Plan Explorer   Simplifies the process of understanding SQL Execution Plans
  120. Install Plan Explorer SSMS Addin        Adds Plan Explorer functionality into SSMS
  121. Install ZoomIt  Zoom into a portion of your Windows display
  122. Top
  123. SQL Configuration
  124.  
  125. The following items perform the best-practice configuration of SQL Server. The SQL Configuration items are performed by the FineBuild5ConfigureSQL script
  126.  
  127. Item    Comment
  128. Configure SQL Server Services
  129. Configure COM Security  Configure COM security for SSIS
  130. Configure SQL Network Protocols Configure custom ports for SQL Server
  131. Configure Service Account Names Apply Service Accounts not allowed by SQL Server install
  132. Configure SQL Startup Parameters        Add best-practice Flags to SQL Server startup parameters
  133. Configure SQL Service Recovery  Set actions to take if a SQL Service fails
  134. Configure SQL Server Instances
  135. Configure SQL Server Surface Area       Set SQL Server surface area using SP_Configure
  136. Configure Errorlog Retention    Increase number of Errorlog files retained
  137. Backup Service Master Key       Save a copy of the Service Master Key
  138. Configure Database Mail Configure Database Mail profile
  139. Configure SQL Mail      Configure legacy SQL Mail profile
  140. Configure SQL Instance Properties       Configure SQL Server Instance Properties
  141. Configure SQL Agent Properties  Configure SQL Agent Properties
  142. Configure Analysis Services Instance    Configure Analysis Services Instance
  143. Configure Integration Services Instance Configure Integration Services Instance
  144. Configure Notification Services Instance        Configure Notification Services Instance
  145. Configure Reporting Services Instance   Configure Reporting Services Instance
  146. Configure Accounts
  147. Configure Standard Accounts     Setup accounts needed within SQL Server
  148. Configure Sysadmin Accounts     Setup authorities for sysadmin accounts
  149. Configure DBA Non-Sysadmin Group        Setup authorities for DBA non-Sysadmin Group
  150. Configure SA Account    Disable and optionally rename the sa Account
  151. Configure xp_cmdshell Proxy Account     Setup the xp_cmdshell Proxy Account
  152. Configure Database Owner Account        Setup low-privilege account to own user databases
  153. Configure User Accounts Add end-user accounts to SQL Server
  154. Configure Reporting Services Administration Accounts    Configure Administration Accounts for Reporting Services
  155. Configure Reporting Services Unattended Execution Account       Setup account for SSRS Unattended report execution
  156. Backup Reporting Services Encryption Keys       Backup encryption keys used by Reporting Services
  157. Configure Reporting Services IIS Alias  Configure IIS Alias for Reporting Services
  158. Configure Database Options
  159. Configure msdb database Move msdb files to standard locations
  160. Configure tempdb database       Move tempdb files to standard locations and set number of files
  161. Configure System Index Enhancements     Additional indexes for System Tables to improve performance
  162. Configure Full-Text options     Set optimum Full-Text Search options
  163. Configure SQL Server Management
  164. Configure System DB Management  Configure routines to help manage SQL Server
  165. Configure DBA Database  Configure database for DBA routines
  166. Configure Management Data Warehouse     Collect performance-related data about SQL Server
  167. Configure Policy Based Management       Manage SQL Server according to declared Policies
  168. Configure Generic Maintenance Processes Configure backup and other maintenance for all databases
  169. Configure SSRS Keep Alive       Keep SSRS alive for immediate use
  170. Configure Database Properties   Set standard properties for all databases
  171. Configure SQL Agent Job Corrections     Fix SQL Agent jobs set up by Microsoft to cope with a Cluster Install
  172. Configure SQL Server Menu Items Set up Menu items for SQL Server components
  173. Configure Old Accounts  Remove Redundant SQL Server Accounts
  174. Top
  175. User Configuration
  176.  
  177. Item    Comment
  178. Configure Books Online Options  Configure BOL Preferences
  179. Configure Command Window Options        Configure Windows CMD Preferences
  180. Configure SSMS Options  Configure SSMS Preferences
  181. Configure Visual Studio Options Configure Visual Studio Preferences
  182. Configure Internet Options      See Reference Manual
  183. Configure Windows Options       Configure Windows Preferences
  184. Configure 'My Documents'        Configure 'My Documents' location
  185. Disable Install Login   See Reference Manual
  186. Copyright FineBuild Team © 2011 - 2017. License and Acknowledgements
  187. Top
  188. Last edited Mar 18 at 6:31 AM by EdVassie, version 69
  189.  
  190.  
  191. system requirements
  192.  
  193. FOR USE
  194.  
  195. Any of the following, x86 or x64:
  196. Windows XP
  197. Windows 2003, clustered or non-clustered
  198. Windows Vista
  199. Windows 2008, clustered or non-clustered
  200. Windows 7
  201. Windows 2008 R2, clustered or non-clustered
  202. Windows 8
  203. Windows 2012, clustered or non-clustered
  204. Windows 8.1
  205. Windows 2012 R2, clustered or non-clustered
  206. Windows 10
  207. Windows 2016, clustered or non-clustered
  208.