Prasad Bolla's SharePoint Blog

Click Here to go through the Interesting posts within my Blog.

Click Here to go through the new posts in my blog.

Friday, February 26, 2021

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.

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.

Friday, September 15, 2017

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.

Thursday, August 17, 2017

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.

Saturday, August 12, 2017

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.

Tuesday, April 11, 2017

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.

Wednesday, May 25, 2016

How to make IE as a Default Browser in Windows 10 OS.



  1. Click on start menu
  2. Type default programs and click on it.
  3. Now in the default apps window.
  4. Go to section - Web Browser.
  5. Now change it from Microsoft Edge to Internet Explorer.

Wednesday, April 20, 2016

Internet Disconnecting Frequently while working on Battery with Hp Pro Book 430 Laptop

The below steps had fixed the issue.


  1.  Click the Start button.
  2. Type Power Options and press Enter.
  3. Click Continue if prompted.
  4. Click “Change plan settings” under the power plan that is currently selected.
  5. Click “Change advanced power settings”.
  6. In the Power Options box, click the + next to “Wireless Adapter Settings” to expand it.
  7. Then click the + next to “Power Saving Mode”.
  8. In the list that appears next to On battery, select “Maximum Performance”.
  9. Click OK.