SharePoint Diary

How to Create Default Groups in SharePoint Site?

August 27, 2014 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Users and Groups

Problem: The default SharePoint groups are created automatically when you create a site collection through SharePoint Web UI. But, when you create SharePoint sites programmatically or with PowerShell (E.g. New-SPSite or New-SPWeb), The default site groups (such as: Visitors, Members, Owners) are not created automatically! Default groups creation from UI: You can get the default group page from SharePoint UI by navigating to: http://your-sharepoint-site.com /_layouts/permsetup.aspx . Enter group details and hit "Save". How to create default SharePoint groups: You have to call the method: SPWeb.CreateDefaultAssociatedGroups explicitly. to create default user groups in SharePoint. Create Default User Groups programmatically using PowerShell: Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue #Variables for Site collection $SiteURL ="https://intranet.crescent.com" $Site = Get-SPSite $SiteURL #get the Root Web object $RootWeb = $Sit

How to Create Default Groups in SharePoint Site?

Reviewed by Salaudeen Rajack on August 27, 2014 Rating: 5

Installing and Configuring ADFS Integration with SharePoint 2013 - Step by Step Guide

August 26, 2014 Deployment Guides, Security, SharePoint, SharePoint 2007, SharePoint 2013

Introduction: Active directory federation services is the solution for extending enterprise identity beyond corporate firewall. It simplifies sharing identities between trusted partners across organizations. Its a common requirement in a typical business scenario, users in one organization wants to access a secured application/website from an another organization. Without ADFS, we'd end-up re-creating user logins for the partner company in our AD. But that introduces the problem of maintaining and managing two separate identities for the partner company users. Here is where ADFS comes to the picture. It solves the problem by federating identities and establishing single sign-on capability. SharePoint 2013 - ADFS integration is seamless as its natively supported. Generally, in SharePoint world, ADFS is used in these three scenarios: Domains which are not part of your AD forest (Such as acquired companies without trusts established, with network connectivity between them in

Installing and Configuring ADFS Integration with SharePoint 2013 - Step by Step Guide

Reviewed by Salaudeen Rajack on August 26, 2014 Rating: 5

SharePoint 2013 Warmup Scripts using PowerShell

August 22, 2014 Performance Optimization, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is "Warmup Scripts" in SharePoint? By default IIS applications pools recycles every night to keep clean memory space - Every time during IIS Application pool recycles - Asp.net assemblies to be re-compiled to serve the page to end user. So, When the recycling occurs during mid night (or when you do manual recycling/IISReset), The very first user types the URL, experiences the wait time of 30 seconds to 120 seconds on an average. (again, this depends on your hardware-software configurations!). But the subsequent requests come faster from the server for the same site! So, the idea is: "warm up" the site before users start requesting it so that they don't suffer at first time hit. Warm up scripts triggers requests to your servers regularly to "Warmup" IIS. Ok, Where is the script? which warm up script I've to use? Well, There are lot many available. Here is one among them: https://spbestwarmup.codeplex.com/ and You may have to customize i

SharePoint 2013 Warmup Scripts using PowerShell

Reviewed by Unknown on August 22, 2014 Rating: 5

Save Site as Template in Sharepoint 2013 using PowerShell

August 22, 2014 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

How to save site as template in SharePoint 2013? The most easiest way to create a standard template for your SharePoint sites is to Create a site, Add-remove content, list and libraries to it and save site as a template from Site Settings >> Save Site as template. - Shortcut URL: "/_layouts/savetmpl.aspx" Save Site as Template in SharePoint 2013 using PowerShell You can save your site as template even with the publishing feature using the following PowerShell command $WebURL = "http://your-site-collection-URL" #Get the Web Object $Web= Get-SPWeb $WebURL #Variables for Save site as template settings $TemplateName ="PMO Site Template" $TemplateTitle ="PMO Project Site Template" $TemplateDescription ="Site template for PMO project management portal" #Option to Save with content $SaveWithContent= 1 #0 otherwise #Save site as template programmatically with PowerShell $Web.SaveAsTemplate($TemplateName,$TemplateTitle

Save Site as Template in Sharepoint 2013 using PowerShell

Reviewed by Salaudeen Rajack on August 22, 2014 Rating: 5

Create SharePoint Service Accounts in AD using PowerShell

August 22, 2014 Active Directory, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

I do a lot of SharePoint deployments now a days. I use PowerShell scripts to quickly create SharePoint service accounts instead of manually creating them in Active directory one by one. Run the below PowerShell script from domain controller (or from Remote Server Administration Tools installed workstation) to create service accounts in one-short. Here is the list of Service accounts I use in my SharePoint 2013/SharePoint 2010 deployments: SP_Setup - SharePoint Setup account SP_Farm - SharePoint Farm account SP_Pool - The account is used to run the Web Application Pools SP_Services - The Services Account is used to run the Service Applications SP_Crawl - The Default Content Access Account for the Search Service Application SP_UserProfile - The User Profile Import and Synchronization Account SP_SuperUser - Cache account for Web application super User account SP_SuperReader - Cache account for Web application super reader account SQL_Admin - SQL Admin on the S

Create SharePoint Service Accounts in AD using PowerShell

Reviewed by Salaudeen Rajack on August 22, 2014 Rating: 5

How to Change Managed Account Password in SharePoint 2013?

August 20, 2014 PowerShell, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

