SharePoint 2013 security hotfix remove the application pool permission from RBS content database DB owner

Question :
we notice after the security hotfix patch, application pool account is remove from the content Database DB owner (this setting is for RBS) , this is known issues ?

Answer :
Yes, after security hotfix Patch or any patch update, application pool account will be removed from the content Database DB owner for RBS enabled databases. We would need to add the account back as DB owner.

RBS enable for sharepoint second content DB

1. add pool account to the dbowner content database

2.run sql script crease RBS group

USE WSS_Content_RBS

if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')

create master key encryption by password = N'Admin Key Password !2#4'

USE WSS_Content_RBS

if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')

alter database WSS_Content_RBS add filegroup RBSFilestreamProvider contains filestream

USE WSS_Content_RBS

alter database WSS_Content_RBS add file (name = RBSFilestreamFile, filename = 'F:\WSS_Content_staffhub_RBS_test') to filegroup RBSFilestreamProvider

 3.check blob folder created

4. Run at DB server for second content db

msiexec /lvx* WSS_Content_RBS.txt /i rbs.msi REMOTEBLOBENABLE=1 FILESTREAMPROVIDERENABLE=1 FILEGROUP=PRIMARY FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FileStreamProvider_1 ADDLOCAL=EnableRBS,FilestreamRunScript DBINSTANCE=

*use interface to setup

  

6.check will see rbs table

7.run powershell

$cdb = Get-SPContentDatabase WSS_Content_RBS

$rbss = $cdb.RemoteBlobStorageSettings

$rbss.Installed()

$rbss.Enable()

$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])  #make sure is only one provider 

$rbss

8.upload file and check on RBS folder

Power Shell convert from excel to csv

 $excelFile = "D:\Test\excelfile\file.xlsx"
    $E = New-Object -ComObject Excel.Application
    $E.Visible = $false
    $E.DisplayAlerts = $false

 $wb = $E.Workbooks.Open($excelFile)
    foreach ($ws in $wb.Worksheets)
    {
        $n = $excelFileName + "_" + $ws.Name
    }

   
Function ExportWSToCSV ($excelFileName, $csvLoc)
{
    $excelFile = "D:\Test\excelfile\" + $excelFileName + ".xlsx"
    $E = New-Object -ComObject Excel.Application
    $E.Visible = $false
    $E.DisplayAlerts = $false
    $wb = $E.Workbooks.Open($excelFile)
    foreach ($ws in $wb.Worksheets)
    {
        $n = $excelFileName + "_" + $ws.Name
        $ws.SaveAs($csvLoc + $n + ".csv", 6)
    }
    $E.Quit()
}
ExportWSToCSV -excelFileName "file" -csvLoc "D:\Test\csv file\"

stop-process -processname EXCEL

$ens = Get-ChildItem "D:\Test\excelfile\" -filter *.xlsx
foreach($e in $ens)
{
    ExportWSToCSV -excelFileName $e.BaseName -csvLoc "D:\Test\csv file\"
}

powershell send sharepoint site report to email

$enddate = (Get-Date).tostring("yyyyMMdd")
$filename = 'D:\report\' + $enddate + '_staffdocs.xml'
stsadm.exe -o enumsites -url https://abc.com  > "$filename"

$From = "mysite_report@abc.com"
$To = "ng_sin_peow@abc.com"
$Cc = "YourBoss@abc.com"
$Attachment = "$filename"
$Subject = "My Site Report (One Drive) "
$Body = "Report for my site , please open with excel"
$SMTPServer = "smtp.abc.com"
$SMTPPort = "25"
Send-MailMessage -From $From -to $To -Subject $Subject -Body $Body -SmtpServer $SMTPServer -port $SMTPPort -Attachments $Attachment

SharePoint Production farm shut down and boot up sequence

Shut down SharePoint server by following sequence

1.       Web front end server ( Can shut down all web front end server at the same time )

2.       Application Server ( Can shut down all application server at the same time )

3.       Database Server (Can shut down all database server  at the same time )

Boot up SharePoint server by following sequence

1.       Database Server (Can boot up all database server   at the same time)

2.       [ Need to wait all DB server completely up ] Application Server (Can boot up all application server at the same time)

3.       [ Need to wait all Application server completely up ] Web front end server ( Can boot up all web front end server at the same time )