Category Archives: SharePoint 2016

SharePoint Server 2016

failed to create configuration database

failed to create configuration database

Advertisements
Advertisements

There is an error "failed to create configuration database" while installing sharepoint 2016 with an addition message "sql server instance does not have the required "max degree of parallelism" setting of 1".

failed to create configuration database

What is Max Degree of Parallelism ?
When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the max degree of parallelism option to limit the number of processors to use in parallel plan execution. SQL Server considers parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population.

Read this for more details

http://technet.microsoft.com/en-us/library/ms189094.aspx

How to fix it ?

  1. Open Microsoft SQL Server Management Studio
  2. Login with sysadmin user
  3. Right Click on instance name and select properties >> Advanced
  4. Change Max Degree of Parallelism to 1
  5. Restart the SQL Service

 

Advertisements
Advertisements
Advertisements
sharepoint-2016-site-template-1920x1080

sharepoint templates

Advertisements
Advertisements

sharepoint templates

This post describes the list of sharepoint templates and template id present. we can use the powershell command to get sharepoint templates list in sharepoint 2016.

Get-SPWebTemplate | Format-Table -wrap
NameTitle
GLOBAL#0 Global template
STS#0 Team Site
STS# 1 Blank Site
STS#2 Document Workspace
MPS#0 Basic Meeting Workspace
MPS#1 Blank Meeting Workspace
MPS#2 Decision Meeting Workspace
MPS#3 Social Meeting Workspace
MPS#4 Multipage Meeting Workspace
CENTRALADMIN#0 Central Admin Site
WIKI#0 Wiki Site
BLOG#0 Blog
SGS#0 Group Work Site
TENANTADMIN#0 Tenant Admin Site
APP#0 App Template
APPCATALOG#0 App Catalog Site
ACCSRV#0 Access Services Site
ACCSVC#0 Access Services Site Internal
ACCSVC#1 Access Services Site
BDR#0 Document Center
TBH#0 In-Place Hold Policy Center
DEV#0 Developer Site
EDISC#0 eDiscovery Center
EDISC#1 eDiscovery Case
OFFILE#0 (obsolete) Records Center
OFFILE#1 Records Center
OSRV#0 Shared Services Administration Site
PPSMASite#0 PerformancePoint
BICenterSite#0 Business Intelligence Center
PWA#0 Project Web App Site
PWS#0 Microsoft Project Site
POLICYCTR#0 Compliance Policy Center
SPS#0 SharePoint Portal Server Site
SPSPERS#0 SharePoint Portal Server Personal S
SPSPERS#2 Storage And Social SharePoint Porta
SPSPERS#3 Storage Only SharePoint Portal Serv
SPSPERS#4 Social Only SharePoint Portal Serve
SPSPERS#5 Empty SharePoint Portal Server Pers
SPSPERS# 6 Storage And Social SharePoint Porta
SPSPERS#7 Storage And Social SharePoint Porta
SPSPERS#8 Storage And Social SharePoint Porta
SPSPERS#9 Storage And Social SharePoint Porta
SPSPERS#10 Storage And Social SharePoint Porta
SPSMSITE#0 Personalization Site
SPSTOC#0 Contents area Template
SPSTOPIC#0 Topic area template
SPSNEWS#0 News Site
CMSPUBLISHING#0 Publishing Site
BLANKINTERNET#0 Publishing Site
BLANKINTERNET#1 Press Releases Site
BLANKINTERNET#2 Publishing Site with Workflow
SPSNHOME#0 News Site
SPSSITES#0 Site Directory
SPSCOMMU#0 Community area template
SPSREPORTCENTER#0 Report Center
SPSPORTAL#0 Collaboration Portal
SRCHCEN#0 Enterprise Search Center
PROFILES#0 Profiles
BLANKINTERNETCONTER#0Publishing Portal
SPSMSITEHOST#0 My Site Host
ENTERWIKI#0 Enterprise Wiki
PROJECTSITE#0 Project Site
PRODUCTCATALOG#0 Product Catalog
COMMUNITY#0 Community Site
COMMUNITYPORTAL#0 Community Portal
GROUP#0 Group
POINTPUBLISHINGHUB#0 PointPublishing Hub
POINTPUBLISHINGPERSONAL#0PointPublishing Personal
POINTPUBLISHINGTOPIC#0PointPublishing Topic
SRCHCENTERLITE#0 Basic Search Center
SRCHCENTERLITE#1 Basic Search Center
visprus# 0 Visio Process Repository
GLOBAL#0 Global template
STS#0 Team Site
STS#1 Blank Site
STS#2 Document Workspace
MPS#0 Basic Meeting Workspace
MPS#1 Blank Meeting Workspace
MPS#2 Decision Meeting Workspace
MPS#3 Social Meeting Workspace
MPS#4 Multipage Meeting Workspace
CENTRALADMIN#0 Central Admin Site
WIKI#0 Wiki Site
BLOG#0 Blog
SGS#0 Group Work Site
TENANTADMIN#0 Tenant Admin Site
ACCSRV#0 Access Services Site
ACCSRV#1 Assets Web Database
ACCSRV#3 Charitable Contributions Web Database
ACCSRV#4 Contacts Web Database
ACCSRV#6 Issues Web Database
ACCSRV#5 Projects Web Database
BDR#0 Document Center
OFFILE#0 (obsolete) Records Center
OFFILE#1 Records Center
OSRV#0 Shared Services Administration Site
PPSMASite#0 PerformancePoint
BICenterSite#0 Business Intelligence Center
PWA#0 Project Web App Site
PWS#0 Microsoft Project Site
SPS#0 SharePoint Portal Server Site
SPSPERS#0 SharePoint Portal Server Personal Site
SPSMSITE#0 Personalization Site
SPSTOC#0 Contents area Template
SPSTOPIC# 0 Topic area template
SPSNEWS#0 News Site
CMSPUBLISHING#0 Publishing Site
BLANKINTERNET#0 Publishing Site
BLANKINTERNET#1 Press Releases Site
BLANKINTERNET#2 Publishing Site with Workflow
SPSNHOME#0 News Site
SPSSITES#0 Site Directory
SPSCOMMU#0 Community area template
SPSREPORTCENTER#0 Report Center
SPSPORTAL#0 Collaboration Portal
SRCHCEN#0 Enterprise Search Center
PROFILES#0 Profiles
BLANKINTERNETCONTAINER#0Publishing Portal
SPSMSITEHOST#0 My Site Host
ENTERWIKI#0 Enterprise Wiki
SRCHCENTERLITE#0 Basic Search Center
SRCHCENTERLITE#1 Basic Search Center
SRCHCENTERFAST#0 FAST Search Center
visprus#0 Visio Process Repository
Advertisements
Advertisements
sharepoint templates
sharepoint-2016-site-template-1109x1040
sharepoint-2016-site-template-1106x1040.jpg
sharepoint-2016-site-template-1100x523
Advertisements
Advertisements
application-pools-in-iis-1920x1080

