Friday, May 17, 2013

Remember User Name and Password for SharePoint Sites

SYMPTOM: Whenever you browse to your SharePoint site, the little popup dialog box appears asking for your user name and password. If you enter your credentials, it lets you enter the site – it’s just annoying to have to do this again each time you go to your site. If you enter the wrong credentials, leave off the domain name, or type the wrong slash, the box will reappear a total of three times. If you never get it typed correctly, you will receive a generic black and white error message stating that ‘You are not authorized to view this page’ (see example below).



If you are experiencing this combination of symptoms, you probably need to adjust your Internet Explorer Security Settings. Even if you are unsure if your symptoms exactly match – this is a good place to start troubleshooting.



In a nutshell, the SharePoint site(s) must be added to either the Local Intranet zone or to the Trusted Sites zone on the client PC. Most users are familiar with the Trusted Sites zone, and may already use it for some things. However, the default settings in Internet Explorer don’t always allow automatic login in the Trusted Sites zone – especially in IE7. Explorer won’t allow a site to be in both zones, so I recommend a package of settings to make sure that authentication continues to work. The good news is if you have Domain Admin privileges you can control all of these settings centrally by using Active Directory and Group Policy – more on that later.


  1. Open IE on your computer, go to TOOLS > INTERNET OPTIONS, and then choose the Security tab.

  2. Click on the ‘Local Intranet’ zone icon, and then the Sites button.



  3. That will give you a second box, where you must click the Advanced button before entering and adding the site URL(s) – see pictures below.






    If you get an error when you click the Add button, you probably need to uncheck the ‘Require server verification (https:) for all sites in this zone’ box. Then try again.



    You should add each SharePoint portal / web application to this list, or use a domain wildcard entry (http://*.domain) if that is acceptable and relevant in your environment.



    If users are able to type a short NetBIOS style name (without any domain name) for any portal, the short names should also be added.



    If SSL encryption is sometimes used for any portal / web application, you should add the name(s) twice – once with the http: prefix and again with the https: prefix.

  4. Click the Close and OK, and you should find yourself back on the Security tab.

    (If you are looking for a quick fix, this alone might take care of the problem. Again though, I recommend following the rest of these steps to prevent things from ‘breaking’ again later.)

  5. We should now adjust the default security settings for each zone to allow for future user changes. The easiest way to do this is to set the ‘Local Intranet’ and the ‘Trusted Sites’ zones to the Low security level without Protected Mode, the ‘Restricted Sites’ to the High security level with Protected Mode, and the ‘Internet’ zone to the Medium-High level with Protected Mode (click each zone icon and then move the slide all the way down for each – see picture below).






    If you don’t see the slider at all, click the ‘Default level’ button. That should bring the slider back.



    Protected Mode is actually not directly related to the login process, but will simplify the use of some SharePoint integration features. If you uncheck ‘Protected Mode’ for the ‘Local Intranet’ zone, you will likely receive a dire-looking warning box when you click OK. You’ll have to use your own discretion as to whether this setting is appropriate for your end users.



    Some administrators or users may not want to apply the entire package of settings incorporated in the Low setting. You can make a more surgical strike by using the ‘Custom level…’ button. The relevant setting in the Custom box is at the very bottom of the list of options. It’s called ‘Automatic logon with current user name and password (see picture below).

  6. Click OK to exit the Internet Options box, and then close all Internet Explorer windows.

  7. Open a new Explorer window and browse to your SharePoint site. You should be logged in automatically using your Windows credentials.



    If you still receive the login prompt, you apparently have one of the other issues listed at the end of this post.


If you are a Domain Admin, you probably want to apply these settings to all of your users. That way they can quit calling you about it and move on to other problems… This can be done by using Active Directory Group Policies.


  1. Login to your domain controller using an account that has domain admin privileges, and perform the steps listed above to create the appropriate package of settings. The following steps allow you to import that package of settings into Group Policy.

  2. Go to CONTROL PANEL > ADD OR REMOVE PROGRAMS > ADD/REMOVE WINDOWS COMPONENTS > INTERNET EXPLORER ENHANCED SECURITY CONFIGURATION.



  3. Uncheck the Internet Explorer Enhanced Security Configuration option, and click Next until the wizard completes.This option can be re-enabled after step 10??, if you want or if your corporate policy requires it.

  4. Go to START > ALL PROGRAMS > ADMINISTRATIVE TOOLS > ACTIVE DIRECTORY USERS AND COMPUTERS.

  5. Right-click your domain name (or whichever Organizational Unit contains the users to which you wish to apply this fix), and choose Properties.

  6. Click the ‘Group Policy’ tab, and then the New button. Type in a descriptive name for the New Group Policy Object that appears.



  7. Make sure that your new policy is selected and click the Edit button.

  8. Drill down to USER CONFIGURATION > WINDOWS COMPONENTS > INTERNET EXPLORER MAINTENANCE > SECURITY > SECURITY ZONES AND CONTENT RATINGS.

  9. When you click the button labeled ‘Import the current security zones and privacy settings’, you will likely receive a warning about ‘Internet Explorer Enhanced Security Configuration’.






    This is why we disabled the enhanced configuration in step 3, so that this policy would apply to normal workstations. Click Continue.

  10. Close all open windows.



    You can now go back to the ‘Add/Remove Windows Components’ box and re-enable the Internet Explorer Enhanced Security Configuration if you wish.



    The changes will take time to replicate through your entire network or enterprise, depending on your particular Active Directory replication topology. In a single-site network, you may see the changes take effect within 15 to 90 minutes. In multi-site networks, it may take a day or more.

SharePoint 2013 and Hadoop

Excellent article by SharePoint team on HDInsight and SharePoint 2013.

http://blogs.office.com/b/sharepoint/archive/2013/05/16/use-event-click-parsing-to-increase-e-commerce-site-revenue.aspx

Have a great weekend!!


Thursday, June 23, 2011

Enable Developer Dashboard using Powershell

$spDevDash = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;
$spDevDash .DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::OnDemand;
$spDevDash .RequiredPermissions = ‘EmptyMask’;
$spDevDash .TraceEnabled = $true;
$spDevDash .Update();


http://www.sharepointinnovations.com

Fantastic 40 Templates on SharePoint 2010

The "Fantastic 40" templates were created for WSS 3.0.

Microsoft has no plans to upgrade them for SPF 2010, however TechSolutions has migrated many of the templates and made them available here http://www.techsolutions.net/Blog/tabid/65/EntryId/18/Fab-40-for-Sharepoint-Foundation.aspx

Thursday, June 16, 2011

Custom MySite Host in SP 2010

If you use the SP 2010 wizard to install SharePoint 2010, you end up getting a site with the name of the server and "my" site collection, all in a single database. The best practice is to delete this web app, which means you will delete the mysite site collection as well.

Steps:

1) Create a new web app - http://sharepoint.mycompany.com
2) Create Site Collection under the web app in step 1
3) Create dedicated MySite Web App - http://mysite.yourcompany.com
4) Create Site Collection My Site Host template under enterprise tab under web app in step 3

