Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

February 2018

FIXED – DISM /Enable-Feature Error: 0x800f081f

Recently I attempted to install Windows Feature Dot Net Framework 3.5 on Windows 10 and saw the error below.

The resolution was to download a different larger CAB file then execute a different DISM command line.

Instead of installing the feature by name (“NetFx3”) we should install the CAB package filename (“”)

Hope that helps someone else.  Cheers! 

shades_smile

Error

Resolution

Screenshots

3
image

References

SharePoint – SQL Database Roles

Had a friend ask about SQL database Role Memberships that are needed for SharePoint Server on-premise.  Examined SQL roles on my dev farm.  Reference table below.

Cheers!   

shades_smile

Get-SPServiceApplication

Get-SPDatabase | Select TypeName

SQL Permission Role

App Management

App Management Database

SP_DataAccess

N/A

Configuration Database

dbo, WSS_Content_Application_Pools

N/A

Content Database

SP_DataAccess

Microsoft SharePoint Foundation

Microsoft SharePoint Foundation Subscription Settings Database

SubscriptionSettingsService_Application_Pool

Secure Store

Microsoft.Office.SecureStoreService.Server.SecureStoreServiceDatabase

SP_DataAccess

User Profile

Microsoft.Office.Server.Administration.ProfileDatabase

SP_DataAccess

User Profile

Microsoft.Office.Server.Administration.SocialDatabase

SP_DataAccess

State Service

Microsoft.Office.Server.Administration.StateDatabase

WSS_Content_Application_Pools

User Profile

Microsoft.Office.Server.Administration.SynchronizationDatabase

db_owner

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchAdminDatabase

SPSearchDBAdmin

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchAnalyticsReportingDatabase

SPSearchDBAdmin

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchGathererDatabase

SPSearchDBAdmin

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchLinksDatabase

SPSearchDBAdmin

Machine Translation Service

Microsoft.Office.TranslationServices.QueueDatabase

SP_DataAccess

Word Automation Services

Microsoft.Office.Word.Server.Service.QueueDatabase

SP_DataAccess

PerformancePoint

Microsoft.PerformancePoint.Scorecards.BIMonitoringServiceDatabase

SP_DataAccess

Business Data Connectivity

Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase

SP_DataAccess

Managed Metadata

Microsoft.SharePoint.Taxonomy.MetadataWebServiceDatabase

db_owner

FIXED – Unable to search item by ID (Your search returned no results)

Recently I resolved an on-premise search issue where typing an ID number into the list view “Find an item” bar gave zero results.   The list definitely had matching data and search full crawl was completed.

The fix was to update “ListitemID” to be searchable on the Search Service Application (SSA), click “Re-Index” button under List Settings, and wait for the next incremental crawl.  Cheers! 

shades_smile

Symptom

  • Type keyword in “Find an item”
  • Error display “Your search returned no results

SNAGHTML7ce66d

Resolution

  • Open Central Admin
  • Open Search Service Application
  • Open “Search Schema” and type “ListItemID
  • Check the box [X] for “Searchable
  • Navigate to team site with user content
  • Open “List Settings > Advanced settings”
  • Click button “Reindex List”
  • Wait for incremental search
  • Now works OK

SNAGHTML7da344
image

Reference

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