application pools in iis overview

Advertisements
Advertisements

application pools in iis overview

As defined in Internet Information Services (IIS) an application Pool is a collection of one or more URLs that are serviced by one or a set of worker processes. After installation of SharePoint, open IIS Manager. You will notice application pools in iis.

application-pool-iis-manager-969x476

You must select an existing Application Pool or create a new pool whenever you create a service or web application in SharePoint Server.

create-new-application-pool-1314x453

application pools in iis allow multiple SharePoint websites to run on a single server without the processes or code in one site interacting with any other sites. This is primarily a security benefit, since any outside intrusion on one site is isolated. Also, problematic or poor code running on one site is isolated so that other sites on the server are unaffected. For these reasons, you should plan to use dedicated application pools to isolate authenticated content and separate applications that contain password information.

we can run powershell command to get all application pools.

Advertisements
Advertisements
Get-IISAppPool
Get-IISAppPool-754x567

we can search one or more application pool directly by running the below command.

Get-IISAppPool "DefaultAppPool","SharePoint - 37344"
Get-IISAppPool-information-875x192
Service-Applications-in-SharePoint-1920x1080

Service Applications in SharePoint

Advertisements
Advertisements

Service Applications in SharePoint

Service Applications in SharePoint are associated with web applications, and specific services are typically deployed as needed in a particular farm. Only deployed services are referred to as service applications. This is a huge advantage in terms of conserving resources and optimizing performance. For instance, a specific web application can be configured to use only the services it needs. The number of service applications that exist is vast, and, as third-party vendors can create their own services for SharePoint Server. A list of services includes the following:

You can set up a single service application to be shared among multiple web applications or deploy multiple instances of the same service across a farm and, in some cases, across multiple farms. Also, there is no limitation regarding the number of services that can be deployed in any single farm. A typical planning scenario requires that you either set up services to share across multiple web applications or isolate an individual service to one or a limited number of web applications. We can publish below service applications across the farm.

  • Business Data Connectivity
  • Machine Translation
  • Managed Metadata
  • User Profile
  • Search
  • Secure Store

Navigate to “Central Admin -> Application Management ->Manage Service Applications” and click on “New” from ribbon to see the list of service applications available.

Service-Applications-in-SharePoint-1300x674
Advertisements
Advertisements

you can use powershell command to get the list of  service applications

Get-SPServiceApplication | Format-Table -wrap
Service Applications in SharePoint
Get-SPServiceApplication
Get-SPServiceApplication -Identity 48fbecaa-71e4-4f1d-bdfe-bdcbc17fa061 | Format-Table -wrap
Get-SPServiceApplication-1324x186

