Skip to content

install-sql-server-powershell.md

Latest commit

 

History

History
41 lines (29 loc) · 3.14 KB

install-sql-server-powershell.md

File metadata and controls

41 lines (29 loc) · 3.14 KB
title Install SQL Server PowerShell | Microsoft Docs
ms.custom
ms.date 09/05/2017
ms.prod sql
ms.reviewer
ms.suite sql
ms.technology install
ms.tgt_pltfrm
ms.topic conceptual
ms.assetid 854c0b2f-02d2-46a4-a8cc-6b7a5d191cf8
caps.latest.revision 9
author MashaMSFT
ms.author mathoma
monikerRange >=sql-server-2016||=sqlallproducts-allversions
manager craigg

Install SQL Server PowerShell

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]

[!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: