Cannot install SQLServer module in Powershell

Question

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?

Get-PSRepository -Verbose. Also, try PowerShell -NoProfile to see if you've got something in your profile that's interfering. If all else fails, you can always try to Register-PSRepository manually (Register-PSRepository -Name PSGallery -InstallationPolicy Trusted -SourceLocation "https://www.powershellgallery.com/api/v2/" -Verbose). — Jeroen Mostert
– Jeroen Mostert, Commented Feb 4, 2019 at 16:45
thanks, I tried everything but fail. When I tried to register PSRepository, it brought back an error saying PowerShell Gallery is currently anavailable — user3417479
– user3417479, Commented Feb 4, 2019 at 16:54
Then it sounds like you're proxied/firewalled. Try accessing powershellgallery.com/api/v2 in your browser; if that fails you know it's not PowerShell's fault. (If that works, it can still be a firewall/anti-virus issue where PowerShell specifically has been blocked from making outgoing connections, or at least not permitted to do so.) — Jeroen Mostert
– Jeroen Mostert, Commented Feb 4, 2019 at 16:55
I can open in my browser both www.powershellgallery.com and powershellgallery.com/api/v2. Other colleagues can run all commands thus this happens only on my laptop. The -Verbose command you gave me was useful. Something is wrong with Registered repositories. — user3417479
– user3417479, Commented Feb 4, 2019 at 17:00

Toby Speight · Accepted Answer · 2019-10-30 19:12:20Z

11

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

edited Oct 30, 2019 at 19:12

Toby Speight

32.1k58 gold badges82 silver badges117 bronze badges

answered Oct 30, 2019 at 18:17

user1804469

1362 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3417479 Over a year ago

Although I got some errors, it finally worked. thanks.

CharlesMighty Over a year ago

For me I had to use "Install-Module -Name SqlServer -AllowClobber" and it worked, thanks for pointing me in the right direction

Daniel Carlozzi · Accepted Answer · 2020-11-09 14:06:57Z

7

Mine got fixed enabling tls 1.2

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

answered Nov 9, 2020 at 14:06

Daniel Carlozzi

811 silver badge4 bronze badges

Comments

JGlass · Accepted Answer · 2022-02-24 18:01:37Z

0

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.

answered Feb 24, 2022 at 18:01

JGlass

1,4672 gold badges13 silver badges27 bronze badges

Comments

Eugene Pan · Accepted Answer · 2022-10-07 02:52:06Z

0

Instead of typing: Install-Module -Name SqlServer

I tried: Install-Module SqlServer

I don't know why but it worked.

answered Oct 7, 2022 at 2:52

Eugene Pan

1

Collectives™ on Stack Overflow

Cannot install SQLServer module in Powershell

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related