sharepoint services 2016

For every service application there is a service associated with it which you can from central admin by navigating to “Central Admin -> Application Management -> Manage Services on Server”.

manage-services-on-server-1273x441
services-on-server-1324x870
Advertisements
Advertisements

Alternatively you can use the powershell command as below

Get-SPServiceInstance | Format-Table -wrap
Get-SPServiceInstance-873x1099
Get-SPServiceInstance | Where {$_.Status -eq "Online"} | Format-Table -wrap
Get-SPServiceInstance-formt-1154x933

Similarly we can start the service instance by running the below command.

Start-SPServiceInstance e63962e4-e1ea-4b83-a9cc-df51683e85f3
server-farm-in-sharepoint-1920x1080

server farm in sharepoint

Advertisements
Advertisements

server farm in sharepoint

Group of servers in a single location represents one server farm. It lies in the highest-level element in design structure, and each server farm offers physical isolation of your resources from other server farms. We can be deploy sharepoint in one farm or across multiple server farms depending on requirements. Below points represent various points based on which can decide whether to to deploy on a single farm or across multiple farms :

  • Needing multiple dedicated services farms to accommodate heavier use of specific services
  • Having separate operational divisions of responsibility in your organization requiring isolation of resources
  • Funding that is dedicated for specific purposes requiring more than one farm
  • Using separate data center locations
  • Satisfying any industry or legal requirements for physical isolation between sites for your organization
  • Using multiple server farms to enhance performance and scalability as well as licensing requirements and publishing environment goals

if there is plan on sharing multiple resources in SharePoint environment, a single server farm is sufficient. If requirement is like services and resources to be isolated for any of the circumstances listed above, we require several server farms and probably one server farm per isolation requirement.

In an enterprise-level environment with its needs operating and changing dynamically on many levels, planning for multiple server farms is the better option, assuming isolation is weighted more heavily than budget concerns.

Advertisements
Advertisements
logging-1920x1080

log management open source

log management open source

In this article we will discuss about log management open source. How to manage log using powershell. Below are points we will check using powershell.

  • Check what are the diagnostic provider
  • How to disable or enable event log provider
  • ULS log settings or sharepoint 2016 logs location
  • Change ULS log settings or sharepoint 2016 logs location
  • How to find ULS logging level
  • Set ULS log verbose
Advertisements
Advertisements

Check what are the diagnostic provider

we can use the powershell cmdlet “Get-SPDiagnosticsProvider” to check what are the diagnostic provider.

log-management_1589x611

How to disable or enable event log provider

We can run the below to command to disable event log provider that is “job-diagnostics-event-log-provider” provider.

Get-SPDiagnosticsProvider job-diagnostics-event-log-provider | Set-SPDiagnosticsProvider -Enable:$false
Get-SPDiagnosticsProvider job-diagnostics-event-log-provider
job-diagnostics-event-log-provider-1581x277

We can run the below to command to enable event log provider that is “job-diagnostics-event-log-provider” provider

Get-SPDiagnosticsProvider job-diagnostics-event-log-provider | Set-SPDiagnosticsProvider -Enable:$true
Get-SPDiagnosticsProvider job-diagnostics-event-log-provider
enable-job-diagnostics-event-log-provider-1577x268
Advertisements
Advertisements

ULS log settings or sharepoint 2016 logs location

We can run the command “Get-SPDiagnosticConfig” to get ULS  logging settings

Get-SPDiagnosticConfig
Get-SPDiagnosticConfig-1315x687

Change ULS log settings or sharepoint 2016 logs location

we can run the command “Set-SPDiagnosticConfig” to Change ULS log settings or sharepoint 2016 logs location.

PS C:\> Set-SPDiagnosticConfig -DaysToKeepLogs 7 -LogLocation "E:\Logs" -EventLogFloodProtectionEnabled
PS C:\> Get-SPDiagnosticConfig
change-sharepoint-2016-logs-location-1317x712
diagnostic-logging-1255x665
Advertisements
Advertisements

How to find ULS logging level

We can run the command “Get-SPLogLevel” to find ULS logging level.

Get-SPLogLevel -identity "eApproval:*", General, audit, "Business Data"
Get-SPLogLevel-1314x534

Set ULS log verbose

we can set ULS log Verbose and categories by using “Set-SPLogLevel

Set-SPLogLevel -TraceSeverity verbose -EventSeverity verbose -Identity "eApproval:*", General, audit, "Business Data"
Get-SPLogLevel -identity "eApproval:*", General, audit, "Business Data"
Set-SPLogLevel-1317x625

Create new log file

we can create a new log file by running the command below.

New-SPLogFile
new-splogfile-1316x108
Advertisements
Advertisements