top of page

How to install PowerShell SQLServer module in a specific directory

Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:\Program Files\WindowsPowerShell\Modules.' for SQL Server module.

By default, if we install a PowerShell module, it gets saved in the C:\Program Files\WindowsPowerShell\Modules directory. Recently, in a situation user has limited administrator permission on VM. He could not write to the directory C:\Program Files\WindowsPowerShell\Modules. Therefore, the sqlserver module could not be loaded.

Install-Module SQLServer

It gives the following error message.

How do you install the SQLServer module in this case?

Use the following PS script to install and import the module in a specific directory. Here, I specified the directory name as C:\Temp\PSModule. You can modify the path as per your requirements.

if ($env:PSModulePath -notlike "*c:\Temp\PSModule*")
if((Get-Item c:\Temp\PSModule -ErrorAction SilentlyContinue ) -eq $null) {
New-Item -Path c:\Temp\PSModule -Name "Modules" -ItemType "directory"
$env:PSModulePath += ";c:\Temp\PSModule"
Save-Module -Name SqlServer -Path c:\Temp\PSModule
Import-Module -Name sqlserver

It downloads and installs the SqlServer PowerShell module in the specified directory, as shown below.

Verify SqlServer PowerShell module

597 views0 comments


bottom of page