[BUG] Unable to connect to SharePointOnline with 'Connect-PnPOnline'

[evazquez00]

Freshly re-imaged Windows 10 system, installing my M365 /Online tools.

AzureAD and M365 are MFA enforced.

I can connect to AzureAD, M365 and Exchange Online through PowerShell cmdlets with no issues.

I can connect to AzureAD, M365, Exchange Online and Sharepoint "Admin" and "Regular" sites via WebUI with no issues.

However, SharePoint Online is saying that it is not reachable via PowerShell cmdlet.

Here's my environment:

PS C:\> $PSVersionTable

Name                           Value
----                           -----
PSVersion                      7.3.4
PSEdition                      Core
GitCommitId                    7.3.4
OS                             Microsoft Windows 10.0.19045
Platform                       Win32NT
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0, 5.0, 5.1.10032.0, 6.0.0, 6.1.0, 6.2.0, 7.0.0, 7.1.0, 7.2.0, 7.3.4}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

PS C:\> Get-InstalledModule -Name PowerShellGet,NuGet,Az,PSFramework,PnP.PowerShell,Microsoft.Graph,PSAppInsights,RobustCloudCommand,Microsoft.Online.SharePoint.PowerShell

Version              Name                                Repository           Description
-------              ----                                ----------           -----------
3.0.21-beta21        PowerShellGet                       PSGallery            PowerShell module with commands for disc…
1.3.3                NuGet                               PSGallery            Create Nuget repos, Register Repos, Mana…
10.0.0               Az                                  PSGallery            Microsoft Azure PowerShell - Cmdlets to …
1.8.289              PSFramework                         PSGallery            General Scripting Framework, providing P…
2.1.78-nightly       PnP.PowerShell                      PSGallery            Microsoft 365 Patterns and Practices Pow…
2.0.0-rc3            Microsoft.Graph                     PSGallery            Microsoft Graph PowerShell module
0.9.6                PSAppInsights                       PSGallery            Add Application Insights to PowerShell t…
2.1.0                RobustCloudCommand                  PSGallery            Generic wrapper script that tries to ens…
16.0.23710.12000     Microsoft.Online.SharePoint.PowerS… PSGallery            Microsoft SharePoint Online Services Mod…

Here's the issue:

PS C:\> connect-PnPOnline -Url "https://insightcatastrophegroup-admin.sharepoint.com"
Connect-PnPOnline: Host not reachable
PS C:\> connect-PnPOnline -Url "https://insightcatastrophegroup-admin.sharepoint.com" -Interactive
Connect-PnPOnline: Host not reachable
PS C:\> connect-PnPOnline -Url "https://insightcatastrophegroup-admin.sharepoint.com" -UseWebLogin
Connect-PnPOnline: Host not reachable

Checking in the same PS Terminal Session to ensure DNS and network connectivity is good:

PS C:\Windows\System32> Resolve-DnsName insightcatastrophegroup-admin.sharepoint.com

Name                           Type   TTL   Section    NameHost
----                           ----   ---   -------    --------
insightcatastrophegroup-admin. CNAME  3541  Answer     insightcatastrophegroup.sharepoint.com
sharepoint.com
insightcatastrophegroup.sharep CNAME  3541  Answer     2678-ipv4v6e.clump.dprodmgd105.aa-rt.sharepoint.com
oint.com
2678-ipv4v6e.clump.dprodmgd105 CNAME  3541  Answer     191931-ipv4v6e.farm.dprodmgd105.aa-rt.sharepoint.com
.aa-rt.sharepoint.com
191931-ipv4v6e.farm.dprodmgd10 CNAME  3541  Answer     191931-ipv4v6e.farm.dprodmgd105.sharepointonline.com.akadns.net
5.aa-rt.sharepoint.com
191931-ipv4v6e.farm.dprodmgd10 CNAME  3541  Answer     191931-ipv4v6.farm.dprodmgd105.aa-rt.sharepoint.com.dual-spo-000
5.sharepointonline.com.akadns.                         3.spo-msedge.net
net
191931-ipv4v6.farm.dprodmgd105 CNAME  3541  Answer     dual-spo-0003.spo-msedge.net
.aa-rt.sharepoint.com.dual-spo
-0003.spo-msedge.net

