Windows Server 2012

.NET 4.0 & PowerShell 4.0

Steps:

  1. Install .NET 4.5.2 from https://www.microsoft.com/en-ca/download/details.aspx?id=42642
  2. Install Windows Management Framework 4.0 and restart from https://www.microsoft.com/en-ca/download/details.aspx?id=40855 (Alternative)

Microsoft Command Line Utilities for SQL Server

  1. Microsoft Visual C++ Redistributable – https://support.microsoft.com/en-ca/help/2977003/the-latest-supported-visual-c-downloads
  2. ODBC Driver for SQL Server – https://docs.microsoft.com/en-ca/sql/connect/odbc/download-odbc-driver-for-sql-server
  3. Install Microsoft Command Line Utilities for SQL Server – https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility

SQL PowerShell Tools (For Backups)

  1. Install Microsoft SQL Server System CLR Types – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SQLSysClrTypes.msi
  2. Install SQL Server Management Objects – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SharedManagementObjects.msi
  3. Install Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2016 SP2 – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/PowerShellTools.msi

SQL Server Management Studio

  1. Install SQL Server Management Studio – https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

 

.NET 4.0 & PowerShell 4.0

Steps:

  1. Install .NET 4.5.2 from https://www.microsoft.com/en-ca/download/details.aspx?id=42642
  2. Install Windows Management Framework 4.0 and restart from https://www.microsoft.com/en-ca/download/details.aspx?id=40855 (Alternative)

Microsoft Command Line Utilities for SQL Server

  1. Microsoft Visual C++ Redistributable – https://support.microsoft.com/en-ca/help/2977003/the-latest-supported-visual-c-downloads
  2. ODBC Driver for SQL Server – https://docs.microsoft.com/en-ca/sql/connect/odbc/download-odbc-driver-for-sql-server
  3. Install Microsoft Command Line Utilities for SQL Server – https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility

SQL PowerShell Tools (For Backups)

  1. Install Microsoft SQL Server System CLR Types – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SQLSysClrTypes.msi
  2. Install SQL Server Management Objects – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SharedManagementObjects.msi
  3. Install Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2016 SP2 – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/PowerShellTools.msi

Choose your Server OS