Avoid password prompt while open a document in SharePoint

9. May 2012 06:12 by Rashid Aziz in Sharepoint blogs  //  Tags: , ,   //   Comments
To make SharePoint site a trusted site in order to avoid multiple logon prompts while opening or downloading a document, these following changes are required on client pc. 1. Open Internet Explorer 2. Log on to the site http://SharepointSiteCollectionURL/  or simply copy and paste this URL if you cannot access the site 3. On the Internet Explorer menu bar, select the "Tools" menu, then select "Internet Options" 4. Select the "Security" and then click "Trusted Sites" zone 5. Click the "Sites" button Add the portal address in the "Add this website to the zone" box. Click "Add" Don’t check "Require server verification (https) for all sites in this zone"  option If the site web address is not in the input field, then copy and paste it from the browser address at the top of your browser window. Click on “close” 6. Under the trusted site zone Click on the "Custom Level" button 7. Scroll down to the middle and enable the "Display mixed content" 8. Scroll down to the bottom Under "User Authentication/Logon", select "Automatic logon with Current Username and Password" and click "OK" 9. Click "OK" twice to close all dialog boxes 10. Close all instances of internet explorer 11. The next time you open Internet explorer and log on to site make sure the "Remember my password" option is selected on “Authentication dialog” 12. Now go to a document library and try to download or open a document in MS office, it should not prompt you for credential again. Enjoy ! J

Potentially excessive number of SPRequest objects, SharePoint error

26. March 2012 06:45 by Rashid Aziz in Sharepoint blogs  //  Tags: , ,   //   Comments
I got this error in ULS log file while using one SharePoint application which was developed by third party. I have checked the code and it was disposing the SP objects correctly. The site was running really slow, and it takes about 40 seconds to load the home page. Site structure: Our application has 5 sites under a site collection and about 500 sub sites underneath those 5 sites. Reason of error: The “show subsites” option in navigation setting was checked, so when the page loads it also load 5 sites in navigation menu and all 500 sub sites links as a dropdown link menu. The navigation menu is shipped with SharePoint product, the way it is designed that it use SP Request object to build each navigation link and doesn’t dispose those object automatically (Reason: if the page do refresh, it does not need to re-create all object again) Resolution: Go to site collection home page Click site action> site settings Click “Navigation” link under “Look and Feel” section Uncheck “Show sub sites” under “global navigation” and “current navigation” as shown below If you need that navigation link for all sub sites should be available for user, think about other ways to getting this functionality (e.g. custom navigation), or reconsider your application structure. Results: After doing the above changes, I did not see any log saying “Potentially excessive number of SPRequest objects“. Also site performance increased dramatically as the home page loads in 4 seconds. J Hope this will help.

How to get list of all site owners in SharePoint web application

20. December 2011 02:27 by Rashid Aziz in Sharepoint blogs  //  Tags: , ,   //   Comments
We are implementing governance in place for our SharePoint environment, during the analysis  we need to find out who is the site owner for each site in our SharePoint web applications,  we have about 500 sites and it will be  time consuming to go to each one site settings and find the owners names. I wrote a simple stsadm command to get list of site owners and some other site related information and dump it into a text file. Open the command prompt and navigate to the following path C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN Run the following command. stsadm -o enumsites -url http://WebApplicationURL > c:\allsiteinfo.txt once the command runs successfully , go to c drive and open “allsiteinfo.txt” file. You will see result something like this. <Sites Count="2"> <Site Url="http://testweb/site1" Owner="eblogin\admin" ContentDatabase="MOSS2007DB" StorageUsedMB="36.8" StorageWarningMB="0" StorageMaxMB="0" /> <Site Url=" http://testweb/site2" Owner="eblogin\admin" SecondaryOwner="eblogin\aziz" ContentDatabase=" MOSS2007DB" StorageUsedMB="0.7" StorageWarningMB="0" StorageMaxMB="0" /> </Sites>  If you like my blog please follow me on facebook and twitter to get latest blog alerts.

SharePoint blog with attachment capability workaround

24. November 2011 07:29 by Rashid Aziz in Sharepoint blogs  //  Tags: , ,   //   Comments
By default there are not any settings in sharepoint to enable attachments with blog posts. It is not a perfect way to do this, but worth to mention on my blog I think. I have done a workaround to achieve this Create a custom list inherited form Item with default columns. Create new item “give it a title” and attach your document with it. Now in your post list create a lookup column with the title “Attachment” which will look up to the “Title” column of your custom list. Edit the view of you posts web part on the blog main page and enable it to display the lookup field. You can now see the attachment in the footer. I hope this blogs helps J

SharePoint Cloud Based Service Providers