Name       : dual-spo-0003.spo-msedge.net
QueryType  : AAAA
TTL        : 3541
Section    : Answer
IP6Address : 2620:1ec:8fa::8


Name       : dual-spo-0003.spo-msedge.net
QueryType  : AAAA
TTL        : 3541
Section    : Answer
IP6Address : 2620:1ec:8f8::8


Name       : dual-spo-0003.spo-msedge.net
QueryType  : A
TTL        : 3541
Section    : Answer
IP4Address : 13.107.138.8


Name       : dual-spo-0003.spo-msedge.net
QueryType  : A
TTL        : 3541
Section    : Answer
IP4Address : 13.107.136.8


PS C:\> ncat -zv insightcatastrophegroup-admin.sharepoint.com 443
Ncat: Version 7.92 ( https://nmap.org/ncat )
Ncat: Connected to 2620:1ec:8f8::8:443.
Ncat: 0 bytes sent, 0 bytes received in 0.10 seconds.
PS C:\>

All good there.

Am I missing a dependency? Or something else is going sideways?

[evazquez00]

Follow-up,

Using the Microsoft.Online.SharePoint.PowerShell module I am able to connect and retrieve site information, etc.:

PS C:\> Connect-SPOService -Url "https://insightcatastrophegroup-admin.sharepoint.com"

PS C:\> Get-SPOSite 

WARNING: More results were found but were not returned.  Use '-Limit ALL' to return all possible results.
Url                                                                                                               Owner                           Storage Quota
---                                                                                                               -----                           -------------
lots and lots of data

So I know that PowerShell is working and can connect - PnP still says the host is not reachable.

[YuriySamorodov]

Hi @evazquez00 , do you get the same behavior with PnP.PowerShell 2.1.81?

[evazquez00]

@YuriySamorodov

Yes - any version of PnP.PowerShell above 1.12.0 (i.e. PS 7 required) gives the same error.

Example on PS 5:

PS C:\> $PSVersionTable

Name                           Value                                                                                                                                                         
----                           -----                                                                                                                                                         
PSVersion                      5.1.19041.2673                                                                                                                                                
PSEdition                      Desktop                                                                                                                                                       
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                       
BuildVersion                   10.0.19041.2673                                                                                                                                               
CLRVersion                     4.0.30319.42000                                                                                                                                               
WSManStackVersion              3.0                                                                                                                                                           
PSRemotingProtocolVersion      2.3                                                                                                                                                           
SerializationVersion           1.1.0.1

PS C:\> Get-InstalledModule -Name PnP.PowerShell

Version              Name                                Repository           Description                                                                                                    
-------              ----                                ----------           -----------                                                                                                    
1.12.0               PnP.PowerShell                      PSGallery            Microsoft 365 Patterns and Practices PowerShell Cmdlets                                                        



PS C:\> Connect-PnPOnline -Url "https://insightcatastrophegroup-admin.sharepoint.com" -Interactive
WARNING: 
A newer version of PnP PowerShell is available: 2.1.1.

Use 'Update-Module -Name PnP.PowerShell' to update.
Use 'Get-PnPChangeLog -Release 2.1.1' to list changes.

You can turn this check off by setting the 'PNPPOWERSHELL_UPDATECHECK' environment variable to 'Off'.


PS C:\> Update-Module -Name PnP.PowerShell -Scope AllUsers

PS C:\> Get-InstalledModule -Name PnP.PowerShell

Version              Name                                Repository           Description                                                                                                    
-------              ----                                ----------           -----------                                                                                                    
2.1.1                PnP.PowerShell                      PSGallery            Microsoft 365 Patterns and Practices PowerShell Cmdlets                                                        


PS C:\> import-module pnp.powershell
import-module : Could not load file or assembly 'System.Management.Automation, Version=7.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system 
cannot find the file specified.
At line:1 char:1
+ import-module pnp.powershell
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Import-Module], FileNotFoundException
    + FullyQualifiedErrorId : System.IO.FileNotFoundException,Microsoft.PowerShell.Commands.ImportModuleCommand
 

