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

34 views0 comments