Log on to SharePoint with Powershell using the Credential Manager

Question

What I would like is to logon to sharepoint with powershell using the CSOM-module and using the Credential Manager where I have safely stored the password.

This is a working code to logon to sharepoint

    Try 
    {
          $Credentials = New-Object 
          Microsoft.SharePoint.Client.SharePointOnlineCredentials($user,(ConvertTo-SecureString $pass -AsPlainText -Force))
           $Context =  New-Object 
           Microsoft.SharePoint.Client.ClientContext($SiteUrl)
            $Context.Credentials = $Credentials
     }
     Catch 
     {
        exit 
     } 

But how can I use the credential manager. I have installed the module en made this:

#$managedCred = Get-StoredCredential -Target SharepointOnline

Does anyone know the solution.

Gr P

Answer 1

Peter, I have answered the same question posted by you in another Technet Thread, please remember to check it:

[TechNet] Log on to SharePoint with Powershell using the Credential Manager

Hi PeetK,

Firstly, create a Generic Credentials in Credential Manager:

In my side, the name is "o365" for example, then in PowerShell, use like this:

Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
$cred = Get-StoredCredential -Target 'o365'  
#Variables for Processing
$SiteUrl = "https://TenantName.sharepoint.com/sites/SiteName/"

#Setup Credentials to connect
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($cred.UserName,$cred.Password)

#Set up the context
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteUrl)
$Context.Credentials = $credentials
$Context.ExecuteQuery()
$Web=$Context.Web;
$Context.Load($Web)
$Context.ExecuteQuery()

Answer 2

This is possible with PnP PowerShell. I use this all the time as I have dozens of client environments I connect to.

Connect-PnPOnline <url> -Credential <name of stored credential>

https://github.com/SharePoint/PnP-PowerShell/wiki/How-to-use-the-Windows-Credential-Manager-to-ease-authentication-with-PnP-PowerShell#label-approach

If you want to do this without PnP you can check out the code on Github and reverse engineer it.