'Cannot install SQLServer module in Powershell
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?
Solution 1:[1]
Mine got fixed enabling tls 1.2
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Solution 2:[2]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Daniel Carlozzi |
| Solution 2 | JGlass |
