Install the SQLASCMDLETS module?!

PowerShell Help
1

Guys, does anybody know how to install the SQLAS provider and cmdlets on a system that lacks full installation of SQL Server? I’ve tried installing:

  1. System CLR Types (PowerShellTools.msi)
  2. Shared Management Objects (SharedManagementObjects.msi)
  3. PowerShell Extensions for SQL Server (SQLSysClrTypes.msi)

, but this only adds the SQLPS module.

2

I believe it’s installed with SQL Management Studio, which can be installed stand-alone without the full SQL installation.

3

Thanks, Rob.
I was trying to avoid this, but it might be the only solution. The annoying thing is MS distributes the SMO provider and cmdlets separately, but not the AS ones.

4

UserVoice ticket

5

You can now install Sql Server Powershell Module as a total standalone without having to have Sql Server SSMS installed.
However, there are some limitations for Analysis services.

https://docs.microsoft.com/en-us/sql/analysis-services/powershell/analysis-services-powershell-reference?view=sql-analysis-services-2017

<https://port1433.com/2017/04/26/installing-the-sql-server-module-from-the-powershell-gallery/

https://docs.microsoft.com/en-us/sql/powershell/sql-server-powershell?view=sql-server-2017