Copy Group Membership Permissions of a User in SharePoint using PowerShell

Requirement: Copy SharePoint Group Memberships of one user to another user Solution: You can copy group memberships of one user to another user to have identical SharePoint Permissions for a SharePoint Site. Here is the PowerShell Script: PowerShell Script to Copy Group Memberships from One user to another: Alternatively, to add a…

Read more

Fix for “Cannot Connect to Database Master at SQL Server at Server Name. The Database might not exist, or the current user does not have permission to connect to it” SharePoint Error

Problem:When trying to create a new SharePoint farm using PowerShell, the SharePoint 2016 management Shell gave an error message:New-SPConfigurationDatabase : Cannot connect to database master at SQL server at <SQL-Server-Alias>. The database might not exist, or the current user does not have permission to connect to it. Tried using SharePoint products configuration…

Read more

How to Create New Target Application ID in Secure Store Service for BCS in SharePoint 2016?

When you want to consume external data in SharePoint, such as data from your other business applications, you can use Business Connectivity Services (BCS) together with Secure Store Service. The external data source that you can connect to is called a Secure Store Target Application. BCS makes it possible for you to…

Read more

Copy Permissions from One SharePoint Site to Another using PowerShell

Requirement: Copy permissions from one site to another in SharePoint! Solution: If you want to copy one SharePoint site to another site, there are no OOTB ways! However, You can use PowerShell to copy permissions between sites. Here is my PowerShell script to copy site permissions. Copy Permissions from one site to…

Read more

Customize Suitebar Text and Link in SharePoint 2016 using PowerShell

Requirement: By default, SharePoint 2016 comes with “SharePoint” as the suite bar branding text.  What if you would like to change it to something meaningful, say “Your Company Intranet”? Well, PowerShell can help to customize the branding text, Logo, and URL in SharePoint 2016. PowerShell Script to change Suitebar navigation text and…

Read more

How to Delete a SharePoint Web Application?

SharePoint Web Applications are actually an IIS Containers at top level. Each web application we create from SharePoint, creates respective site in IIS and a content database in SQL Server. To delete a SharePoint 2016 Web Application, Open SharePoint 2016 Central Administration Site Click on the “Manage web applications” link under “Application…

Read more

How to Get Content Type ID in SharePoint using PowerShell?

Requirement: A typical usage of Content Types is reusable metadata in SharePoint. At times, You may need to get content type id by name in order to  assign the content type to lists and libraries programmatically. Lets get content type id in SharePoint 2013 using PowerShell. How to find content type id…

Read more

Get All Site Collections in a Web Applications using PowerShell

How to get all site collections of a web application in SharePoint? To get all site collections in web application, from SharePoint central Admin, follow these steps: Go to SharePoint Central Admin Site >> Application Management  Click on the “View all site collections” link under Site Collections Group. Select your web application….

Read more

Update SharePoint List Items from CSV File using PowerShell

Requirement: Update SharePoint List Items from CSV file. A bit background: We have a list with 1000’s of rows of organization-wide experts. Later we added a new field for “Department”. Now the requirement is to update the Department field for a specific list of users. While the datasheet view can be used…

Read more

How to Add Administrator and Grant Permission to Service Applications using PowerShell?

By default, the Farm administrators group has the right to manage all service applications. Often there are situations when you may need to add additional administrators or grant permissions to SharePoint service applications. Say, You want to delegate service application administration to other users SharePoint farm admin account isn’t added as service…

Read more