MOSS 2007 upgrade - SSP migration and my sites

MOSS 2007 upgrade - SSP migration and my sites
09 November, 2016
Fady Soliman
2976 Views

MOSS 2007 upgrade - SSP migration and my sites

Abstract

The second part of the MOSS 2007 upgrade process is the Shared Services Provider (SSP) and my sites upgrade. In this step you will upgrade the my sites web application, In a nutshell, it's the web application containing all organization user profiles with the same organization structure based on the synchronization with the active directory through the SharePoint user profile synchronization service. Upgrading the my sites web application looks similar to upgrading any web application with its content database as described in the previous post MOSS 2007 upgrade - Upgrading content databases.

Before we begin in the SSP and my sites migration, you should check the old MOSS 2007 my sites web application and its content database, take a SQL backup from the content database and restore it on the new SharePoint 2010 database server as illustrated before in the previous post MOSS 2007 upgrade - Upgrading content databases.

This post will start considering you have the old MOSS 2007 my sites content database as well as the SSP database restored on the SharePoint 2010 database server.

Shared Services Provider (SSP) migration

To handle the SSP migration you will create a user profile service application on the SharePoint 2010 server, start the user profile synchronization service then upgrade the my sites content database. The following steps will guide you through this.

Managed Metadata Service

The first step in the SSP migration is to check if the Managed Metadata application service is created and if the Managed Metadata service is started. To achieve this, follow these steps.

  1. Log into the SharePoint 2010 server.
  2. Open SharePoint Central Administration.
  3. On the left, click Application Management.
  4. Under Service Applications, click Manage Service Applications.
  5. Check if the Managed Metadata service application is among your service applications and has its status as "Started" but if not, then on the SharePoint ribbon at the top, click New then Managed Metadata Service.
  6. On the Create New Managed Metadata Service window, type in a name for the service application, a database name and an application pool name then click OK.

To make sure that the Managed Metadata Web Service is started, then follow these steps.

  1. On the Central Administration, click Application Management on the left.
  2. Under Service Applications, click Manage services on server.
  3. Check if the Managed Metadata Web Service has its status as "Started" and if not then click "Start" to start it.

User profile service

Now it's time for the second step in SSP migration which is creating the user profile service application.

  1. Log into the SharePoint 2010 server.
  2. Open SharePoint 2010 Management Shell command prompt. You can do this by clicking Start, All Programs, Microsoft SharePoint 2010 Products then SharePoint 2010 Management Shell.
  3. Create a new application pool for the user profile service application. To do this, type in this command
    new-spserviceapplicationpool –name spnewprofile –account domain\account
    Where spnewprofile is the name of the new application pool and domain\account is the account that should be set as the application pool identity.
  4. Create a new user profile application service. On the same SharePoint 2010 Management Shell command prompt, type in this command
    new-spprofileserviceapplication -applicationpool spnewprofile –name newprofileservice –profiledbname sspdbname –profiledbserver servername
    Where spnewprofile is the application pool name of the application pool that you created in step 3, newprofileservice is the name of the user profile application service, sspdbname is the name of the SSP database you have restored on the SharePoint 2010 database server and servername is the database server name. This command will result in giving you an ID in a GUID format. Copy this ID from the command prompt by marking it and hitting the Enter button. This ID will be used in the next step.
  5. Create a new proxy for the user profile service application created in step 4. Type in this command in the SharePoint 2010 Management Shell
    new-spprofileserviceapplicationproxy –serviceapplication ID –name newspprofileserviceapplicationproxy –defaultproxygroup
    Where ID is the user profile service application ID that you have copied in step 4 and newspprofileserviceapplicationproxy is the proxy name.
  6. Update the User Profile service application permissions by going to the Central Administration then click Application Management on the left.
  7. Under Service Applications, click Manage Service Applications.
  8. Select the user profile service application that you have created, then click Administrators from the SharePoint ribbon at the top.
  9. Add the user in question and give him full control then click OK.
  10. Now it's time to start the User Profile and User Profile Synchronization services. To do this, click Application Management on the left of the SharePoint 2010 Central Administration.
  11. Under Service Applications, click Manage services on server.
  12. Scroll down to the User Profile Service and the User Profile Synchronization Service and start them.
  13. Reset your IIS. In the SharePoint 2010 Management Shell, type in this command
    iisreset

My sites upgrade

Now the third step in SSP migration and my sites is the my sites upgrade. Again, the my sites web application is the one containing all user profiles with their organization structure as configured in the active directory. To upgrade the my sites web application, follow these steps.

  1. On SharePoint 2010 Central Administration, create a new web application for my sites. Its URL will be assumed as http://mysiteswebapp in this post.
  2. It's time to test the restored content database of my sites MOSS 2007 web application against the newly create SharePoint 2010 web application in step 1. To do this, type in this command
    test-spcontentdatabase –name mysitesdbname –webapplication http://mysiteswebapp
    Where mysitesdbname is the content database name of my sites and http://mysiteswebapp is the new my sites web application URL created in step 1. This test should give you no errors.
  3. Now, as done before with content databases, it's time to mount it to the web application created in step 1. Type in this command to do this
    mount-spcontentdatabase –name mysitesdbname –webapplication http://mysiteswebapp

Set up the new My sites

After you have upgraded your my sites web application successfully, it's time to set it up on SharePoint 2010 Central Administration to allow all users to be redirected correctly to the new my sites web application when they click, for example, My Profile. To do this follow these steps.

  1. Open SharePoint 2010 Central Administration.
  2. Click Application Management on the left.
  3. Under Service Applications, click Manage service applications.
  4. Select the user profile service application created before and on the SharePoint ribbon, at the top, click Manage.
  5. Under My Sites Settings, click Setup My Sites.
  6. In My Site Host section, write your upgraded my sites web application's URL.
  7. In Personal Site Location section, write a wildcard location to be used for the personal sites.
  8. In the Read Permissions Level section, add all authenticated users group.
  9. Click OK.

Summary

In this post, you have upgraded the Shared Services Provider and My Sites web application. You have done this going through main four steps.

  1. Managed Metadata application service creation and starting the Managed Metadata service.
  2. User profile application service creation and starting the user profile and user profile synchronization service.
  3. Upgrading My Sites web application.
  4. Setting up My Sites for all users.

18 September, 2013
Fady Soliman
migration , sharepoint , sharepoint upgrade , sql
2976 Views

Did you find this helpfull?

About The Author

Fady Soliman

An experienced, resourceful and highly motivated IT professional, with a proven record of success in both Stack Development and Software Architecture. Possesses a wealth of transferable skills, including outstanding interpersonal, problem solving and staff management abilities. A capable organizer, quick to grasp – and make good use of – new ideas and information, and reliable and conscientious in all he takes on.

leave A Comment