Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By : Donabel Santos
Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By: Donabel Santos

Overview of this book

Table of Contents (21 chapters)
SQL Server 2014 with PowerShell v5 Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Installing SQL Server 2014 on a VM


Before we install SQL Server 2014, we need to ensure that .NET 3.5 and .NET 3.5 Service Pack 1 are installed on your VM.

.NET 3.5 is a feature you can install from Server Manager.

.NET 3.5 Service Pack 1 can be downloaded from https://www.microsoft.com/en-ca/download/details.aspx?id=22.

Once these are installed, the following steps will walk you through installing SQL Server 2014 on your virtual machine:

  1. Launch VMWare Player.

  2. Play SQL2014VM and log in using the administrator domain account.

  3. Go to Player | Removable Devices | CD/DVD | Settings.

  4. Change the ISO image file path to the SQL Server 2012 ISO file and click on OK.

  5. Once you click on OK, the Autoplay window will appear. Click on Run SETUP.EXE. If Autoplay does not appear, open Windows Explorer and navigate to the DVD drive to run setup.exe. This will open the SQL Server Installation Center window.

  6. Select Installation from the left-hand pane and choose New SQL Server stand-alone installation or add features to an existing installation.

  7. In the Product Key window, accept the default values and click on Next.

  8. In the License Terms window, select I accept the license terms and click on Next.

  9. In the Microsoft Update window, select User Microsoft Update to check for updates (recommended).

  10. In the Install Rules window, possible issues may be flagged. For our purposes, we expect to see a warning because of the domain controller and the firewall, as shown in the following screenshot:

    For security reasons, it is recommended that you do not install SQL Server on top of the domain controller, as discussed in the article at http://msdn.microsoft.com/en-us/library/ms143506.aspx. For our purposes, however, it is acceptable.

  11. On the Setup Role screen, select SQL Server Feature Installation, as shown in the following screenshot:

  12. In the Feature Selection window, make sure that you choose the following options:

    • Database Engine Services (all components)

    • Analysis Services

    • Reporting Services - Native

    • Client Tools Connectivity

    • SQL Server Data Tools

    • Integration Services

    • Documentation Components

    • Management Tools - Basic

    • Management Tools - Complete

    Feel free to choose additional features you want to try. In addition, adjust the directories if you want to store the SQL Server files somewhere other than the default directories. When done making adjustments, click on Next.

  13. The installation wizard will now check Feature Rules. If there are any errors reported, make sure that you resolve them before continuing with the installation. Click on Next.

  14. In the Instance Configuration window, select Default instance.

  15. In the Server Configuration window, in the Service Accounts tab, set up the service accounts.

  16. In the Server Configuration window, under the Collation tab, keep the default settings as is: SQL_Latin1_General_CP1_CI_AS for Database Engine and Latin1_General_CI_AS for Analysis Services.

  17. In the Database Engine Configuration window, under the Server Configuration tab, keep the default settings for Windows authentication mode as is and click on Add Current User.

  18. In the Database Engine Configuration window, under the Data Directories tab, keep the default settings.

  19. In the Database Engine Configuration window, under the FILESTREAM tab, check all checkboxes to enable filestream.

  20. In the Analysis Services Configuration window, under the Server Configuration tab, select Multidimensional and Data Mining Mode and click on Add Current User.

  21. In the Analysis Services Configuration window, under the Data Directories tab, keep the default settings.

  22. In the Reporting Services Configuration window, under the Reporting Services Native Mode section, select Install only.

  23. Click on Next to go to the Feature Configuration Rules window. If there are any errors, you need to address them before you proceed.

  24. Click on Next to go to the Ready to Install window. Review all the features, and click on Install once all the features have been reviewed and confirmed.

  25. Once the installation is complete, close the setup window.