Skip to main content

All About Connecting to SharePoint Online using SharePoint Online PowerShell

Connecting to SharePoint Online using SharePoint Online PowerShell

Set up the SharePoint Online Management Shell environment for SharePoint Online global administrators

Perform the following:
  • Install Windows PowerShell 3.0 from Windows Management Framework 3.0.
  • Install the SharePoint Online Management Shell from the Microsoft Download Center.
  • Click Start>All Programs>SharePoint Online Management Shell.
  • Run Connect-SPOService. For example, Connect-SPOService -Url https://contoso-admin.sharepoint.com -credential admin@contoso.com, where: Url is the URL of the SharePoint Online Administration Center.
  • Credential is the user name to which you want to grant access to the SharePoint Online Administration Center site.
Ref: https://technet.microsoft.com/en-us/library/dn568015.aspx


Commonly faced issues when you start using Powershell for SharePoint Online.

"The specified module 'Microsoft.Online.SharePoint.Online.PowerShell' was not loaded because no valid module file was found in any directory"

This could occur because of many reason, please try the following:
  1. Run the SharePoint Online PowerShell as administrator, the prompt shall be PS  C:\windows\system32>
  2. You can trying uninstall sharepoint online powershell and reinstall it. Try to restart you PC. Verify the 32/64 bit version of your System and install appropriate version of SharePoint Online Management Shell.
  3. Check the Execution policy of the Powershell using the following command:
                Get-executionpolicy

This shall not be restricted, make it unrestricted or RemoteSigned using the following cmdlet
Set-executionpolicy unrestricted

Hopefully you have got rid of the above error now. Let's see how to connect to SP Online.
For example, my admin site is:

https://mydemosite.sharepoint.com

Before we try to connect to the SharePoint online from powershell, let set the credentials to access the admin site.

Lets use the following script to define a variable for credential like $credential

PS> $credential = get-credential

Now, following command will allow us to connect to SP Online.

PS>connect-sposervice -url https://mydemosite.sharepoint.com  -credential $credential

Error: Current site is not a tenant administration site. So SP is not allowing you to connect as the SharePoint site is not a tenant administrator. Nothing to worry about; just give the tenant admin URL as following:

Change this
https://mydemosite.sharepoint.com
To
https://mydemosite-admin.sharepoint.com

So now the new cmdlet is:

PS>connect-sposervice -url https://mydemosite-admin.sharepoint.com  -credential $credential

You may get an error:
“Could not connect to SharePoint online”

Resolution:
This probably means; you proxy is blocking the connection. Use the following cmdlet to get rid of this.

PS>$cred = [System.Net.CredentialCache]::DefaultCredentials
PS>[System.Net.WebRequest]::DefaultWebProxy.Credentials = $cred

Now you shall be able to connect to SP Online flawlessly using the same command.

PS>connect-sposervice -url https://mydemosite-admin.sharepoint.com  -credential $credential



Try couple of commands like:

PS> Get-SPOSite

This shall list all the sites in your SharePoint online account.

Cheers….


Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Visual Studio Build Issue : Build: 0 succeeded or up-to-date, 0 failed, 1 skipped

"Unable to build or clean the solution in Visual Studio (applicable to almost all versions), output window message is : Build: 0 succeeded or up-to-date, 0 failed, 1 skipped". If you are facing the above issue, you are at the right place. Perhaps following can help you. BTW, the above image is self explanatory, let me still brief if in case the image is not getting downloaded on your Internet connection. In VS menu, go to Tools -> Options. Select -> Projects and Solutions -> Build and Run. Uncheck - "Only build startup projects and dependencies on Run." Your problem shall be resolved. Thank you for visitng my blog.
Post a Comment
Read more

SharePoint log error "Cannot find site lookup info for request Uri http://"

There are many reasons for which you can have this error in your SharePoint server logs. One of the scenerio is explained below. Main Reason: One of the major reason for this error is; the SharePoint is not able to resolve the URL. There is something wrong with the alternate access mapping. Please make sure the alternate access mapping is configured properly. For more details on alternate access mapping in SharePoint, please visit: Alternate Access Mapping We had sharepoint 2016 and all website under that were https:// from the firewall. When we tried to load the web site, error occured with a Correlation Id. After checking the code I found the error message "Cannot find site lookup info for request Uri http://". I URL was able to authenticate the user but on page load the error occurs. My alternate access mapping was: https://mysite                                   ...
Post a Comment
Read more

SharePoint PowerShell to Manage Term Store / Add Terms using PowerShell

SharePoint PowerShell to Manage Term Store / Add Terms //get the term store $mysite = get-spsite “ http://yoursite:portnumber ” $taxonomySession = get-taxonomySession -site $mysite $termStore = $taxonomySession.TermStores[“Managed Metadata Service”] //now we will create the Term Store groups. Before we create any group we will check if the group already exists Example 1: if($termstore.groups["News Keys"] -eq $null) { $termstoregroup = $termstore.creategroup("News Keys");  $termstore.description = "News Group";  $termstore.addgroupmanager ("KS\spadmin"); $termstore.addcontributor ("ks\k.singh");$termStore.CommitAll();} This is not working as “ description ” is not an identified property. Example 2: if($termstore.groups["Main News Keys"] -eq $null) { echo "group is not there";  echo "group is there"; $termstoregroup = $termstore.creategroup("Main News Keys"); $terms...
Post a Comment
Read more