Windows Server 2012
-
PowerShell 4.0
Steps:
- Install .NET 4.5.2 from https://www.microsoft.com/en-ca/download/details.aspx?id=42642
- 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
- 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
Steps:
- Install .NET 4.5.2 from https://www.microsoft.com/en-ca/download/details.aspx?id=42642
- 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
- 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