Powershell SQLServer Modules

Question

I am developing an automation system that will grant access to SQL Server databases through Powershell by running a query. I am able to do this just fine, but my question is, do I need to install SQL Server Management Studio in order to import the modules

For example:

import-module sqlserver

When I attempted this before I installed studio I was unable to install because Powershell could not find the module.

Once I had the module imported, I was able to run the follow command:

Invoke-sqlcmd -query "grant select, insert, update on test to sqlsupport;" -serverinstance "test\test"

Is there a way to have the modules available without studio?

Akash Masand · Accepted Answer · 2018-09-14 04:14:39Z

2

You can install this as an independent PowerShell module.

Kindly open Powershell as an administrator and do the following:

Run Set-ExecutionPolicy unrestricted
Run Install-Module sqlserver
Run Import-Module sqlserver

This should allow you to run Sql Commands through Powershell without installing SQL Server Management Studio.

answered Sep 14, 2018 at 4:14

Akash Masand

1,7711 gold badge20 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

briantist · Accepted Answer · 2016-07-11 20:17:46Z

1

Yes, in the same installer for SSMS, by selecting the components to install, you can choose to install only the PowerShell cmdlets and not the rest of SSMS.

You should also make sure you're using the latest module (they changed the name from SQLPS to SqlServer); as of this writing it's the July 2016 update.

answered Jul 11, 2016 at 20:17

briantist

48.3k6 gold badges94 silver badges139 bronze badges

2 Comments

Brandon Wilson Over a year ago

I don't see where during the install it will give me the option to select which components are install. I have two options, Install or Close.

briantist Over a year ago

@BrandonWilson it may not be the SSMS installer, it might be a "tools" installer or the SQL with advanced services installer, where you can choose not to install SSMS but just install the powershell cmdlets.

Collectives™ on Stack Overflow

Powershell SQLServer Modules

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related