When attempting to expand the node of a portal site in SharePoint, users encounter difficulties in listing the site collections under the portal site. This knowledge base article provides insights into the possible causes of this issue and their respective solutions.

Cause 1: No Existing Portal Site

Cause: The portal site you are trying to list may not exist or may have been deleted from SharePoint Central Admin.

Solution: Verify the existence and validity of the portal site you are attempting to list. Ensure it is accessible via a web browser.

Cause 2: No Valid Site Collection

Cause: There may be no valid site collections accessible via a web browser, making them unavailable for listing using the "STSADM.exe" tool.

Solution: Confirm that the portal site you are trying to list contains at least one error-free, valid site collection that is accessible via a web browser.

Cause 3: SQL Server Service Issue

Cause: The SQL Server service associated with the SharePoint farm may not be running.

Solution: Check the status of the SQL Server instance linked to the SharePoint farm. If the SQL Server service is stopped, site collections will not be listed under the portal site.

Cause 4: Invalid or Unavailable "STSADM.EXE" Tool**

Cause: The location of the "STSADM.EXE" tool may be invalid or not provided.

Solution: Ensure that the "STSADM.EXE" tool exists in the location specified in the "Backup -> SharePoint -> SharePoint Settings" page.