SharePoint Configuration/Troubleshooting

Recently got a defect from Testing team mentioning that they are facing issues in opening documents from SharePoint site Library in Client application like MS Word, Excel, PowerPoint etc.  They confirmed that they have selected  Open in the client application  option under Library Settings - Advanced Settings - Opening Documents in the Browser however still the files were opening in Browser (OWA). Also since OWA was not completely setup it looked like OWA issue however then I identified a Site Collection Feature which needs to be activated to get files opened in Client Application and here is the name of that feature: Go to Site Collection > Site Settings > Site collection features > Open Documents in Client Applications by Default Please let me know if any further queries. Thank you!

Today I was working on installation & configuration of Office Web Apps for one of the SharePoint Extranet Farm, installation of OWA went successfully however while creating Office Web Apps Farm I started facing a weird issue where the certificate for OWA was available on server however it was still unable to find it:  Error Below: ------------------- PS D:\> New-OfficeWebAppsFarm –InternalUrl "https://owaserver01.domain.com/" -ExternalUrl "h ttps://owa.domain.com/" –CertificateName "owa.domain.com" –EditingEnabled New-OfficeWebAppsFarm : Office Web Apps was unable to find the specified certificate. At line:1 char:1 + New-OfficeWebAppsFarm –InternalUrl "https://owaserver01.domain.com/" -Ex ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + CategoryInfo          : ObjectNotFound: (:) [New-OfficeWebAppsFarm], ArgumentException     + FullyQualifiedErrorId : CertificateNot...

Hello All, Good Morning :) Yesterday while working on an issue I came across a situation where I misplaced URL's of some hidden lists which were shared with us in our SharePoint site collection and I really wanted to access the list to get some details.  I started looking for some PowerShell script to find hidden lists however couldn't find a good script online.  After sometime I thought of opening the site in SharePoint Designer and see if the lists can be found there.  So when I opened SP Designer and clicked on Lists and Libraries under Navigation - Site Objects hoping that the list should be seen here, however it wasn't available there as well. Here is how I was able to found that list: 1. Open your SharePoint site in SP Designer 2. Under Navigation - Click All Files 3. Under All Files you will see a folder called "Lists" 4. In this folder you will see all your lists which are hidden to all users (Administrators as well). In order to grab URL...

I came across a situation where in there were multiple SharePoint farms which had their own User Profile service application and there was a farm which was consuming User Profile Application from another farm and it was not documented from which farm it is consuming.  For some troubleshooting purpose I wanted to find out from which farm the User Profile application is consumed, I didn't find any easy way from SharePoint Central Administration.  So finally I thought Powershell should be helpful here. I used below cmdlets to find out the server farm from where UPA was consumed: 1. Get-SPServiceApplicationProxy | select TypeName, ID | Format-Table -AutoSize 2. Copy GUID of User Profile Application Proxy 3. After you have ID for the User Profile Application Connection Proxy, run below cmdlet:     $upa = Get-SPServiceApplicationProxy -Identity "Paste ID of Connection Proxy copied" 4. $upa | select ServiceEndPointURI | Format-List This above cmdlet will ha...

Issue Description: ============== You are not able to see columns associated with 'Document Set' content type when you view or edit properties of Document Sets. When you view or edit properties of Document Set you can just see the "Name" column.  Resolution ======== You can add a web part to the DispForm.aspx or Editform.aspx and then add a connection filter for the web part. 1. Open the affected site in SharePoint Designer  2. Navigate to the affected Library where you have the Document Sets.  3. Edit the Dispform.aspx and search for below line in the code: <TemplateName xmlns="http://schemas.microsoft.com/WebPart/v2/ListForm">DocumentLibraryForm</TemplateName> 4. Comment out or delete the above code of line and save the page.  5. If you see the same thing when you edit properties of Document Set then do the same thing for Editform.aspx and save the changes.

Issue Description: ================ You configure the App Management Service in the farm but while trying to add any app you receive the following error: Sorry, apps are turned off. If you know who runs the server, tell them to enable apps. Cause ======= The server was running out of memory.  Steps to Resolution ================ 1. We tried to add an app using a non-system account, however we received the following error: Sorry, apps are turned off. If you know who runs the server, tell them to enable apps. 2. We tried to browse SharePoint Central Admin - Apps - Configure App URL's and got below error:  Sorry, something went wrong Settings or services required to complete this request are not currently available. Try this operation again later. If the problem persists, contact your administrator.  Technical Details  Troubleshoot issues with Microsoft SharePoint Foundation.  Correlation ID: 6379209c-5068-40f4-5407-6ef37b5fe7a3  Date a...

