Kerberos delegation must be configured to avoid the double-hop issue found when implementing SSRS. This course will teach you how to do it!

Course info:
Level: Beginner
Duration: 1h 39m
Closed Caption/CC: English
Course Author: Kathi Kellenberger
Source Course: Pluralsight

Security is hard, but that is not a good reason to do things the easy way. A big challenge for SQL Server DBAs is configuring security for SSRS when faced with the "double-hop" issue. The way to solve this problem is by implementing Kerberos delegation. This course will explain what Kerberos is and why you need it. More importantly, it will provide the knowledge required to configure it and troubleshoot when things go wrong.

You can stream here.

When you get the module PnP PowerShell, you might be get the previous version like below image:

Solution:

1. Run Get-Module SharePointPnPPowerShellOnline -ListAvailable in PowerShell.
2. Go to the Directory, default located C:\Program Files\WindowsPowerShell\Modules
3. Remove the previous version:
   
   
   
   
   
   
   
   
4. And the result should be return like below image:
   
   
   

When trying to "Connect-SPOService" with SharePoint Online, you might encounter the following error:

Connect-SPOService : For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method.

Somehow, it could be triggered by many possible reasons.

Solution:

Modify your local HOSTS file located under C:\Windows\System32\drivers\etc and add the following below entries:

1. 127.0.0.1 msoid.(domain).onmicrosoft.com

2. 127.0.0.1 msoid.onmicrosoft.com

3. 127.0.0.1 msoid.(domain).com*

Open the HOSTS file with Notepad++ or Notepad and Run As Admin then add above entries, (domain) is your domain name in Microsoft 365.

*Following point number 3, if you don't register a new domain, you don't have to add it.