Please see more info here -- http://sharepointgeorge.com/2010/configuring-my-site-sharepoint-2010

Enjoy!!!

http://www.sharepointinnovations.com

Wednesday, May 25, 2011

Create a content type search refinement panel in SharePoint 2010

Out of the box there is a refinement panel for ‘Result Type’ however this is different to the content type, e.g. Word as opposed to Proposal. So the challenge was to create a new refinement panel to replace the Result Type refinement panel. Note, it was to replace in my case but there’s no reason why it can’t be in addition to:

Great article on getting this done:

http://www.glynblogs.com/2011/01/create-a-content-type-search-refinement-panel-in-sharepoint-2010.html


http://www.sharepointinnovations.com

Enjoy!

Monday, May 16, 2011

Microsoft SharePoint 2010 Administration Toolkit v2.0

The Microsoft® SharePoint® 2010 Administration Toolkit contains functionality to help administer and manage Microsoft® SharePoint® Foundation 2010 and Microsoft® SharePoint® Server 2010.

SharePoint Diagnostics Studio is awesome!

Download the toolkit from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=718447d8-0814-427a-81c3-c9c3d84c456e&displaylang=en

P.S. Try it on your dev/test farm before moving to production...

Enjoy!

http://www.sharepointinnovations.com

SharePoint 2010 Service Pack 1 - Arriving in June 2011

Service Pack 1 in late June 2011 ..  Site Recycle Bin, StorMan is back :-)

Enjoy SP 2010 SP1

http://www.sharepointinnovations.com

SharePoint 2010 Reporting Services Integration Authentication Fix

Server 1 (WFE), Server 2 (APP & Central Admin), Server 3 (DB w/ Report Server) - NTLM install
 
In SharePoint Central Administration -- General Application Setting - Reporting Services Integration

Selected the RS URL and "Trusted Account", domain user name & password (Server 3, local admin domain account for RS access)

Everything will work fine including activation of the features on existing site collections BUT when you click on Set Server Defaults, you will end up getting The request failed with HTTP status 401: Unauthorized

Fix

KB article has the answer: http://support.microsoft.com/kb/871179/en-us

