Cannot install SQLServer module in Powershell

20.4k Views Asked by At

I try to install Powershell SQLSERVER module by executing the following command as admin (win10, 64Bit) but it fails

PS C:\WINDOWS\system32> Install-Module -Name SqlServer
PackageManagement\Install-Package : No match was found for the specified search 
criteria and module name 'SqlServer'.
Try Get-PSRepository to see all available registered module repositories.
At C:\Program 
Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:1809 
char:21
+ ...          $null = PackageManagement\Install-Package @PSBoundParameters
+                      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: 
(Microsoft.Power....InstallPackage:InstallPackage) [Install-Package], Ex
   ception
    + FullyQualifiedErrorId : 

NoMatchFoundForCriteria,Microsoft.PowerShell.PackageManagement.Cmdlets.
InstallPackage

I have searched the web, I tried some solutions, I even talked to company admins but without luck. As they told me there is no proxy in the company, only firewall. Other colleagues can run the command without problems. The next command also fails

PS C:\WINDOWS\system32> Get-PSrepository
WARNING: Unable to find module repositories.

Any idea?

4

There are 4 best solutions below

2
user1804469 On BEST ANSWER

I ran into this. I had to run the following:

Register-PSRepository -Default
Register-PSRepository -Name PSGallery -InstallationPolicy Trusted -SourceLocation "https://www.powershellgallery.com/api/v2/" -Verbose

This errored out. Then I was able to run

Install-Module sqlserver
0
Daniel Carlozzi On

Mine got fixed enabling tls 1.2

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

0
JGlass On

Too elaborate on @Daniel_Carlozzi answer, in an elevated PowerShell window, I ran [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 which produced no output and then Install-Module -Name SqlServer -AllowClobber which warned about a Untrusted Repository.

0
Eugene Pan On

Instead of typing: Install-Module -Name SqlServer

I tried: Install-Module SqlServer

I don't know why but it worked.