Where is the RSS Viewer web part in SP 2010?

Like everything in SharePoint why make things simple if you can make it hard :)

Turns out that if you want the RSS Viewer webpart, you need to activate the “SharePoint Server Standard Site Collection features” feature in your site collection first.

Took me about 10 minutes of snooping around in the Web part gallery and trying ta add a new one, before I figured that one out.

Thanks to Craig Lussier for answering this exact question on the Technet Forum.

Posted in SharePoint 2010, Tips | Leave a comment

Fixing the Usage and Health Data Collection Service Application Proxy (By Tristan Watkins)

Unfortunately in every farm that I have provisioned so far using powershell I keep running into this issue that the Usage and Health Data Collection Service Application Proxy is set to Stopped.

The fix that Tristan Watkins describes on his blog here fixes just that.

Commands:

#Run Get-SPServiceApplicationProxy to enumerate the IDs of all the Service Application Proxies in your farm.
DisplayName          TypeName             Id
-----------          --------             --
State Service App... State Service Proxy  e51696f1-3523-4e20-9b75-578485024b37
Managed Metadata ... Managed Metadata ... 830bafcf-f0d3-4254-91e4-8cfe11840e27
Search Service Ap... Search Service Ap... a988d821-8247-4294-ba11-961b22e51f8b
Application Disco... Application Disco... af617d69-7332-49f3-a61c-0eef3f7470cf
Excel Services Ap... Excel Services Ap... b6c5b951-7b4d-4837-83f3-c916c1ef6c7d
WSS_UsageApplication Usage and Health ... 83301455-c854-4596-af5c-0bc6ee963b6d

#Copy the ID for the WSS_UsageApplication.
$UP = Get-SPServiceApplicationProxy | where {$_.ID -eq "PASTE ID HERE"}
$UP.Provision()

If you refresh the Manage Service Application page the proxy should be started now.

Posted in powershell, SharePoint 2010 | Leave a comment

Provision SharePoint 2010 Search with custom database names

I’m more of a mitliple scripts guy for configuring my SharePoint 2010 farms than a 1 humongous script guy that does everything. I prefer to use one script for installing my binaries and creating/joining the farm and then several scripts for configuring specific service applications. I find it easier for troubleshooting.

Anyway, here is the script I created based on the AutoSPInstaller for configuring the Search Service Application using custom database names:


$SSADB = "SharePoint_ServiceDB_SearchAdmin"
$SSAName = "Search Service Application"
$SVCAcct = "CONTOSO\the_search_service_account"
$SSI = get-spenterprisesearchserviceinstance -local

# 1.Start Services search services for SSI
Start-SPEnterpriseSearchServiceInstance -Identity $SSI

# 2.Create an Application Pool.
$AppPool = new-SPServiceApplicationPool -name $SSAName"-AppPool" -account $SVCAcct

# 3.Create the SearchApplication and set it to a variable
$SearchApp = New-SPEnterpriseSearchServiceApplication -Name $SSAName -applicationpool $AppPool -databasename $SSADB

#4 Create search service application proxy
$SSAProxy = new-spenterprisesearchserviceapplicationproxy -name $SSAName"ApplicationProxy" -Uri $SearchApp.Uri.AbsoluteURI

# 5.Provision Search Admin Component.
set-SPenterprisesearchadministrationcomponent -searchapplication $SearchApp -searchserviceinstance $SSI

This will just create your required databases. From this point on you can configure the required crawl / query topologies using Central Admin.

Posted in powershell, SharePoint 2010 | Leave a comment

Rename SharePoint 2010 Central Admin database

I had a post on this for SharePoint 2007 and needed to do the same thing for SharePoint 2010, but wanted to do this the powershell way instead of the stsadm way I used for MOSS. Not sure if that would even work…

turns out I didn’t need to reinvent the weel as Todd Klindt has already blogged about this here

The trick to all this is that for moving all site collections in a content database you would execute Get-SPSite with -contentdatabase parameter to get all the site collections for that content database and then pipe that to a Move-SpSite command. With the Central Admin content database the only way to get the site collections is to specify the GUID of the contentdatabase instead of the database name

In short, here are the commands:


#Create a new Content Database
New-SPContentDatabase -Name SharePoint_CentralAdmin -WebApplication http://sp2010:1000
#Get the Database GUIDs
get-spcontentdatabase -webapplication http://sp2010:1000
Id: d3d04cb1-b919-4262-b2d7-46733ef2c5df
Name : SharePoint_AdminContent_81476219-04f5-46b8-807f-31aa4afb4056
WebApplication : SPAdministrationWebApplication
Server : SP2010-DB
CurrentSiteCount : 2

Id : d8647aed-ef42-4052-814b-670b36fb8c1e
Name : SharePoint_CentralAdmin
WebApplication : SPAdministrationWebApplication
Server : SP2010-DB
CurrentSiteCount : 0

#Move the site collections
Get-SPSite -ContentDatabase d3d04cb1-b919-4262-b2d7-46733ef2c5df | Move-SPSite -DestinationDatabase d8647aed-ef42-4052-814b-670b36fb8c1e

Now do an IISRESET and check that the Central Admin site renders properly. If it does you can safely remove the content database with the GUID in it. Since I check the Central Admin site, I just delete the content database with the GUID from within the Central Admin Site

Posted in powershell, SharePoint 2010, Tips | Leave a comment

Updating User Profile pictures with powershell on SP2010

I finally had the chance to play around with user profiles. My customer asked me if it was possible to have the pictures of all employees show up in their respective user profiles in SharePoint and this without uploading the pictures themselves because they already had a dedicated website with all the pictures available. So the only thing to try to figure out was if it was possible to specify a link to the picture on a different website.

The customer was able to give me a CSV file with about 20K lines in it with 2 fields: Username + url of the picture. Worth mentionning was that the url of the user picture was not saved in any Active Directory property of the user object, sow e could not get it from there using the User Profile import process.

As it turns out the User profile actually has a property called PictureUrl which is completed by SharePoint when you upload your profile picture. So the task at hand was to write a script that could read the CSV file and update the user profiles. I started out with the script of Phil Childs and ended up with the following script:


$CSVFile = "C:\Scripts\pictureurls.csv"
$mySiteUrl = "http://people.contoso.com"

#Connect to the User Profile Manager
$site = Get-SPSite $mySiteUrl
$context = Get-SPServiceContext $site
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)

#Read CSV file and process each line
$csv = import-csv -path $CSVFile
foreach ($line in $csv)
{
$up = $profileManager.GetUserProfile($line.UserName)
if ($up)
{
$up["PictureURL"].Value = $line.PictureUrl
$up.Commit()
write-host $up.DisplayName," --> ", $line.PictureUrl
}
if (!$up) {
write-host $line.UserName, " --> no profile found"
}
}

Now, I’m not a powershell expert (yet) so this script can probably be optimized or improved.

For my customer, we are planning to have this script adapted to check if the pictureUrl field has already been populated and only add the value when it is not and have it run on a regular basis. Ultimately my customer is looking into saving this picture url in Active Directory afterwhich we can play around with FIM to have it popluate the user profiles that way.

Posted in powershell, SharePoint 2010 | 2 Comments

Change Locale of Site Variation Label in MOSS

Since some time, my customer had a nasty issue for which I did not see a solution at first. My customer is running its Intranet for years now on MOSS and uses a customized Publishing Portal with Site Variations in 3 languages, English, Dutch and French. The only problem with these Site variations is that the source Variation Label was created with the wrong Locale setting. The variation label was created with a name EN, language English (United States) , but with locale Dutch (Belgium) instead of English (United states).

Now when the hierachy was created, the subsite EN was created with the wrong locale. No problem there because you can change the locale of that particular subsite in the Site Settings – Regional Settings.

The problem my customer was facing is that clients targeting the root site collection and thus the Variation root site, where redirected to the wrong subsite if their browser had the locale Dutch (Belgium) defined. These client all ended up on the EN subsite instead of the Variation NL that was created with locale Dutch (Belgium).

The solution for this problem is to change the Locale in the Variation Labels in the root site. Unfortunately you cannot modify this value once the Variation Label is created (the field is greyed out). A possible solution would be to delete the Variation Label and recreate it. Because of the fact that this was the corporate intranet with lots of content on it, I did not feel very comfortable deleting the Variation Label, because this means you would have to delete the subsite as well before being able to recreate the Variation Label after which yould have to restore the subsite’s contents, etc. Furthermore the Variations system in MOSS is already very fragile and this would certainly break some other things.

Now after searching for a while and snooping around in the content database, I found out that these labels are stored in a hidden list in the Root site called, you’ll never guess, … “Variation Labels”. Now my trick for accessing this a hidden list by just typing the URL like http://intra.contoso.com/Lists/Variation Labels/AllItems.aspx did not work.

Powershell to the rescue!

I was able to access the list and change the locale value for the specific Variation Label with the following set of powershell commands:

#First Load SharePoint
[void][System.reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")

#Connect to SPSite object
$site = New-Object Microsoft.SharePoint.SPSite("http://intra.contoso.com/")

#Connect to root SPWeb
$web = $site.AllWebs |where -FilterScript { $_.Url -eq "http://intra.contoso.com"}

#Connect to Variation Labels list
$list = $web.Lists |where -FilterScript { $_.Title -eq "Variation Labels"}

#Get the List item for the Variation Label
$listitem = $list.Items |where -FilterScript { $_.Title -eq "EN"}

#Check the Value
$listitem["Locale"]

#Modify the value to English (United States)
$listitem["Locale"] = 1033
$listitem.Update()

#Dispose of objects
$listitem.Dispose()
$list.Dispose()
$web.Dispose()
$site.Dispose()

Now if you ever need to chaneg the locale value, then this script will help you out. The only thing you need to find out is the value for your specific language. What I did to find out the specific value was to create a new Variation Label on my test environment with teh locale I wanted and fetched that value with the exact same commands.

Posted in MOSS, SharePoint, Support, Uncategorized | Leave a comment

Out goes Community Server, in comes WordPress!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! (in my case continue blogging )

This is the first post you get to see once you get WordPress going. I thought I’d leave it up here. I got more than enough of the spam mails getting in through my blog and not finding any way to implement a captcha thingy into the instance of Community Server I was running that I decided to give it a go to another blogging tool. Now for me the most important thing was how would I keep my original posts. Luckily I still found an export module to BlogML for Community Server 2008.5, which did the trick. Armed with that knowledge I gave a go at WordPress.

Hope you can live with it as much as I can ;)

I am still trying to figure out how to implement the exported permalinks, so if you got here through a Google/Bing or whatever search and didn’t find the original post you were looking for, just use the search function on this site and you will probably find that article you were looking for after all

For those of you wondering: I am running WordPress on an Apache webserver. Now how cool is that for a SharePoint consultant!

Posted in Uncategorized | Leave a comment

SharePoint 2010 gradual upgrade approach using ISA server

Now first a little remark about this post: This post will not handle the actual upgrade from MOSS 2007 to SP2010. It will only provide a possible method to use when you are considering to gradually upgrade specific web applications, meaning that you actually want to have the same web application with the same hostheader available on MOSS 2007 and SP2010 and redirect your users to the correct farm depending on the site collection they target.

I have been doing some brainstorming with regards to an upcoming SharePoint 2007 to SharePoint 2010 migration for one of my customers. I have had my fair deal of upgrading from SharePoint 2003 to MOSS 2007 using the gradual upgrade approach that was built-in into MOSS 2007.  

In that scenario you were able to use the URL redirection feature of MOSS. In short you could alter your DNS settings for your web application to point to your MOSS farm and then MOSS would determine if the specific site collection the user was targeting had already been upgraded and if not MOSS would redirect the user to the old SharePoint 2003 site using an alternative URL. This scenario causes a lot of confusion with your users that are accessing sites that have not been upgraded because they would start seeing your alternative url. For example: your original url was teamsites.contoso.com. Once you activated the gradual upgrade of a that specific web application, all your users would start targeting the MOSS farm and then be redirected to the alternative url which could be something like old-teamsites.contoso.com or teamsites.contoso.com:8080

In SharePoint 2010 there is still a way to use this alterantive url redirection as described in the “Using AAM URL redirection as part of the upgrade process (SharePoint Server 2010) white paper”

Now my customer asked me for a way to do it without an alternative url and simply use the same url and depending on the targeted site collection be redirected to either MOSS 2007 or SP2010. This got me thinking that it would certainly not be feasible using only DNS. The alternative url redirection feature was not an option, so I needed something that can handle such logic. This brought me to my good friend ISA server (more specifically ISA 2006)

Let me explain using a small scenario:

MOSS 2007 Farm
- Web application: teamsites.contoso.com
- site collection: /sites/siteA

SP2010 Farm
- Web application: teamsites.contoso.com
- site collection: /sites/siteB

Now there is no way that you can have your users access teamsites.contoso.com/sites/siteA and teamsites.contoso.com/sites/siteB if you are just going to use a DNS entry. To which farm would you have it pointed? The user would only be able to access one of these two sites.

What if you have the DNS entry pointed to an ISA server? Could you configure ISA to analaze the incoming request and redirect the users to the correct farm? The answer is Yes !

In ISA 2006 you can create a publishing rule for publishing a SharePoint site. With a publishing rule you can accept incoming hostnames and redirect that to a specific computer or IP address. Now in addition to that you can specify the paths that a rule should respond to.

So for this solution to work you would create 2 Publishing rules :

- 1 publishing rule publishing the web application teamsites.contoso.com towards the SP2010 farm using the IP address of the SP2010 WFE or using load balancer Virtual IP address of the WFE Servers. On the Paths tab for the rule, remove the /* path and add the path /sites/siteB/* path

- 1 publishing rule publishing the web application teamsites.contoso.com towards the MOSS 2007 farm  using the IP address of the MOSS 2007 WFE or using load balancer Virtual IP address of the WFE Servers. On the Paths tab for the rule, remove the /* path and add the path /sites/siteA/* path

Apply the new rules and that should do it.

With this in place you can easily plan the upgrade of all the individual site collection one by one if you want and let your users work transparently throughout your migration period with the same url they are used too.

Now I have tested this scneario and it actually does work. I also must admit that I have not tested this scenario very thoughly yet and that there mey be some catches, but hey it’s the idea that I want to pass you on

 

Posted in SharePoint 2010, Tips, Upgrade | 2 Comments

New SharePoint Documents – July 2010

Upgrading to Microsoft SharePoint Server 2010
Brief Description:
Perform an upgrade from Microsoft Office SharePoint Server 2007 to SharePoint Server 2010.
Overview:
This book is designed to guide administrators and IT professionals through the process of upgrading to Microsoft SharePoint Server 2010.

 http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fd2172e1-f9a7-45ce-ae5c-26714fd751f5

 

 

Deployment guide for Microsoft SharePoint Server 2010
Brief Description:
Deployment instructions for SharePoint Server 2010.
Overview:
This book includes information deployment scenarios, step-by-step installation instructions, and post-installation configuration steps for deploying Microsoft SharePoint Server 2010.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=a54c7191-eb05-489e-a7ca-6453aba8877c

 

Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products
Brief Description:
Describes concepts of identity in SharePoint 2010 Products, Kerberos authentication, and how to use it in various scenarios
Overview:
This document provides you with information that will help you understand the concepts of identity in SharePoint 2010 products, how Kerberos authentication plays a critical role in authentication and delegation scenarios, and the situations where Kerberos authentication should be leveraged or may be required in solution designs. The document also shows you how to configure Kerberos authentication end-to-end within your environment, including scenarios which use various service applications in SharePoint Server. Additional tools and resources are described to help you test and validate Kerberos configuration. The “Step-by-Step Configuration” sections of this document cover several SharePoint Server 2010 scenarios. 

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=1a794fb5-77d0-475c-8738-ea04d3de1147

 

SharePoint 2010 Governance Planning
Brief Description:
This white paper focuses on the “front end” of the SharePoint environment – the business aspect of governance – the areas that impact business users.
Overview:
A Governance Plan describes how your SharePoint environment will be managed. It describes the roles, responsibilities, and rules that are applied to both the back end (hardware, farm, application, database configuration and maintenance) and the front end (information architecture, taxonomy, user experience). This white paper focuses on the “front end” of the SharePoint environment – the business aspect of governance – the areas that impact business users.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=d41ab7b1-385b-41f6-90a0-03cfda4fa98f

 

SharePoint Server 2010 design samples: Corporate portal with classic authentication or with claims-based authentication
Brief Description:
Design samples illustrating a typical corporate deployment of SharePoint Server 2010 and using two forms of authentication
Overview:
These design samples illustrate a typical corporate deployment, with the most common types of SharePoint sites represented. The two samples differ only in the mode of authentication that is implemented — one uses classic authentication and one uses claims-based authentication.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=704c984d-2245-4a7d-8ff5-1e57c9a473a8 

 

Microsoft Project and SharePoint Server 2010 — Better Together

Brief Description:
A white paper for stakeholders in a program ecosystem
Overview:
This white paper is written with the end user in mind. It will highlight the new features in Project Server 2010 and how this tool has evolved into a must-have requirement for Project Management. You will see capabilities in this release that you have been wanting, hoping for and most likely haven’t even thought of. Plus with Microsoft tethering Project to their shining star, SharePoint, it has created the most significant Project release of the decade.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=4f327363-181b-43ea-99f8-58927b452135 

 

End-to-End Content Deployment Walkthrough

Brief Description:
End-to-end example of how to create and complete a content deployment between two site collections.
Overview:
This paper provides an overview of the content deployment feature in Microsoft Office SharePoint Server 2007 for the IT Pro audience, and describes an end-to-end scenario for how to create and successfully perform a content deployment between two site collections.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=9a38c1cd-83b7-4759-b01f-2cd3f955a9ad 


SharePoint Server 2010 performance and capacity test results and recommendations

Brief Description:
These white papers describe the performance and capacity impact of specific feature sets included in Microsoft SharePoint Server 2010.
Overview:
These white papers describe the performance and capacity impact of specific feature sets included in SharePoint Server 2010. These white papers include information about the performance and capacity characteristics of the feature and how it was tested by Microsoft, including:

·         Test farm characteristics
·         Test results
·         Recommendations
·         Troubleshooting performance and scalability

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fd1eac86-ad47-4865-9378-80040d08ac55 

 

Microsoft Forefront Protection 2010 for SharePoint Documentation

Brief Description:
Documentation about Microsoft Forefront Protection 2010 for SharePoint
Overview:
Forefront Protection 2010 for SharePoint (FPSP) helps reduce company liability and prevents data theft by denying access to documents containing out-of-policy content, confidential information, inappropriate language, and malware. FPSP integrates multiple scanning engines from industry-leading security partners into a single solution. The documents available in this download include information about FPSP deployment, operations, technical reference, and troubleshooting. This information is also available in the Microsoft TechNet Library at http://go.microsoft.com/fwlink/?LinkID=111584.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bd917b26-bd06-4a93-8858-a0ea7e893992 

Posted in SharePoint 2010 | Leave a comment

Microsoft SharePoint 2010 Administration Toolkit v1.0 released

Found this toolkit while scanvenging the new downloads on th MS Download site.

Beware of the final line on the download page:  This tool is not supported for SharePoint Foundation 2010.

Microsoft SharePoint 2010 Administration Toolkit v1.0

Brief Description:

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

Overview:

The Microsoft SharePoint Administration Toolkit contains the following tools to help manage SharePoint Foundation 2010 and SharePoint Server 2010:

  • Security Configuration Wizard (SCW) manifests, which add roles for SharePoint 2010 Products to Windows Server 2008 with Service Pack 2 or to Windows Server 2008 R2.

    SCW is an attack surface reduction tool introduced with Windows Server 2003 Service Pack 1. SCW uses a roles-based metaphor to solicit the functionality required for a server and disables the functionality that is not required. By automating this security best practice, SCW helps to create Windows environments that are less susceptible, on the whole, to security vulnerabilities that have been exploited. For more information about SCW in Windows Server 2008, see Security Configuration Wizard (http://go.microsoft.com/fwlink/?LinkId=185511).

  • Load Testing Toolkit (LTK), which generates a Visual Studio Team System 2008 (VSTS) load test based on Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 IIS logs. The VSTS load test can be used to generate synthetic load against SharePoint Foundation 2010 or SharePoint Server 2010 as part of a capacity planning exercise or a pre-upgrade stress test.

    To install the Visual Studio Team System (VSTS), see Visual Studio Team System 2008 Team Suite (http://go.microsoft.com/fwlink/?LinkID=101641). To install Service Pack 1, see Microsoft Visual Studio 2008 Service Pack 1 (http://go.microsoft.com/fwlink/?LinkID=116488).

  • User Profile Replication Engine 2010 (UPRE2010), which provides a shared services administrator the ability to replicate user profiles and social data between shared services providers (SSP) in Office SharePoint Server 2007 and User Profile service applications in SharePoint Server 2010. This Windows PowerShell-based tool is not supported for SharePoint Foundation 2010.
  • Content Management Interoperability Services (CMIS) connector for SharePoint Server 2010

    The Content Management Interoperability Services (CMIS) connector for SharePoint Server 2010 enables SharePoint users to interact with content stored in any repository that has implemented the CMIS standard, as well as making SharePoint 2010 content available to any application that has implemented the CMIS standard.

    The CMIS connector for SharePoint Server 2010 includes two features:

    • The Content Management Interoperability Services (CMIS) Consumer Web Part, which can be added to any SharePoint page. This Web Part displays and lets users interact with the contents of any CMIS repository.
    • The Content Management Interoperability Services (CMIS) Producer, which allows applications to interact with SharePoint lists and document libraries programmatically by means of the interfaces defined in the CMIS standard.


For more information about the Content Management Interoperability Services (CMIS) standard, see
OASIS Content Management Interoperability Services (CMIS) TC (http://go.microsoft.com/fwlink/?LinkId=196694).

This tool is not supported for SharePoint Foundation 2010.

Posted in SharePoint 2010, Tools | Leave a comment