Windows Server 2012 R2
-
PowerShell 4.0
Server 2012 R2 already comes with PowerShell 4.0
Microsoft Command Line Utilities for SQL Server
- Microsoft Visual C++ Redistributable – https://support.microsoft.com/en-ca/help/2977003/the-latest-supported-visual-c-downloads
- ODBC Driver for SQL Server – https://docs.microsoft.com/en-ca/sql/connect/odbc/download-odbc-driver-for-sql-server
- Install Microsoft Command Line Utilities for SQL Server – https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility
SQL PowerShell Tools (For Backups)
- Install Microsoft SQL Server System CLR Types – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SQLSysClrTypes.msi
- Install SQL Server Management Objects – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SharedManagementObjects.msi
- 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
- Install SQL Server Management Studio – https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
-
PowerShell 4.0
Server 2012 R2 already comes with PowerShell 4.0
Microsoft Command Line Utilities for SQL Server
- Microsoft Visual C++ Redistributable – https://support.microsoft.com/en-ca/help/2977003/the-latest-supported-visual-c-downloads
- ODBC Driver for SQL Server – https://docs.microsoft.com/en-ca/sql/connect/odbc/download-odbc-driver-for-sql-server
- Install Microsoft Command Line Utilities for SQL Server – https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility
SQL PowerShell Tools (For Backups)
- Install Microsoft SQL Server System CLR Types – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SQLSysClrTypes.msi
- Install SQL Server Management Objects – https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SharedManagementObjects.msi
- 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