Skip to content

install-sql-server-powershell.md

Latest commit

 

History

History
35 lines (24 loc) · 3.08 KB

install-sql-server-powershell.md

File metadata and controls

35 lines (24 loc) · 3.08 KB
title Install SQL Server PowerShell
description This article describes the SQL Server PowerShell components that Setup installs when you select SQL Server features that require PowerShell support.
author rwestMSFT
ms.author randolphwest
ms.date 09/05/2017
ms.prod sql
ms.technology install
ms.topic conceptual
ms.custom intro-installation
monikerRange >=sql-server-2016

Install SQL Server PowerShell

[!INCLUDE SQL Server -Windows Only]

[!INCLUDEssNoVersion] Setup automatically configures PowerShell components.

You install the software that provides [!INCLUDEssNoVersion] support for Windows PowerShell by using [!INCLUDEssNoVersion] Setup. When you select any [!INCLUDEssNoVersion] features that require PowerShell support, Setup installs the following [!INCLUDEssNoVersion] PowerShell components:

  • The [!INCLUDEssNoVersion] PowerShell snap-ins. The snap-ins are dll files that implement two types of Windows PowerShell support for [!INCLUDEssNoVersion]:

    • A set of [!INCLUDEssNoVersion] cmdlets. Cmdlets are commands that implement a specific action. For example, Invoke-Sqlcmd runs a [!INCLUDEtsql] or XQuery script that can also be run by using the sqlcmd utility, and Invoke-PolicyEvaluation reports whether [!INCLUDEssNoVersion] objects comply with policy-based management policies.

    • A [!INCLUDEssNoVersion] provider. The provider lets you navigate the hierarchy of [!INCLUDEssNoVersion] objects using a path similar to a file system path. Each object is associated with a class from the [!INCLUDEssNoVersion] Management object models. You can use the methods and properties of the class to perform work on the objects. For example, if you cd to a databases object in a path, you can use the methods and properties of the Microsoft.SqlServer.Managment.SMO.Database class to manage the database.

  • The sqlps module that is imported into Windows PowerShell sessions to load the [!INCLUDEssNoVersion] snap-ins.

  • [!INCLUDEssManStudioFull] supports starting Windows PowerShell sessions from the Object Explorer tree. [!INCLUDEssNoVersion] Agent supports Windows PowerShell job steps.

Windows Server 2012 and later and Windows 8 and later come with PowerShell installed and configured. For information about installing Windows PowerShell see Installing Windows PowerShell.

For more information, see: