All About SharePoint SharePoint 2010 and MOSS 2007 Resource Website

13Jul/110

What’s new in SharePoint 2010 SP1

What's new in SharePoint 2010 SP1

With all the latest buzz on the release of SharePoint 2010 Service Pack1, here is what SharePoint 2010 SP1 adds:

Site Recycle Bin: With this new feature, administrators can restore site collections and/or sites that have been accidentally deleted by their owners. How often does this happen? Hopefully not too often. But when it does, having recoverable copies without getting out backups is a plus. We've had the Recycle Bin feature in SharePoint for lists, libraries, and documents for while now; this is a nice additional safety net.

Broader browser support: SharePoint 2010 SP1 adds support for IE9 in Internet Explorer 8 Standards Mode, as well as for Google Chrome.

Shallow Copy: This new feature allows you to move site collections to new content databases without having to move all the Remote Blob storage content. Thus, only the ownership information is moved, without having to copy the unstructured data in the file store. The Move-SPSite PowerShell cmdlet has been enhanced to allow this feature

StorMan.aspx (Storage Space Allocation page: StorMan.aspx has been reintroduced in SharePoint 2010 SP1. It was removed from the original version of SharePoint 2010. Now that it is back, it adds the ability to display better information to users regarding their quota information. That makes it easier for users to clean up their sites by deleting content they may not need.

Support for SQL Server "Denali" (aka SQL Server 2011) ): Given that SharePoint is heavily integrated with SQL, it stands to reason that new features in the forthcoming Denali version of SQL Server will only make SharePoint 2010 better.

Cascading filters in PerformancePoint Services: Filters values can now be passed from one filter to the next.

7Jul/110

Improvements in SharePoint 2010 Service Pack1

As some of you already started testing the release of SharePoint 2010 Service pack1 and there is already enough fuss about this Service pack 1. Personally I feel that the SP1 release and the June CU for SharePoint 2010 releases added more fuel to the problem.

I have stressed this enough to install the Service pack 1 and then install the June CU.

Please see the link below for more detailed info on the improvements and various blogs posts by SharePoint MVP's.

http://blogs.c5insight.com/Home/tabid/40/entryid/198/Improvements-in-SharePoint-2010-Service-Pack-1.aspx

7Jul/110

How to Pass Querystring data into an InfoPath Form

Recently I came across this blog when trying to test some new functionality in  Infopath and SharePoint 2010.

How to easily send a value from the browser’s query string into an InfoPath form. Hopefully this will help somoeone. Please see the link below.

 http://blogs.msdn.com/b/infopath/archive/2010/06/03/how-to-pass-querystring-data-into-an-infopath-form.aspx

3Mar/111

Accessing the term store as a manager or contributor

Accessing the term store as a manager or contributor

Today 03/03, we ran into a situation where one of the users who manage the SharePoint 2010 Site was unable to access the term store management links.

I've touched on the term store a few times in posts this year. But as ever the best way to learn a new tool is to get a bit of practical experience. So I came across this little nugget this week when onsite with a client. Firstly a bit of background on the term store.
The building blocks of the term store are:

  • Metadata application: Top level container of our term store. Contains groups
  • Groups: Term sets are collected together in groups
  • Term set: A hierarchical group of related terms
  • Term: The basic building block of the term store. A metadata word

The term store can be managed by the following three groups of people:

  • Term store administrator: Full control over the term store, and able to assign other people roles.
  • Group managers: This role allows a user to manage a particular group of term sets
  • Contributers: This role allows users to manage terms sets in a particular group, but they are not able to create additional contributers.

Term sets also have 'owner' and 'stakeholders' properties but these aren't actually used for anything.

Anyway the reason for this was post was to talk about how the roles described above access the term store. If the user has sufficient permissions to see 'site settings in 'site actions' then there isn't really an issue. They can navigate to site settings, and into the term store. However if the user cannot see the 'site actions' button their is no easy way to navigate to the term store at all. In fact it seems the only way is to link directly to it (and make sure you link to the term stored access via 'site setting's not central administration) and either distribute the link or post it somewhere. Whilst we have always had different permissions models outside of the standard user access model, this feels a bit different and all a bit unfinished. Have a look and see what you think. Comments below please.

9Feb/111

Catch 22 for Approval Workflow in SharePoint Designer

Today 02/09  I began blogging on this, and found someone else's blogpost from Dec 2010 who also blogged on this exact topic.  Though I never saw his blog post prior to writing this, credit to Lars Nielson.

I ran into an interesting dilemma while working on my most recent project.  The project involved a number of document libraries that required content approval as well as versioning.

The scope of work greatly limited the amount of customizations that could be made to SharePoint (i.e. building workflows in Visual Studio).

This introduced an interesting problem based on our initial game plan.  The workflow is basically a document goes through a change process and committee approvals before it is published.  End Users cannot see changes until an approved document is published.

The change process was the complicated piece to this because the organization had a number of variables within the process, so the only solution was to require each step in the workflow to be manually kicked off.

When I made it to the approval stage, we initially had content approval on in the libraries.  And here is where the catch 22 comes in, trying to set content approval status to Approved in a document library that requires a document to be checked out and content approval is on.

To set the content approval status from Designer, ok easy enough, there is an action for that....uh oh, the document must first be checked out.  ok, check out document, set approval status....uh oh, I get an error that says content approval status cannot be set while a document is checked out.

Catch 22.  Basically to set content approval status in designer, the document must be checked out, but content approval status cannot be changed while a document is checked out.

Possible work-around - We did not go this route, we basically turned off content approval, and used a workflow to notify approvals, and once approval was granted, a user would publish a major version of the document.  This was acceptable for this engagement.

I was going to explain the workaround here, but I ran across a blog post while getting my info together of someone who already documented it.  So in the spirit of giving credit where credit is due, Lars gets credit for this solution.  Lars Nielson blogged on this exact topic in late 2010.    http://discoverlars.wordpress.com/2010/12/28/update-the-approval-status-in-a-sharepoint-designer-workflow/

The bottom line in this is that for highly complex workflows, you really need Visual Studio.

9Feb/111

How to Install a software update for SharePoint Foundation 2010

Recently we encountered some issues with the SharePoint updates. Even though the previous update procedures may be quite successful you may somehow find new or additional issues after the updates. Please see the below link from Technet explains the procedures for various SharePoint Server 2010 updates.

Click Here to see the Procedure for Updates

9Feb/111

SharePoint 2010 boundaries, Thresholds and Supported limits

SharePoint 2010 boundaries, Thresholds and Supported limits

Many would be considering SharePoint 2010 for their environment and questions will be asked to SharePoint Admins and Architects on the product.
Here is some handy information from Microsoft on the limitations (boundaries) of SharePoint 2010.

Before we dive into it, letz define what are the limit types:

  • Boundaries: Static limits that cannot be exceeded by design
  • Thresholds: Configurable limits that can be exceeded to accommodate specific requirements
  • Supported limits: Configurable limits that have been set by default to a tested value.

4Jan/110

Event ID 3351-Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

Today 01/04/2011, as part of my monthly checks, I noticed a whole bunch of 3351 errors in the event log on the SharePoint front end web server.

Event Type: Error

Event Source: Windows SharePoint Services 3

Event Category: Database

Event ID: 3351

Date: 1/4/2011

Time: 12:44:45 AM

User: N/A

Computer: MOSSSERVER

Description:

SQL database login failed. Additional error information from SQL Server is included below.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Resolution: First I started to check the application pool account of the portal site  and found they were all set as defined. After a thorough investigation found that the Windows SharePoint Services VSS Writer account is running as local system account. Changed the account to the AD Farm Account and found that the issue is resolved.

19Nov/102

Reminder emails a day before for a Calendar Event

Today 11/19/2010 Friday, one of the Users requested that if they can get alerts or notifications for the upcoming calendar events and that they would like to get the notifications the day before the event.

To accomplish the above:

Add a custom field to the calendar called "Alert - 1 day".  Make it a calculated field with the calculation [StartTime]-1.  Make sure it is a date type.  I also specified date and time so the alert goes out exactly one day before, to the minute.
Then also add a custom field to the calendar called "Reminder Recipients".  Make it a people picker control and choose to show Email addresses and probably allow multiple selections too.

Next, open your site in SharePoint designer and create a workflow (New > Workflow) for the calendar. Set the workflow to automatically start when the event is created/changed.  I also created a workflow variable called "Recipients" of type string.   Then my workflow went like this:

If Alert - 1 day is greater than Today
Pause until Calendar:Alert - 1 day
then Set Variable: Recipients to Calendar:Reminder Recipients
then Email Variable: Recipients

Please see the screenshots below

1Nov/105

Event ID 107:Report Server Windows Service cannot connect to the Report Server Database

Today 11/01/2010, when I was doing the routine event log checks for errors as a scheduled task on the first of every month. One of My SQL server had a whole bunch of Report Server Windows errors with event ID 107.

Please see the error below:

Report Server

Report Server

Event Type:        Error

Event Source:    Report Server Windows Service (MSSQLSERVER)

Event Category:                Management

Event ID:              107

Date:                     11/1/2010

Time:                     9:12:49 AM

User:                     N/A

Computer:          MOSSSQLSERVER

Description:

Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

Resolution: Go to Services. msc and  Make sure all the services for SQL Server  Database engine and Reporting Services were in the running state. Then Open the Report Services Configuration Wizard, Connect to the specified SQL Server Database Server and then I found that the connection to the Report Server Database was set to some other  database. Modified the settings doe the Database setup and connected the Report Server Database and save the settings.

8Oct/100

SharePoint Security Update

Microsoft announced a security advisory that affects many SharePoint deployments.

Recently Microsoft announced Security Advisory 2416728 (Vulnerability in ASP.NET) and SharePoint. The vulnerability affects the following SharePoint versions

  • SharePoint 2010
  • SharePoint Foundation 2010
  • Microsoft Office SharePoint Server 2007
  • Windows SharePoint Services 3.0
  • Windows SharePoint Services 2.0

Microsoft has posted an out-of-band security update that should be applied ASAP on the SharePoint web front-end servers for affected deployments. The SharePoint team blog is the best source for more information:
SharePoint Team Blog

2Aug/100

SharePoint Search Errors-Event ID-3083

 

 

Today when I tried to install the .NET Framework 3.5 security updates, I got the following errors in the event log:

 

Event Type: Warning

Event Source: Office Server Search

Event Category: Gatherer

Event ID: 2436

Date: 8/2/2010

Time: 1:59:12 AM

User: N/A

Computer: MOSSSERVER

Description:

The start address http://MOSSSERVER cannot be crawled.

 

Context: Application 'SharedServices1', Catalog 'Portal_Content'

 

Details:

 Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (0x80041205)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

When you start to analyse these errors  you will find a Knowledge base article on the Microsoft homepageKB887993. Within this article they describe authentication issues to access web pages.

Use the second method to apply following registry key

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa]
“DisableLoopbackCheck”=dword:00000001

 

When you applied above registry value you get a second error within your event log:

2Aug/100

Best Practices in Developing Requirements for SharePoint Projects

This is one of my favorites blog posts from SharePoint Project Management Guru-Dux Raymond Sy.

I had the great opportunity to facilitate "Best Practices in Developing Requirements for SharePoint Projects" webcast for O'Reilly Media last July 28, 2010.

You can download the PPT presentation at: http://bit.ly/d1xbLN

Click the image below to watch the recorded presentation:

As promised, you can download the templates I showed at: http://www.meetdux.com/dl/req4sp.zip

In addition, I have compiled a list of valuable SharePoint resources related to the webcast:
- PM Resources for SharePoint 2010 Projects
- How SharePoint Can Deliver Project Transparency
- 5 Reasons Why SharePoint Ignorance is not Bliss
- Are you doing what it takes to Success at Implementing SharePoint?
SharePoint Worst Practices: 5 Common Mistakes to Avoid

Lastly, if you want to join this session live, make sure you attend Best Practices Conference in DC from Aug 24-27, 2010

Page 1 of 3123