Json Code to make Plain Multiple Text Column to an URL.

 {

   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "a",
   "txtContent": "=@currentField",
   "attributes": {
      "target": "_blank",
      "href": "=@currentField"
   }
}

SharePoint PowerShell Commands

SharePoint PowerShell Commands

Note: -

As per my knowledge the below SharePoint PowerShell commands will work below SharePoint Versions.   1. SharePoint 2010. 2. SharePoint 2013. 3. SharePoint 2016. 4. SharePoint 2019.   I don’t have any knowledge on SharePoint Server Subscription, hence not able to comment on the new version.

 

Title	SharePoint PowerShell Command Example	Command Type
Add-SPSolution	Add-SPSolution "Path\Test.wsp"	WSP
Install-SPSolution	Install-SPSolution -Identity Test.wsp -WebApplication http://SP2019Dev:100/ -GACDeployment -Force	WSP
Uninstall-SPSolution	Uninstall-SPSolution -Identity Test.wsp –WebApplication http://SP2019Dev:100/	WSP
Remove-SPSolution	Remove-SPSolution -Identity Test.wsp	WSP
Backup-SPSite	Backup-SPSite https://server_name/sites/site_name -Path C:\Backup\site_name.bak	Backup a Site Collection
Restore-SPSite	Restore-SPSite https://server_name/sites/site_name -Path C:\Backup\site_name.bak	Restore a Site Collection
Import-SPWeb	Import-SPWeb https://site -Path export.cmp -UpdateVersions Overwrite	Backup a Particular SharePoint Site/Subsite
Export-SPWeb	Export-SPWeb https://site -Path "C:\Temp\export.cmp"	Restore a Particular SharePoint Site/Subsite

 

Add-SPSolution: -

            The Add-SPSolution cmdlet adds a SharePoint solution package to the farm. This cmdlet does not deploy the uploaded SharePoint solution.

 

Install-SPSolution: -

            The Install-SPSolution cmdlet deploys an installed SharePoint solution in the farm.

 

Uninstall-SPSolution: -

            The Uninstall-SPSolution cmdlet retracts a deployed SharePoint solution in preparation for removing it from the farm entirely.

 

Remove-SPSolution: -

            The Remove-SPSolution cmdlet deletes a SharePoint solution from a farm.

 

 

List cannot be deleted while on hold or retention policy

Click here to open steps to fix the issue.

Please go through my Public GitHUB Pepository

Hi All Please go through my below public GitHub Repository. https://github.com/bvnprasad99999/Prasad-Bolla-Knowledge-Base Regards Prasad Bolla

SharePoint 2019 Configuration Wizard Issue - One or more types failed to load Issue while creating a new SharePoint FARM

While running a SharePoint 2019 Configuration Wizard you will get error "One or more types failed to load Issue while creating a new SharePoint FARM".

First Delete the SharePoint Configuration Content DB which was created in the SQL Server once the error was occured.

Please follow below steps in the PDF to fix this issue.

One or more types failed to load Issue while creating a new SharePoint FARM

SQL Server Setup Error - There was an error generating the XML document. Error code 0x84B10001 SQL Server Setup Error - There was an error generating the XML document. Error code 0x84B10001

Please follow below steps to resolve this issue.

1.     Create a New Computer Account (Not Domain User).

a.     Example: - SQLUser

2.     Add it to your Administrators group.

3.     Now Shift + right click on SQL server setup.

4.     Run it as different user.

5.     Provide credentials of newly created account.

Now the issue will get resolved and the SQL Server Setup will run without any issue.

 

SharePoint 2019 Single Server Installation and SQL Server Installation

• We can install SharePoint 2019 installation along with SQL Server if we have more ram.
• We installed it on 16 GB RAM without any issue.
• Not sure if it happens same for SharePoint 2016.

How to Install Windows Server 2003 R2 on Hyper-v 2008 R2 SP1/Hyper-v 2012 R2 SP1

1. Go to Hyper-V in your windows server.
2. Install the OS using DVD in Hyper-V
3. Now to get network adapter for VM you need to select legacy adapter instead of Normal adapter.