You may have to change your service account passwords for reasons such as: Password expiration, Security best practice, Your SharePoint guy left your company, etc. Remember those old days? You got to run stsadm -o updatefarmcredentials and update application pool accounts on every server in the farm? Luckily, we got managed accounts feature starting from SharePoint 2010 on-wards. The primary advantage of the managed accounts idea is: To centrally manage service accounts of SharePoint in one place, by registering and mapping them with SharePoint Services such as: Farm, Service Applications, Application Pools, etc. So, whenever you need to change the service account's password, Update them once from SharePoint Central Administration site (or PowerShell!). How to change password of a managed account in SharePoint 2013 There are three different cases to change managed account passwords in SharePoint 2013 either from SharePoint Central Administration or using PowerShell. Generat

How to Change Managed Account Password in SharePoint 2013?

Reviewed by Unknown on August 20, 2014 Rating: 5

Create New Managed Account in SharePoint 2013 Using Powershell

August 20, 2014 PowerShell, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Managed accounts are active directory accounts for SharePoint's whose credentials are managed by SharePoint. Managed accounts in SharePoint 2013 is explained in my another article: Configuring Managed Accounts in SharePoint 2013. Important: Before creating a managed account, They must be already created in your Active directory. How to create a managed account in SharePoint 2013? To register new managed account in SharePoint 2013, here are the steps: Open SharePoint 2013 Central administration site. Go Security >> Click on Configure Managed Accounts. Click the Register Managed Account link to create a new managed account. Enter the account’s AD username in domain\username format. Specify the account's password. Optionally, You can enable the automatic password reset. Click "OK" to to create managed account in SharePoint 2013. Important: To register managed account SharePoint 2013, You must be a member of Farm Administrators SharePoint group. Cre

Create New Managed Account in SharePoint 2013 Using Powershell

Reviewed by Salaudeen Rajack on August 20, 2014 Rating: 5

Limit Maximum Number of Site Collections in SharePoint Content Database using PowerShell

August 19, 2014 Content Database, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

By default maximum number of site collections in a SharePoint 2013 content database is set to: 5000 and warning level will be 2000 as initial configurations. Although, technically SharePoint 2013 content database can hold up to 10,000 site collections maximum (2,500 non-Personal site collections and 7,500 Personal Sites, or 10,000 Personal Sites alone), 5000 is the recommended limit! There are times, you may want to dedicate a database for a single site collection. When you create a site collection from central admin, site is placed automatically in any available content database. To prevent any other sites to be created on the particular content database, We can set the maximum number of sites limit! To set maximum number of site collections on a particular content database, navigate to: SharePoint 2013 Central Administration >> Application Management >> Management Content databases Select your target web application in which the particular content database is attache

Limit Maximum Number of Site Collections in SharePoint Content Database using PowerShell

Reviewed by Salaudeen Rajack on August 19, 2014 Rating: 5

"Open with Explorer" Greyed out in SharePoint 2013?

August 18, 2014 Known Issues, SharePoint, SharePoint 2010, SharePoint 2013

Open with Windows Explorer is Disabled in SharePoint 2013 or in SharePoint 2010? Well, Open with Explorer works only in 32 bit version of Internet Explorer! It may not work on Chrome or Firefox. Solution: To enable Open with explorer, Open your SharePoint 2010 or SharePoint 2013 site with 32 bit version of Internet explorer, located at: "C:\Program Files (x86)\Internet Explorer\iexplore.exe" Getting error on clicking open with explorer in SharePoint 2013? Well, Use this checklist to resolve: Open with Windows Explorer Error and Solutions for SharePoint

"Open with Explorer" Greyed out in SharePoint 2013?

Reviewed by Salaudeen Rajack on August 18, 2014 Rating: 5

How to Check SQL Server Connectivity from SharePoint?

August 14, 2014 PowerShell, SharePoint, SQL Server, Troubleshooting

How do I quickly check SQL Server connectivity from SharePoint server? Well, you can use Telnet. telnet {SQL-Server-Name or IP} 1433 If your SQL Server listens on different port, change the default port 1433 accordingly. Using PowerShell to test SQL server connectivity: Or you can use PowerShell to check if SharePoint it able to connect with SQL Server: (New-Object System.Net.Sockets.TCPClient("SQL-Server-Name",1433)).Connected This tells you whether the particular PORT is open on the given server. Check SQL Server Connectivity by establishing a connection: Run this PowerShell script to test whether you are able to connect with SQL Server. Function Check-SQLServerConnection([string]$serverInstance) { $connectionString = "Data Source={0};Integrated Security=true;Application Name=CheckSQLServer" -f $serverInstance; $sqlConn = new-object("Data.SqlClient.SQLConnection") $connectionString; Write-Host $connectionString try {

How to Check SQL Server Connectivity from SharePoint?

Reviewed by Salaudeen Rajack on August 14, 2014 Rating: 5

How to Rename SharePoint 2013 Central Admin Database to Remove GUID?

August 14, 2014 Central Administration, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Database

When you run the SharePoint products configuration wizard right after installing SharePoint binaries, it creates SharePoint central administration database with GUIDs. E.g. SharePoint_AdminContent_a149fa83-d2b9-4ad9-9e4c-ad12f73f0dd6. Your DBAs may not be happy with these GUIDs as they deviates from database naming standards. So, lets rename SharePoint Central administration content database with the following steps: Always, Remember to backup SharePoint Central Admin database prior performing these steps. Here is how to remove GUID from SharePoint 2013 Central Admin database in three simple steps: Step 1. Detach Central Admin Content Database: Detach Central Admin Content Database: (PowerShell: Dismount-SPContentDatabase ) stsadm -o deletecontentdb -url http://centraladmin:2013 -databasename SharePoint_AdminContent_a149fa83-d2b9-4ad9-9e4c-ad12f73f0dd6 -databaseserver SP13_SQL Step 2. Rename the Content Database from SQL Server Right click the database, Choose Propertie

How to Rename SharePoint 2013 Central Admin Database to Remove GUID?