Issue: ======== "A system restart from a previous installation or update is pending . Restart your computer and run setup to continue." Steps to Resolution: ==================== 1. Open the registry from Start > Run > regedit 2. Go to " HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager " 3. Rename the key "PendingFileRenameOperations" to someting like PendingFileRenameOperations_OLD 4. Close the registy editor. Now run the PSConfig wizard to complete the setup. NOTE : Before you make any changes to the registry use the EXPORT option to take a backup of the registry

Recently I have seen issues while accessing newly created SharePoint 2013 site collections that when we access the site the request gets processed by IIS but still on the browser it shows the great message: Working on it.... After looking at it for some time, found that if we try to access the Site settings page "/_layouts/15/settings.aspx" it renders fine. But if we try to access any of the Page, Document Library or any List it gets stuck on the Working on it message. Observed the same behavior on SharePoint server and the client machines.  After investigating further found the solution to this issue Steps for Resolution: Deactivate the new site feature which is introduced in SharePoint 2013 called "Minimal Download Stratergy"  Sign out from the site, close all the browser windows. Open a new browser windows and browse to the SharePoint site and you will see the site now comes up fine. Once the site comes up fine, then you can activate the featu...

You will see n o search results are returned while trying to search for keywords within PDF Documents on the SharePoint site. The reason why it cannot crawl those is because of Insufficient permissions for the 'Default Content Access Account' on the PDF iFilter folder. Below are the steps to resolve this issue: ========================================= • Go to following location on your SharePoint Index and Crawl Server "%Program Files%\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin" directory or the installation location of the pdf ifilter. • Add the 'Default Content Access Account' of the Search Service Application. Make sure you at least provide 'Read', 'Read & Execute' and 'List Folder Contents' permissions to the account. • Once you provide above said permissions then go ahead and start a Full Crawl. • In certain cases, you may also have to reboot the SharePoint servers.

Unable to start the user profile synchronization service, getting the status as starting.  Hence unable to manage the User Profile Service Application.  Cause ====== Below are the ULS and Event errors: ULS Errors ----------- Exception occured while connecting to WCF endpoint: System.ServiceModel.ServiceActivationException: The requested service, 'http://rc-sp-app1:32843/578b171d0ba9428a8406f3d9520d6cce/ProfilePropertyService.svc' could not be activated. See the server's diagnostic trace logs for more information. Server stack trace:       at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory factory, WebException responseException, ChannelBinding channelBinding)      at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)      at Syst...

Remote Desktop is a cool feature of Windows Server 2003 that lets you remotely log on to and work at a machine as if you were seated at the local console (in Windows 2000 Advanced Server, this feature was called Terminal Services in Remote Administration Mode). Remote Desktop can be a lifesaver for fixing problems on servers at remote sites, but what if you forgot to enable the feature before you shipped the server out to Kalamazoo? Enabling Remote Desktop is easy if the server is in front of you: just log on as an administrator, open System in Control Panel, select the Remote tab, and under Remote Desktop select the checkbox labeled "Allow users to connect remotely to this computer." Unfortunately, you can't use the System utility to enable Remote Desktop on a remote machine, though you can access some properties pages of System using Computer Management by first connecting the console to a remote computer, then right-clicking on the root node and selecting ...

Using a SQL provider with forms based authentication means that users will use usernames and passwords that are stored in SQL Server Database. They will use a sign-in page to fill in their credentials and log in. You can of course create your own database for storing credentials, but if you want one to be set up for you very quickly you can create the ASPNETDB by performing these steps: Go to the SQL Server database server On the database server, open Windows Explorer. Navigate to the path %System Drive%\Windows\Microsoft.NET\Framework\v2.0.50727. To start the ASP.NET SQL Server Setup Wizard, double-click aspnet_regsql.exe. Complete the wizard Make sure the Application Pool accounts of the web application(s) and the Central Administration web site have access to the database In order to load up your database with test data you can use the membership seeder tool from CodePlex Download the MembershipSeeder tool from http://www.codeplex.com/CKS/Release/ProjectReleases.aspx...

The following are the different templates that are available for SharePoint: Template Name Description GLOBAL#0   Global template (1033) STS#0   Team Site (1033) STS#1   Blank Site (1033) STS#2   Document Workspace (1033) MPS#0   Basic Meeting Workspace (1033) MPS#1   Blank Meeting Workspace (1033) MPS#2   Decision Meeting Workspace (1033) MPS#3   Social Meeting Workspace (1033) MPS#4   Multipage Meeting Workspace (1033) CENTRALADMIN#0   Central Admin Site (1033) WIKI#0   Wiki Site (1033) BLOG#0   Blog (1033) BDR#0   Document Center (1033) OFFILE#0   Records Center (1033) OFFILE#1   Records Center (1033) OSRV#0   Shared Services Administration Site (1033) SPS#0   SharePoint Portal Server Site (1033) SPSPERS#0   SharePoint Portal Server Personal Space (1033) SPSMSITE#0   Personalization Site (1...