PS C:\>

There's even a Microsoft article about PnP.Powershell that says PS v7 is required:
Import-Module : Could not load file or assembly 'System.Management.Automation

So in PowerShell 7:

PS C:\> $PSVersionTable

Name                           Value
----                           -----
PSVersion                      7.3.4
PSEdition                      Core
GitCommitId                    7.3.4
OS                             Microsoft Windows 10.0.19045
Platform                       Win32NT
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0, 5.0, 5.1.10032.0, 6.0.0, 6.1.0, 6.2.0, 7.0.0, 7.1.0, 7.2.0, 7.3.4}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

PS C:\> Get-InstalledModule -Name PnP.PowerShell

Version              Name                                Repository           Description
-------              ----                                ----------           -----------
2.1.85-nightly       PnP.PowerShell                      PSGallery            Microsoft 365 Patterns and Practices Pow…

PS C:\> Connect-PnPOnline -Url "https://insightcatastrophegroup-admin.sharepoint.com" -Interactive
Connect-PnPOnline: Host not reachable
PS C:\>

[Luca-Ferraris]

I have the same behaviour with Windows 11 (Insider Preview 23471.1000), PowerShell 7.3.6 and PnP-PowerShell 2.2.0 or 2.2.17 (nightly).

Is there a workaround? How can it be fixed?

[wwcc-jack-carico]

I am having a similar issue, have you tried running the Connect-PnPOnline cmdlet with the -Verbose flag?

In my case my script works as intended when running manually from a pwsh terminal. When I try to run it from task scheduler using the same domain identity it throws the "Connect-PnPOnline: Host not reachable" error but the verbose output shows the root cause is with the dependency injection libraries. I don't know how to address this.

===

Transcript started, output file is .\ss-automation-test-upload.ps1.transcript.txt
VERBOSE: Checking for updates, current version is 2.2.0. See https://pnp.github.io/powershell/articles/configuration.html#disable-or-enable-version-checks for more information.
VERBOSE: Error checking for updates: Could not load type 'Microsoft.Extensions.DependencyInjection.ServiceCollection' from assembly 'Microsoft.Extensions.DependencyInjection.Abstractions, Version=5.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60'.

TerminatingError(Connect-PnPOnline): "Host not reachable"
TerminatingError(Connect-PnPOnline): "Host not reachable"
Exception was thrown.

Connect-PnPOnline: Host not reachable

[wwcc-jack-carico]

I was able to resolve my issue by reorganizing my module imports. My script needs to use the SqlServer module for data gathering but there appears to be a dependency conflict on the Microsoft.Extensions.DependencyInjection.Abstractions assembly.

I now explicitly import the PnP.Powershell module and am just letting powershell implicitly import anything it needs from the SqlServer module. This has got it working in a task scheduler context (at least for the moment.) I am not sure why it has been working from interactive terminal sessions without this modification except that I may have been testing PNP commandlets first thus loading the PnP module implicitly before trying to do any SqlServer module work.

[JuanPabloSGU]

Have the same behaviour, using pwsh 7, PnP.Powershell v2.2.0, WIndows 10 22H2.

Any work arounds?

[Korez73]

Had the same 'host unreachable' problem. I uninstalled and rolled back to an older version of the SqlServer module, -RequiredVersion 21.1.18226 and I'm functional again.

[michaelmaillot]

Hello,

I'm facing the same issue for one of my customers. I had to make it downgrade to version 2.2.0, before the connection has been updated using the PingHost method here.

In my case, there's no specific module loaded in the PS context except PnP PowerShell. But the simple Connect-PnPOnline fails with the same error as mentioned above.

It seems that the DNS resolution couldn't work depending on the network / proxy config...