Credit for this post: Scott Fawley, SharePoint Guru Here is a handy script that MS sent while troubleshooting a Search issue in a customer’s 2013 Prod farm. This will show you the state of all partitions and replicas along with … Read More
After you finish running this script, you’ll need to create the work management service application, app management service application, subscriptions settings service application, and if you’re using powerpivot, then that would need to be configured too. There are other posts … Read More
To move the managed metadata database, take a copy only backup of it from your SQL server and then restore from files in your new SQL server. I’ll write a future post on that and put a link to it … Read More
When creating a farm using powershell, you need to create the managed accounts that your service applications will use. Here’s a script written by Stephen Swinney, Rackspace Senior SharePoint Engineer that does just that!
$Credentials = @()
#Create User Variables
$FarmUser = "Domain\SP_Farm"
$ServcAppUser = "Domain\SP_SA_AP"
$SiteAppUser = "Domain\SP_Site_AP"
$SearchSvcUser = "Domain\SP_SearchSvc"
#Create Password Variables
$FarmPass = ConvertTo-SecureString -String "$*t6uxNM3AL4_*R4" -AsPlainText -Force
$ServcAppPass = ConvertTo-SecureString -String "Htfa3S9^wZ6?CgmX" -AsPlainText -Force
$SiteAppPass = ConvertTo-SecureString -String "Rt)4(97#kDum" -AsPlainText -Force
$SearchSvcPass = ConvertTo-SecureString -String "2t+Z(tm2)NU6" -AsPlainText -Force
#Create object & add to array
$Credentials += New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $FarmUser, $FarmPass
$Credentials += New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $ServcAppUser, $ServcAppPass
$Credentials += New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $SiteAppUser, $SiteAppPass
$Credentials += New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $SearchSvcUser, $SearchSvcPass
#Loop through array and create managed accounts
foreach ($Credential in $Credentials)
Write-Host "Creating new managed account:" $Credential.UserName -foregroundcolor cyan
New-SPManagedAccount -Credential $Credential
Write-Host "All Managed Accounts Created" -foregroundcolor cyan
Note: you could also … Read More
Let’s say you have this ginormous farm with hundreds of databases and you want to update the farm to a new CU. First thing you can do is get a list of your content databases using this powershell
Get-SPContentDatabase | ft DisplayName | out-file c:\PathToFile.txt
## You may also want to know the web application that they're attached
Get-SPContentDatabase | ft DisplayName, webApplication | out-file c:\PathToSomeOtherFile.txt
## This above powershell will give you the web application name, if you want the url run something like this
Get-SPWEbApplication | ft URL
Here’s another blog post on how to create Host Named Site Collections. Here are a few reasons why you should use them over Path Based Site Collections Microsoft Recommends them as the preferred method to deploy sites in SharePoint 2013 … Read More
This is the powershell to disable MDS in all sites and sub-sites within a web application
$webApp = Get-SPWebApplication http://sp2010
$siteCollection =$webApp | Get-SPSite -limit all
foreach ($site in $siteCollection)
$webs = $site | Get-SPweb -limit all
foreach ($web in $webs)
$url = $web.URL
write-host "Web URL = " $url -foregroundcolor "blue"
Disable-SPFeature -Identity "87294c72-f260-42f3-a41b-981a2ffce37a" -url $url -Confirm:$False
All you need to do is edit the URL to your web application from http://sp2010 Cheers,
Some things to keep in mind: The account you run this with needs to be a member of either Local Administrators or Remote Desktop Users, and needs to be a member of SharePoint Shell admin access – assuming you want … Read More
App Management and Subscription Settings High-level steps: Create a forward lookup zone Create a web application (so that IIS will have an endpoint for that zone) Create a wildcard cert for secure communication Create a subscription settings service application (decide … Read More
PowerShell to create the host named site collection web application and top site This post is step 1 of two steps to get host named site collections off the ground in your SharePoint. In this script you need to edit … Read More
Script to create host named site collections This post is step 2. This script works great to create the HNSC after you have created the web application and top site with the script that I created on this other post. … Read More
This video builds the WFE Distributed Cache Minimum Role server using the AutoSPInstaller.
In this video we go over filling out the AutoSPInstaller, staging the bits on the SharePoint Application and Search Server, manually running the per-requisite installer, and finally creating the farm by running the AutoSPInstaller. The video is a little over … Read More
In this video I demonstrate installing SQL server 2016 and the configurations we make during that install. This video sort of builds off of part 1 and 2 in that the servers are created and the service accounts exist, etc. … Read More
In this video I demonstrate getting the dev environment able to be opened using RDP connections. Like all my videos, I show some common issues encountered and how to overcome those issues.
In this video, I demonstrate creating a domain, creating SharePoint service accounts, and overcoming a couple of common issues with joining a server to the newly created domain. the environment is based in hyper-V; but, you could do it in … Read More