Windows Server 2008 R2

.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

SQL Server Management Studio

.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 v17 – https://learn.microsoft.com/en-ca/sql/connect/odbc/download-odbc-driver-for-sql-server?#version-17
  3. Install Microsoft Command Line Utilities for SQL Server (ODBC) – https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?tabs=odbc