SharePoint 2016 Single Server FARM Giving Problems

As the meaning of Single Server FARM we think that all the things (SQL, SharePoint) in one server like older versions. When i installed all the things in one server it started giving problems. I came to know that Microsoft Recommendation for Sngle Server FARM was to install SQL Server, Separately on one server and SharePoint 2016 separately on another server. Once i installed them on two different servers SharePoint worked without giving any problems.

Hard ware Requirements for my installation.

My Total RAM was 8 GB.

In that Physical Machine i installed active directory.

In hyper-v i took below configurations.

For these two machines i took total 6 GB RAM.

• For SQL Server 2 GB, 2 Cores.
• For SharePoint 2016 4 GB, 2 Cores.

SharePoint 2016 Ports

Protocol	Port	Usage	Comment
TCP	80	http	Client to SharePoint web server traffic (SharePoint – Office Online Server/Office Web Apps communication)
TCP	443	https/ssl	Encrypted client to SharePoint web server traffic (Encrypted SharePoint – Office Online Server/Office Web Apps communication)
TCP	1433	SQL Server default communication port.	May be configured to use custom port for increased security
UDP	1434	SQL Server default port used to establish connection	May be configured to use custom port for increased security
TCP	445	SQL Server using named pipes	When SQL Server is configured to listen for incoming client connections by using named pipes over a NetBIOS session, SQL Server communicates over TCP port 445
TCP	25	SMTP for e-mail integration	Cannot in 2016 be configured (Use SMTP ports other than the default (25).)
TCP	16500-16519	Ports used by the search index component	Intra-farm only Inbound rule Added to Windows firewall by SharePoint. (GPO may override this change)
TCP	22233-22236	Ports required for the AppFabric Caching Service	Used by the Distributed Cache…
TCP	808	Search – Query processing component Windows Communication Foundation communication	Search – Query processing component (WCF)
TCP	32843	Communication between Web servers and service applications	http (default) To use custom port, see references section Inbound rule Added to Windows firewall by SharePoint
TCP	32844	Communication between Web servers and service applications	https Inbound rule Added to Windows firewall by SharePoint
TCP	32845	net.tcp binding: TCP 32845 (only if a third party has implemented this option for a service application)	Custom Service Applications Inbound rule Added to Windows firewall by SharePoint
TCP	32846	Microsoft SharePoint Foundation User Code Service (for sandbox solutions)	Inbound on all Web Servers Inbound rule Added to Windows firewall by SharePoint Outbound on all Web and App servers with service enabled.
TCP	636	User Profile Synchronization Service/Active Directory Import	Synchronizing profiles between SharePoint 2016 and AD using SLDAP (Secure LDAP)
TCP	5725	User Profile Synchronization Service	Synchronizing profiles between SharePoint 2016 and Active Directory Domain Services (AD DS)
TCP + UDP	389	User Profile Synchronization Service	LDAP Service
TCP + UDP	88	User Profile Synchronization Service	Kerberos
TCP + UDP	53	User Profile Synchronization Service	DNS
UDP	464	User Profile Service	Kerberos change password
TCP	809	Office Online Server/Office Web Apps	Office Online Server/Office Web Apps intra-farm communication.

How to off the spell checker for android keyboard

1. go to settings
2. type keyboard
3. click on keyboard and input methods
4. In the next window click on spell checker
5. now you will see the button called off at the top.

What's New In SharePoint 2010/2013/2016

    1. What’s New in SharePoint 2010

https://support.office.com/en-gb/article/What-s-New-in-Microsoft-SharePoint-Server-2010-e34398ea-3607-47be-9506-36985607109c?ui=en-US&rs=en-GB&ad=GB#__toc286317650

       2. What’s New in SharePoint 2013

https://msdn.microsoft.com/en-us/library/office/jj163091.aspx

       3. What’s New in SharePoint 2016

https://technet.microsoft.com/en-us/library/mt346121(v=office.16).aspx