On Server 2 (App & Central Admin)

To work around this behavior if you have multiple application pools that run under different domain user accounts, you must force IIS to use NTLM as your authentication mechanism if you want to use Integrated Windows authentication only. To do this, follow these steps on the server that is running IIS:
  1. Start a command prompt.
  2. Locate and then change to the directory that contains the Adsutil.vbs file. By default, this directory is C:\Inetpub\Adminscripts.
  3. Type the following command, and then press ENTER:
    cscript adsutil.vbs set w3svc/NTAuthenticationProviders "NTLM"
  4. To verify that the NtAuthenticationProviders metabase property is set to NTLM, type the following command, and then press ENTER:
    cscript adsutil.vbs get w3svc/NTAuthenticationProviders
    The following text should be returned:
    NTAuthenticationProviders       : (STRING) "NTLM"
Happy Monday!

http://www.sharepointinnovations.com

Thursday, May 12, 2011

SharePoint Taxonomy Governance Policies - Information Architecture

How to create a taxonomy governance policy:
  1. Identify all of the data collected within your organization’s portal. (You should already have the list from previous exercises).
  2. Next, you will “structure” the data, organizing it by the following categories:
    1. Structured Data – Data that is organized, either hierarchically or in an existing taxonomy of some sort. This is data such as databases, Excel spreadsheets, Access databases, or even SharePoint lists that are organized and searchable by data types within the content (i.e. Name, Address, Phone, etc).
    2. Unstructured Data – This is ad-hoc data contributed freely by end users. Examples of unstructured data include emails, Word documents, PowerPoint presentations, audio/video files, images, etc. In other words, things that are not searchable (unless you added metadata or they get “crawled”, such as by an Index Server).
    3. Semi-structured data – This is unstructured data that has been organized and/or has metadata attached. Examples of semi-structured data include SharePoint lists, Document libraries, Project and Team Sites, etc.
  3. Once organized, determine who views the content vs. who contributes the content. ­ For example(s):
    1. MySites – Everyone can view them and everyone can contribute to their own.
    2. News and Announcements – Everyone can view them, but only Admins or Division heads can contribute.
    3. Division Portals – Some people can view them, and some people can contribute to them.
    4. Team or Project Sites – Select people can view them and contribute equally.
  4. Lastly, you will create a Policy, stating WHO owns and manages this content. The intent here is to hold people accountable (at various levels) for keeping the data properly organized throughout the Portal’s lifecycle.

Topologies for SharePoint Server 2010

Here is a really PDF from MS on SP 2010 topologies and service application assignments.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=FD686CBB-8401-4F25-B65E-3CE7AA7DBEAB&displayLang=en

Happy Thursday!

http://www.sharepointinnovations.com

Saturday, May 7, 2011

SharePoint 2010 and SQL Server 2011 - Reporting Services

Project Crescent is designed to be highly interactive and is targeted at all reporting users from CEOs to power users. Crescent provides drag and drop ad-hoc reporting functionality and was built entirely on Silverlight.

One of the interesting features is called Storyboarding. This features allows users to embed charts and graphs in Microsoft PowerPoint. The cool thing is the live link between PowerPoint and the underlying data. It does appear that Crescent will require SharePoint 2010 to run, which might be too complex for small IT organizations. Crescent will leverage Microsoft PowerPivot, which was released with SQL Server 2008.

Project Crescent is expected in SQL Server 2011 (Denali) CTP2, which could be out in April. In the meantime, check out the YouTube video Introducing Project Crescent, which shows us a few of the visualizations.

Have a great weekend!

http://www.sharepointinnovations.com

Friday, May 6, 2011

SharePoint 2010 and Silverlight 4 Book

Great book! If you are an RIA freak, get this book -- Microsoft Silverlight 4 and SharePoint 2010 Integration

http://www.amazon.com/Microsoft-Silverlight-SharePoint-2010-Integration/dp/184968006X

Happy Friday!!!!

http://www.sharepointinnovations.com

SharePoint 2010 Sandboxed Solutions - Resource Quotas

Points are calculated based on various metrics, and these metrics are designed to monitor the resource usage of the server to accurately reflect the true health of the server. SharePoint contains 14 metrics that contribute to the quota points.
  1. AbnormalProcessTerminationCount
  2. CPUExecutionTime
  3. CriticalExceptionCount
  4. InvocationCount
  5. PercentProcessorTime
  6. ProcessCPUCycles
  7. ProcessHandleCount
  8. ProcessIOBytes
  9. ProcessThreadCount
  10. ProcessVirtualBytes
  11. SharePointDatabaseQueryCount
  12. SharePointDatabaseQueryTime
  13. UnhandledExceptionCount
  14. UnresponsiveprocessCount