I have listed few cloud based service providers for SharePoint. If you guys came across any other cloud based service please add it in comments. I am just trying to put all cloud service provider in one place. Microsoft Office 365 Microsoft is committed to delivering business-grade cloud services that work together to support new levels of innovation, efficiency, and agility for your organization http://www.microsoft.com/en-gb/office365/online-software.aspx American Data Technology You as a client benefit from our proven track record of 15 years expertise as a web hosting services provider. http://www.localweb.com/ Igroup Hosted SharePoint They love SharePoint and they use the platform widely within their business. They aim to stand out in our market by offering our products and services in the most self-supporting and responsible way they can. http://www.sharepoint-cloudhosting.com/ Goiwx Goiwx is a cloud hosting services provider specialized in ERP, CRM and other front and back office solutions that you own or want to use. http://www.goiwx.com/ Quantix innovative IT Services Quantix is one of the UK's premier providers of, Managed Cloud Services and Infrastructure Solutions for Enterprises and Independent Software Vendors. http://www.quantix-uk.com/ 724 Internet Solutions 724 is one of the oldest Cloud Computing Providers. In business since 1996, and Hosting SharePoint since 1999, http://www.724hosting.com/ Rackspace Hosting Rackspace Cloud offers four hosting products: Cloud server for on-demand computing power; Cloud sites for robust web hosting http://www.rackspace.com Pay Per Cloud PayPerCloud is a full service cloud hosting company. Their solutions are delivered and backed up with EXPERT level technical support unmatched in the industry http://www.paypercloud.com/ WEB HOSTING UK The number 1 company in the UK offering reliable and affordable web hosting solutions http://www.webhosting.uk.com/ Red Ember Solutions They are dynamic Perth Company specialising in custom solutions tailored to your businesses exacting requirements. http://www.redember.com.au/

Configure performance counter for SharePoint environment

23. November 2011 08:01 by Rashid Aziz in   //  Tags: , , ,   //   Comments
I have explained below how you can setup base line and incident performance count for your sharepoint server. This will allow producing a baseline of the source depletion over a period of time. When a problem is occur, these performance encounters can be used to analyze and compare with respect to the base line data to understand any strange behavior in the system. Baseline performance counter script logman create counter Perf_Baseline -s %COMPUTERNAME% -o C:\PerfLogs\Perf_Baseline_%COMPUTERNAME%.blg -f bin -v mmddhhmm -cf Counter_Server.txt -si 00:01:00 -cnf 12:00:00 -b 4/29/2009 5:00AM -u "domainName\theuserid" * Incident performance counter script logman create counter Perf_Incident -s %COMPUTERNAME% -o C:\PerfLogs\Perf_Incident_%COMPUTERNAME%.blg -f bin -v mmddhhmm -cf Counter_Server.txt -si 00:00:10 -max 400 -u "domainName\Theuserid" * The difference between two counters is the frequency of running. The .txt file name need to be updated purely based on server where the counter is created.

Moving Items Between SharePoint Lists

I came across a scenario where I want to copy large amount of content from one sharepoint list to another.  I have done this by creating custom view on lists and copied contents using datasheet view. Please follow these steps to achieve this. Create one list view for both lists which should contain all the columns that you want to copy, also make sure that columns are not read only and they are not system generated columns like “Created by, Created”. Open both lists in different browsers Select newly created view for both list Open this view in datasheet view on both lists Select all the items in the source list and click copy Select the first cell of the available row in the destination list and click paste All your items should be copied successfully, now you can open the list in standard view and see that all data is copied. This works as long as you don't need to copy any of the system generated content like (created by filed). You need to use list view web parts or write custom code to achieve that.

Remove “View all site content” link in SharePoint 2007

11. November 2011 06:55 by Rashid Aziz in Sharepoint blogs  //  Tags: ,   //   Comments
Follow these steps to remove “View All Site Content” link form SharePoint 2007 site 1. Open your site master page in SharePoint designer 2. Go to the code and you will see the following <Sharepoint:SPSecurityTrimmedControl runat="server" PermissionsString="ViewFormPages"> <div> <SharePoint:SPLinkButton id="idNavLinkViewAll" runat="server" NavigateUrl="~site/_layouts/viewlsts.aspx" Text="<%$Resources:wss,quiklnch_allcontent%>" AccessKey="<%$Resources:wss,quiklnch_allcontent_AK%>"/> </div> </SharePoint:SPSecurityTrimmedControl> 3. You need to change the PermisisonString attribute value from “ViewFormPages” to “BrowseDirectories” 4. Now save the master page changes. 5. Go to the site, if you are authenticated user only then you will see the “view all site content” link,   it will be not visible for anonymous users. Note: The “BrowseDirectory” permissions are same for members and owner permission levels for SharePoint 2007. But it is not set for the “Limited access” permission levels.

Stay connected

SharePoint Links

Month List