Monday, October 29, 2012

SharePoint Configuration Wizard is not running (mssql$officeservers failed to start)

SharePoint Configuration Wizard is not running (mssql$officeservers failed to start)

go to run type “regedit”
browse to “HKLM_Local_Machine/Software/Microsoft/Shared Tools/Web Server Extensions/12.0/WSS/”
Change value of attribute  “ServerRole” from SINGLESERVER to APPLICATION


Tuesday, May 22, 2012

Unable to upload flash (.SWF) file to SharePoint Document Library


If you are getting "Access Denied"  message while trying to upload  SWF file to SharePoint (2010), you can remove swf file extensions using commands below.

You need to run these from SharePoint power shell
Get your application
$sa = Get-SPWebApplication http://mysite.mycompany.com

List blocked files
$sa.WebFileExtensions

remove swf file extensions from blocked list
$sa.WebFileExtensions.Remove(“swf”)

update..
$sa.Update

Note: Make sure that you are using url of your windows based site.



Thursday, March 29, 2012

What can I do to stop getting Alerts - SharePoint 2010

Steps to Remove SharePoint 2010 Alerts


go to "My Alerts on this Site"

http://mysharepointsite.com/_layouts/MySubs.aspx

Select and Remove the "Alert" 

What happened to “Alert Me” SharePoint 2010 document library?


There are two different settings you need to check.

1. Central admin / Manage web applications / General Settings / outgoing emails

Make sure you configured this correctly.



2. Central admin / Manage web applications / General Settings / General Settings

Make sure “Alerts” are turned “On”

Saturday, March 3, 2012

SharePoint 2010 – How to open files that prompt for Save or Cancel

Clayton blogged about how to change these settings from SharePoint central admin. 

I don't want to copy his content  but like to add that this configuration changes "will work even from your custom user controls/webparts"

Tuesday, February 21, 2012

SharePoint 2010 User profile service


I was asked multiple times to help locate "User Profile Repository" for SharePoint 2010.

You can follow the steps below to access it. You need access SharePoint 2010 "Central admin site" for this purpose.

Select “SharePoint 2010 Central Administration” from start menu
Select “Application Management“
Select “Manage service applications“
Select “User Profile Service Application”
Select “Manage User Profiles”


Thursday, February 16, 2012

How do you “Divide Share Equally” among a number of people?


Easy isn't it.. 100% / number of people   100/2 = 50%

Now 100/3….=  33.33333333333333…….
One compromised solution is 33.33, 33.33 and 33.34.  so one of them will get a 0.01 percent more, if that is not a big deal.

I ended up writing some code for this and I hope it will be useful for you.

See C# sample code below

        private List<double> GetPercentages(double numberOfItems)
        {
            List<double> percentages = new List<double>(); 
            double totalPercentage = 100.00;
            double averagePercentage = Math.Round(totalPercentage / numberOfItems, 2);
            double reminder = Math.Round(100 - (averagePercentage * numberOfItems),2);

            for (int i = 0; i < numberOfItems; i++)
            {
                double percentageValue = averagePercentage;
                if (reminder != 0)
                {
                    if (reminder > 0)
                    {
                        reminder = Math.Round(reminder - 0.01,2);
                        percentageValue += 0.01;
                    }
                    else
                    {
                        reminder = Math.Round(reminder + 0.01,2);
                        percentageValue -= 0.01;
                    }
                }

                percentages.Add(Math.Round(percentageValue,2));
                percentages.Sort();
            }
            return percentages;
        }

Please add a comment if this is useful.

Monday, January 9, 2012

SharePoint : Broken PDF file icon, Search not indexing pdf documents

Issue 1 : PDF file icon is missing in SharePoint server. SharePoint UI shown broken image URL.
Issue 2: SharePoint Search is not indexing PDF document.


Solution :
                Install PDF  iFilter  from 


Please see the original article  from MSDN http://support.microsoft.com/kb/2293357


Configure Adobe iFilter based on steps mentioned below: http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025


  • Install PDF iFilter 9.0 (64 bit) from  http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
  • Download PDF icon picture from Adobe web site http://www.adobe.com/misc/linking.html  and copy to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES\ 
  • Add the following entry in docIcon.xml file, which can be found at: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML
  • Add pdf file type on the File Type page under Search Service Application
  • Open regedit
  • Navigate to the following location:
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\14.0\Search\Setup\ContentIndexCommon\Filters\Extension
  • Right-click > Click New > Key to create a new key for .pdf
  • Add the following GUID in the default value {E8978DA6-047F-4E3D-9C78-CDBE46041603}
  • Restart the SharePoint Server Search 14
    • net stop osearch14
    • net start osearch14
  • Reboot the SharePoint servers in Farm
  • Perform FULL Crawl to get search result.
Once the crawl is completed we will get search results and pdf icon