Each metric, called a ResourceMeasure, contains a ResourcesPerPoint property.

The ResourcesPerPoint value is divided by the resources consumed to calculate the points used for that category.

For example, AbnormalProcessTerminationCount has a ResourcesPerPoint value of 1. Every time a sandboxed solution terminates abnormally, 1 point is added. If you want to increase the penalty for a sandboxed solution that terminates, you can set ResourcesPerPoint to another value, such as 2. You can use 0 if you are not concerned about this metric. Other ResourceMeasures might not have a one-to-one correspondence with an event. The CPUExecutionTime metric prevents a sandboxed solution from consuming too many CPU cycles. The default ResourcesPerPoint value is 3,600 for CPUExecutionTime.
Another value is AbsoluteLimit, which is incremented each time a solution gets a point.

If a solution exceeds the AbsoluteLimit value, it is terminated even if the daily usage limit has not been reached. Exceeding the value of AbsoluteLimit affects only the single solution, unlike the daily usage limit. These two levels of quotas, daily limit and absolute limit, work together to protect the health of the farm. I strongly recommend that you not modify ResourceMeasures, but as a developer or an administrator, you should understand exactly how these mechanisms work.

Although SharePoint does not provide an administration page for adjusting the quota metrics, you can see and change the values using the SharePoint object model or Windows PowerShell

SharePoint 2010 Sandboxed Solutions - MS Article

SharePoint 2010 Sandboxed Solutions

SharePoint 2010 introduces a new way of adding custom dev to SharePoint: Sandbox solutions, also called User Solutions. Solution deployment we are all used to in SharePoint 2007 still exists in SP2010 but those solutions will be called Farm solutions. Sandbox solutions are scoped to site collection and each site collection has its own gallery of these solutions which can be found in the site settings page.

Visual Studio 2010 gives visual tools to build the deployment package so long gone are the days of editing DDF and manifest files. After building the WSP you can upload it to the solution gallery just like you would upload a master page to its gallery. Select the solution you uploaded and the context sensitive ribbon gives you the option to activate the solution.

Sandbox solutions have their own advantages but also some limitations. Best part is you don’t have to deploy the solution from the server which means no server reset. You can do as many deployments as you want – every developer’s dream :) And, you can test your customizations in a test site collection on the production servers before applying it to the real sites.

Coming to the limitations, not every type of custom functionality can be packaged into a sandbox solution. From what I’ve seen so far any component that needs files in 14 hive cannot be part of sandbox solution, for e.g.: Visual Web Part

Happy Friday!

http://www.sharepointinnovations.com

Thursday, May 5, 2011

SharePoint 2010 Logging Database

One of the features of SharePoint 2010 that is getting me really excited is the logging database. The purpose of this database (which is named WSS_Logging [One per Farm] by default) is to aggregate logging information from the farm into one central location.

The logging database by default contains the following information from all servers within the farm and it is fully supported to query this database directly.

· ULS Logs

· Event Logs

· Selected Performance Monitor Counters:

o % Processor Time

o Memory Available Megabytes

o Avg. Disk Queue Length

o Process Private Bytes (OWSTIMER and all instances of w3wp)

· Blocking SQL Queries

· SQL DMV Queries

· Feature Usage

· A host of information on search crawling and querying

· Inventory of all site collections

· Timer job usage
The logging database by default contains the following information from all servers within the farm and it is fully supported to query this database directly.
http://www.sharepointinnovations.com

Thursday, April 28, 2011

SharePoint 2010 FBA Pack Released

SharePoint 2010 FBA Pack on CodePlex:
http://sharepoint2010fba.codeplex.com/

The FBA Pack is a collection of web parts and tools for managing forms based authentication in SharePoint 2010. It is a port of the SharePoint 2007 CKS Forms Based Authentication Solution to SharePoint 2010. It has been changed extensively to work with SharePoint 2010′s claims based authentication and has been restructured to use Visual Studio 2010′s new SharePoint project type.

SharePoint 2010 can be configured out of the box to authenticate against an ASP.NET Membership database, but strangely it does not include any tools for managing membership users and roles, or any web parts to allow new users to register or to change/reset their password. That’s where the FBA Pack comes in.

http://www.sharepointinnovations.com

Thursday, April 21, 2011

SharePoint 2010 Power User Course - Portland, OR

SharePoint Innovations is offering SharePoint 2010 Power User course next week from Portland, OR and Live Online.

Register Online at http://www.sharepointinnovations.com/sharepoint-training/schedule.aspx