run sharepoint 2019 configuration wizard using powershell

run sharepoint 2019 configuration wizard using powershell step by step is very important for monthly sharepoint patching activity. Follow step by step to run sharepoint config wizard. SharePoint patching is a two step process. Install CU and run config wizard. In this video only describe how to run config wizard once CU installation is completed. If SharePoint server 2019 central admin, you will find upgrade available, upgrade required after installing updates, then you need to run the config wizard using powershell.

PSConfig.exe -cmd upgrade -inplace b2b -wait -cmd applicationcontent -install -cmd installfeatures -cmd secureresources -cmd services -install
Advertisements

sharepoint 2019 configuration wizard run using powershell | #SharePoint2019, #PatchingSharePoint

run sharepoint 2019 configuration wizard
Advertisements

Using GUI will not resolve the issue upgrade available, upgrade required. If still you are facing issue then follow the below video Configuration Cache Clearing SharePoint 2019. Then run the configuration wizrd again using powershell

Advertisements

Configuration Cache Clearing SharePoint 2019 | #SharePoint, #SharePoint2019, #ConfigCache

Configuration Cache Clearing SharePoint 2019

Advertisements

Patching SharePoint Server 2013 step by step

Patching SharePoint Server 2013 step by step

Patching SharePoint server is one of the most difficult task that everyone want to know how to implement step by step. SharePoint server patching is a two step process. Installation of CU and run configuration wizard. In this video its described how to install CU in sharepoint server 2013 using powershell. Watching this video, you will feel like its very easy to implement.

  • Download the KB   (sharepoint 2013 cumulative update/Patch download link)from the URL as shown in the video.
Patching SharePoint
  • Extract files after download and you will find 3 files of extension “.exe , .cab, .cab”.
Patch 1321x705
  • Copy this below code to notepad and save as in “.ps 1”
########################### 
##Ensure Patch is Present## 
########################### 
$patchfile = Get-ChildItem | where{$_.Extension -eq ".exe"}
if($patchfile -eq $null)
{
  Write-Host "Unable to retrieve the file.  Exiting Script" -ForegroundColor Red
  Return
}

######################## 
##Stop Search Services## 
######################## 
##Checking Search services##
$srchctr = 1
$srch4srvctr = 1
$srch5srvctr = 1
$srv4 = get-service "OSearch15"
$srv5 = get-service "SPSearchHostController"

If(($srv4.status -eq "Running") -or ($srv5.status-eq "Running"))
  {
    Write-Host "Choose 1 to Pause Search Service Application" -ForegroundColor Cyan
    Write-Host "Choose 2 to leave Search Service Application running" -ForegroundColor Cyan
    $searchappresult = Read-Host "Press 1 or 2 and hit enter"
    Write-Host
   
   if($searchappresult -eq 1)
    {
        $srchctr = 2
        Write-Host "Pausing the Search Service Application" -foregroundcolor yellow
        Write-Host "This could take a few minutes" -ForegroundColor Yellow
        $ssa = get-spenterprisesearchserviceapplication
        $ssa.pause()
    }

    elseif($searchappresult -eq 2)
    {
        Write-Host "Continuing without pausing the Search Service Application"
    }
    else
    {
        Write-Host "Run the script again and choose option 1 or 2" -ForegroundColor Red
        Write-Host "Exiting Script" -ForegroundColor Red
        Return
    }
  }

Write-Host "Stopping Search Services if they are running" -foregroundcolor yellow
if($srv4.status -eq "Running")
  {
    $srch4srvctr = 2
    set-service -Name "OSearch15" -startuptype Disabled
    $srv4.stop()
  }

if($srv5.status -eq "Running")
  {
    $srch5srvctr = 2
    Set-service "SPSearchHostController" -startuptype Disabled
    $srv5.stop()
  }

do
  {
    $srv6 = get-service "SPSearchHostController"
    if($srv6.status -eq "Stopped")
    {
        $yes = 1
    }
    Start-Sleep -seconds 10
  }
  until ($yes -eq 1)

Write-Host "Search Services are stopped" -foregroundcolor Green
Write-Host 

####################### 
##Stop Other Services## 
####################### 
Set-Service -Name "IISADMIN" -startuptype Disabled
Set-Service -Name "SPTimerV4" -startuptype Disabled
Write-Host "Gracefully stopping IIS W3WP Processes" -foregroundcolor yellow
Write-Host
iisreset -stop -noforce
Write-Host "Stopping Services" -foregroundcolor yellow
Write-Host
$srv2 = get-service "SPTimerV4"
  if($srv2.status -eq "Running")
  {$srv2.stop()}

Write-Host "Services are Stopped" -ForegroundColor Green
Write-Host
Write-Host 

################## 
##Start patching## 
################## 
Write-Host "Patching now keep this PowerShell window open" -ForegroundColor Magenta
Write-Host
$starttime = Get-Date
$filename = $patchfile.basename
Start-Process $filename
Start-Sleep -seconds 20 
$proc = get-process $filename
$proc.WaitForExit()
$finishtime = get-date
Write-Host
Write-Host "Patch installation complete" -foregroundcolor green
Write-Host 

################## 
##Start Services## 
################## 
Write-Host "Starting Services Backup" -foregroundcolor yellow
Set-Service -Name "SPTimerV4" -startuptype Automatic
Set-Service -Name "IISADMIN" -startuptype Automatic

##Grabbing local server and starting services##
$servername = hostname
$server = get-spserver $servername

$srv2 = get-service "SPTimerV4"
$srv2.start()
$srv3 = get-service "IISADMIN"
$srv3.start()
$srv4 = get-service "OSearch15"
$srv5 = get-service "SPSearchHostController"

###Ensuring Search Services were stopped by script before Starting"
if($srch4srvctr -eq 2)
{
    set-service -Name "OSearch15" -startuptype Automatic
    $srv4.start()
}
if($srch5srvctr -eq 2)
{
    Set-service "SPSearchHostController" -startuptype Automatic
    $srv5.start()
}

###Resuming Search Service Application if paused### 
if($srchctr -eq 2)
{
    Write-Host "Resuming the Search Service Application" -foregroundcolor yellow
    $ssa = get-spenterprisesearchserviceapplication
    $ssa.resume()
}

Write-Host "Services are Started" -foregroundcolor green
Write-Host
Write-Host
Write-Host "Script Duration" -foregroundcolor yellow
Write-Host "Started: " $starttime -foregroundcolor yellow
Write-Host "Finished: " $finishtime -foregroundcolor yellow
Write-Host "Script Complete"
  • Save all files that is of extensions “.exe , .cab, .cab, .ps 1” in one folder.
Patching SharePoint Server
  • Open “SharePoint Management Shell”.
  • Navigate to the folder in which all files are stored and run the Powershell script.
  • Next step is to run the config wizard. Please find the video in detail step by step further.

Patching SharePoint Server steps | SharePoint 2013 | install cumulative updates

Patching SharePoint Server steps | SharePoint 2013 | install cumulative updates

how to run sharepoint configuration wizard steps (psconfig)

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 Error SharePoint 2016

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

Error:

“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” 

cannot-connect-to-database-master-at-server_sharepoint2016

Solution:

Open the Windows Firewall with Advanced Services and add an inbound rule to allow traffic over port 1433.

amazon   amazonsp2016  amazonsp2016_2