Windows Server 2016

PowerShell 4.0+

Server 2016 already comes with PowerShell 5.1.

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

SQL Server PowerShell Module (For Backups)

The SQL Server PowerShell Module is required for backups. WAM will automatically detect if it is installed, and if not, it will attempt to install it from the PowerShell Gallery. For disconnected systems, please contact our Support for instructions on how to import the module on offline systems.

SQL Server Management Studio

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

 

PowerShell 4.0+

Server 2016 already comes with PowerShell 5.1.

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

SQL Server PowerShell Module (For Backups)

The SQL Server PowerShell Module is required for backups. WAM will automatically detect if it is installed, and if not, it will attempt to install it from the PowerShell Gallery. For disconnected systems, please contact our Support for instructions on how to import the module on offline systems.

Choose your Server OS