How to install PowerShell SQLServer module in a specific directory
top of page
Writer's picturerajendra gupta

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

677 views0 comments

Recent Posts

See All
bottom of page