Problem: I had a requirement to setup new SharePoint 2010 environment. After everything, created user profile service application to get users synced. Got "MOSS MA not found" error on adding a synchronization connection while configuring user profile service application. Solution: Go to Services Console (Start >> Administrator Tools >> Services) and then start these services. Forefront Identity Manager Synchronization Service Forefront Identity Manager Service Synchronization Service Restarting "User profile synchronization service" from SharePoint Central Administration, Services on Server page fixed the problem in an another case. Other things to look at: Firewall - FIM service should be accessible via port 5725 on local machine. Remove and Re-Add Farm Admin to 'Administrators' section with Full Control in User profile Service application Server Reboot!
Delete user from all site collections in SharePoint 2010/2013 using PowerShell: Some times, we may need to delete a particular user from all site collections. Say for e.g. Employee leaves the company! Here is how to remove a user from all SharePoint sites using PowerShell. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Function Delete-UserFromAllSites([string]$WebAppURL, [string]$UserID) { #Get All Site collections $SitesColl = Get-SPWebApplication $WebAppURL | Get-SPSite -Limit All foreach($Site in $SitesColl) { write-host "Processing site:" $Site.RootWeb.URL #Check if user Exists in the site collection $User = $Site.RootWeb.SiteUsers | Where-Object {$_.LoginName -eq $UserID} #If user account found if($User -ne $null) { #Remove User from the Site Remove-SPUser $UserID -web $Site.RootWeb.URL -confirm:$false write-host "
Requirement: Uncheck and Hide Overwrite existing files Option in Upload Document Page of SharePoint 2010. Solution: If the "Overwrite existing files" option to be turned off for all uploads, You can Locate these lines and Change the Checked="true" to Checked="false" in Uploadex.aspx file as below: <asp:CheckBox id="OverwriteSingle" Checked="true" Text=<%$Resources:wss,upload_document_Overwrite_file%>" runat="server" /> <asp:CheckBox id="OverwriteMultiple" Checked="true" Text=<%$Resources:wss,upload_document_Overwrite_version%>" runat="server" /> Alternatively, Lets set this option only for specific site. Login to your SharePoint Web Front End Server, Navigate to: "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\template\layouts" folder Make a backup of "Uploadex.aspx" file and open it in Notepad. Searc
Problem: In a SharePoint 2010 environment, People picker is very slow! It takes more than 30 seconds to resolve any given users names in person or group fields. SharePoint 2010 People Picker is too slow resolving Solution: Instruct people picker to search only within given AD domains! Here is how: Set People Picker SearchADForest domains: stsadm -o setproperty -pn peoplepicker-searchadforests -pv "domain:crescent.com" -url "https://portal.crescent.com" If you have multiple domains, add ; as separators in PV parameter. E.g. "domain:Apac.crescent.com;domain:crescent.com" in 2 way trusted domains. To get People Picker SearchADForest value applied: Stsadm -o getproperty -pn peoplepicker-searchadforests -url "https://portal.crescent.com/" To Clear People Picker SearchADForest values if exist already: Stsadm -o getproperty -pn peoplepicker-searchadforests -pv "" -url "https://portal.crescent.com/"
Problem: SharePoint site gave "System.ArgumentException: Value does not fall within the expected range" error! Here are some possible root causes and solutions Case 1: While fetching List item Lookup values programmatically Root cause: List view threshold value Exceeded! This occurs due to throttling limit on list view lookup threshold value under web application settings. Try increasing it. Go to Central Administration >> Application Management >> Manage web applications Select your web application, Click on General Settings >> Resource Throttling from the ribbon Enter the value for List View Lookup Threshold. E.g. 36 PowerShell script to increase list view lookup threshold value. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $WebApp = Get-SPWebApplication "http://sharepoint.crescent.com/" #Set List View Lookup Threshold $WebApp.MaxQueryLookupFields = 36 $WebApp.Update() Case 2: Invalid Field Names
New-SPLogFile cmdlet in SharePoint 2013 creates new ULS trace log file on execution. In other words, once you execute this New-SPLogFile command, it ends the current log file and creates a new log file. All subsequent errors will be placed in the new log file, which intern greatly helps to isolate all new errors. Its a good idea to start a new log file when you troubleshoot any issues in SharePoint as identifying current issue from existing logs could be cumbersome while existing log files can become large and difficult to scan through. Here is how you can utilize New-SPLogFile cmdlet. Go to SharePoint PowerShell Management Shell Type: New-SPLogFile and hit enter. It doesn't has any parameters. Now, your new trace log file will be created. Once the new log file is created, you can trigger the event that is causing issues. Get your trace log location from diagnostic log path. Go to: Central Administration >> Monitoring >> Configure diagnostic logging >>
How to redirect http to https in SharePoint 2013? Changing SharePoint site from http to https is a common requirement. URL Rewrite module is a great plugin for IIS to achieve various sort of redirects in your SharePoint site (or any web site technically!). Lets see how to implement HTTP to HTTPS redirect with IIS URL Rewrite Module. Assuming you have SSL certificate for your website imported in IIS and 443 Binding is added. Also you have AAM Entry for HTTPS! Prerequisites: Download and Install URL Rewrite module As a prerequisite, you need to have URL rewrite module added to your web server. If its already installed in your web server , you'll find "URL Rewrite" module icon as below. If its not installed already, Go to https://www.iis.net/downloads/microsoft/url-rewrite download and install URL rewrite module. Lets configure URL redirect to change SharePoint site from http to https. Configure HTTP to HTTPS Redirect using URL Rewrite Open IIS >> Sel
We got a requirement to remove Share, Follow and Sync buttons in SharePoint 2013. Let me summarize various ways to disable these buttons. How to disable "Share" button in SharePoint 2013? Share functionality in SharePoint allows existing users of the site to invite someone to SharePoint. Once the request is made, the site owner gets notified and can choose whether to approve or reject the permission request from Site Settings, Access Requests. Share button is relying on "Access requests" configuration of the site. To disable "Share button" in SharePoint 2013, simply disable access requests. Go to Site settings page of your SharePoint site. Click on "Site Permissions" link under "Users and Permissions" group Click on "Access Request Settings" in the ribbon. Uncheck "Allow access request" and click on "Ok" to save your changes. This should hide Share button in SharePoint 2013. Remember, You will ha
To determine SharePoint edition installed , use this PowerShell script: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Hashtable to define Installed product from its GUID #Based on: https://msdn.microsoft.com/en-us/library/office/jj659075.aspx and #https://msdn.microsoft.com/en-us/library/ff721969.aspx $SharePointProducts = @{ "BEED1F75-C398-4447-AEF1-E66E1F0DF91E" = "SharePoint Foundation 2010" "1328E89E-7EC8-4F7E-809E-7E945796E511" = "Search Server Express 2010" "B2C0B444-3914-4ACB-A0B8-7CF50A8F7AA0" = "SharePoint Server 2010 Standard Trial" "3FDFBCC8-B3E4-4482-91FA-122C6432805C" = "SharePoint Server 2010 Standard" "88BED06D-8C6B-4E62-AB01-546D6005FE97" = "SharePoint Server 2010 Enterprise Trial" "D5595F62-449B-4061-B0B2-0CBAD410BB51" = "Sha
Requirement: To follow standard naming conventions, We got to rename SharePoint content databases in our SharePoint 2013 environment. Solution: You can rename a SharePoint content database in these three steps as explained in my another post: How to Rename SharePoint 2013/2010 Central Admin Database and Remove GUID Detach SharePoint content database from SharePoint web application Rename the content database in SQL Server Attach the renamed content database back to SharePoint With the help of PowerShell, Lets automate these manual steps. Rename SharePoint content database with PowerShell: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Load the assemblies required for the SQL database rename. [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo") [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") [void][System.Reflection.Assembly]::LoadWithPartialNam
Problem: NodeRunner.exe is consuming a lot of memory and CPU resulted in performance issues on SharePoint 2013 server. Solution: NodeRunner.exe is a SharePoint 2013 Search service component and it is resource hungry. To reduce the CPU and Memory impact of this process, follow below steps: Step 1: Reduce the CPU impact of the search service By default SharePoint search uses "maximum" to speed up its search crawling process. To reduce the CPU usage of the search service, run this PowerShell script from any one of your SharePoint 2013 server: Set-SPEnterpriseSearchService -PerformanceLevel Reduced This sets Search Service Application crawl component to use less number of threads. Step 2: Limit the NodeRunner.exe's Memory usage: Open the configuration file at "C:\Program Files\Microsoft Office Servers\15.0\Search\Runtime\1.0\noderunner.exe.config" Locate the node "nodeRunnerSettings", Set the value for "memoryLimitMegabytes" at
Requirement: Delete SharePoint online Site Collection using PowerShell. How to delete a site collection in SharePoint Online? To delete a SharePoint online site collection from Admin center, follow below steps: Login to your SharePoint online Admin Center (typically: https://TENANT-admin.sharepoint.com/_layouts/15/online/SiteCollections.aspx ) From the site collections list, select the site collection to delete. From the ribbon, click on "Delete" and then confirm by prompt by clicking "Delete" button. Now, lets delete a site collection in SharePoint Online with PowerShell! How to Delete a SharePoint Online Site Collection using PowerShell? Here is the PowerShell script for SharePoint online to delete site collection. Use SharePoint Online Management Shell or PowerShell ISE to run these cmdlets. Import-Module Microsoft.Online.Sharepoint.PowerShell #Variables for processing $AdminSiteURL = "https://crescent-admin.sharepoint.com/" $AdminName =
Problem: Experiencing "Configuration Failed" error message while running SharePoint SharePoint 2013 Products Configuration Wizard right after new installation/patching. It got stuck while performing configuration task 3 of 10. Creating the configuration database... Which ended with an error message: "Configuration Failed: Failed to create the configuration database. An exception of type System.Security.Principal.IdentityNotMappedException was thrown. Additional exception information: Some or all identity references could not be translated." Solutions: Make sure SQL Server is running on a service account which is granted with local administrator access rights! (Not running on accounts such as: local service, network service!) If so, update the Log On account of SQL Server Service in your database server. Check TCP/IP and Named Pipes protocols are enabled in SQL Server. Check your Firewall. Turn it off for time being. Check your event logs for any
Configuration Failed: Failed to create the configuration database in SharePoint Products Configuration Wizard
Reviewed by Salaudeen Rajack
on
February 12, 2015
Rating: 5
Requirement: Create a document library in SharePoint 2013 using PowerShell. PowerShell Script to Create New Document Library in SharePoint: Here is how to create document library in SharePoint 2013 using PowerShell Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue #PowerShell Fuction to Create a Document library in SharePoint Function Create-DocumentLibrary { Param ( [Microsoft.SharePoint.SPWeb]$Web, [String] $LibraryName, [String] $Description ) #Get the Document Library template $ListTemplate = [Microsoft.Sharepoint.SPListTemplateType]::DocumentLibrary #Check if the library already exists if(($web.Lists.TryGetList($LibraryName)) -eq $null) { #Create the Library $Web.Lists.Add($LibraryName,$Description,$ListTemplate) > Null #Set Properties of Library such as OnQuickLaunch, etc $Library = $Web.Lists[$LibraryName] $Library.OnQuickLaunch = $true $Library.Update()
In People picker field in SharePoint 2010 datasheet view, on entering new values got this error message: An Error 0x80070057 Occurred. No further information was provided. Moreover, People picker field drop down was empty! Fix: Open your list in SharePoint designer Edit list columns >> Make some dummy modification to the "Person or Group" column which is causing the problem. Hit save button in SharePoint Designer once done.
SharePoint Datasheet Error: An Error 0x80070057 Occurred. No further information was provided
Reviewed by Salaudeen Rajack
on
February 08, 2015
Rating: 5
Requirement: Open a page in Modal Popup window in a SharePoint 2013 web site. Solution: Requirement is to open "Terms and Conditions" page in popup window on clicking the link. Used this HTML code to open a page in modal popup window in SharePoint 2013: <a href="#" onclick="OpenPopUpPageWithTitle('http://crescent.com/sitepages/terms.aspx', null, 600, 600,'Terms & Conditions')"/> Terms and Conditions </a> and here is the result:
Requirement: Convert Active Directory Group into SharePoint Group! Solution: Managing SharePoint users at Active Directory Security group and within SharePoint has its own advantages and disadvantages too. Now, our requirement is to migrate from AD group to SharePoint group. So, Lets use PowerShell to create new SharePoint group from Active directory security group. Here is my script: Create SharePoint group from active directory group: #Import Active directory & SharePoint PowerShell modules Import-Module ActiveDirectory Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Variables for processing $SiteURL="http://Intranet.crescent.com/" $ADGroupName="SP13 Authors" $SPGroupName="Content Authors" $PermissionLevel="Full Control" #Permission to SPGroup $Domain="Crescent" #AD Domain #Get the Site collection's Root Web $web = Get-SPWeb $SiteURL #Check if Group Exists already if ($web.SiteGroups
SharePoint 2013 introduced a new concept called Minimal download strategy to minimize the amount of data downloaded from your SharePoint site to client and making it load faster. For example when we navigate from a site's home page to Shared Documents page, MDS downloads only the content that has changed between the source and destination pages. The feature is scoped at site level (SPWeb) and activated by default in certain site templates such as team sites, community sites, blog, projects, wiki etc. (not available with publishing sites). When MDS is activated, you will find in the page URL /_layouts/15/start.aspx followed by a hash(#) and then the relative url of the site you requested. E.g. http://www.crescent.com/sales/_layouts/15/start.aspx#/SitePages/home.aspx Deactivating this feature will no longer redirect all of the URLS to include the /_layouts/15/start.aspx# path in your address, keeping everything nice and tidy. E.g. http://www.crescent.com/sales/SitePages/home.
Problem: Tried publishing a blog post to SharePoint blog from Microsoft Word 2013 from "File >> Share >> Publish to Blog". While registering a new SharePoint blogging account, got this error message "Word cannot register your account. The provider where you are trying to publish is unavailable. Contact your provider for assistance." Solution: Go to SharePoint 2013 Central Administration >> Manage Web Applications >>Web Application General Settings >> Set the option for "Allow user name and password from the API" to Yes. Another cause and solution: If your current logged in Windows user account isn't the same as your SharePoint account, You may get this error! Set your Internet Explorer's settings to prompt of user name and password. Delete your cookies and try again. You should get this "Account registration successful" message.
Word cannot register your account. The provider where you are trying to publish is unavailable. Contact your provider for assistance.
Reviewed by Salaudeen Rajack
on
February 05, 2015
Rating: 5
If SharePoint Application Pools are stopped that would cause "Service Unavailable" outages to your SharePoint environment! While SCOM can monitor SharePoint IIS web application's application pool status, it makes bit more noisy with alerts and doesn't start the application pool automatically - when stopped. So, lets address this issue with the help of PowerShell! Here is my nifty PowerShell script to monitor application pools on all SharePoint web front end servers. This script not only scans IIS Application Pool status on SharePoint Web-Front end servers, But also: Logs application Pool status if its not in Started state Automatically starts AppPool if its in stopped state Sends out an Alert-Email to SharePoint Admin team (or whoever configured!) PowerShell script to Monitor IIS Application Pool statues: Import-Module WebAdministration #Array to hold Server names - Change it to YOUR SharePoint front end servers $WFEServers =("HS-WFE01", "HS-W
Reviewed by Salaudeen Rajack
on
February 28, 2015
Rating:
