Microsoft Knowledge Base Email Alertz

My Sites and My Links are not available or browsable post migration of SPS 2003 Portal to MOSS 2007 by using the Content DB migration method

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 970819 - Last Review: April 30, 2009 - Revision: 1.0

My Sites and My Links are not available or browsable post migration of SPS 2003 Portal to MOSS 2007 by using the Content DB migration method

Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Symptom



Post running PreScan on a SPS 2003 portal and then used the content DB migration methods to migrate / upgrade the site; The links for "My Sites" and "My Links" are not available.

Clicking on the link "My Site", it tries to create a new My Site rather than opening the existing one.

Cause

The My Sites in SPS 2003 gets stored under the _SITE database and other profile properties are under the _PROF database.

Resolution

  1. Migrate the portal content db.

    stsadm -o addcontentdb -url http://servername:port/ -databaseserver dbserver -databasename portal_SITE
  2. Create a web named something like “mysites” using My Site Host template under the portal

    stsadm -o createweb -url http://servername:port/mysites -sitetemplate SPSMSITEHOST -title "MySite Host"
  3. Restore SSP from the old PROF db:

    stsadm -o restoressp -title Restored_SSP -url http://servername:port -ssplogin DOMAIN\Useraccount -mysiteurl http://servername:port/mysites -indexserver indexservername -indexlocation "d:\index” -keepindex -sspdatabaseserver dbserver -sspdatabasename portal_PROF -ssppassword pwd
  4. Execute IISReset. With the help of SSP admin, check My Site settings, search settings, User profiles to make sure they all look good.
  5. Next sign is as a user, and click on My Site in portal home page, you are directed to the http://servername:port/personal/userid and when clicked on My Profile (or other users click on my name) they are directed to http://servername:port/mysites/person.aspx?accountname=DOMAIN\userid (http://servername:port/mysites/person.aspx?accountname=DOMAIN\userid) .

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

APPLIES TO
  • Microsoft Office SharePoint Server 2007
Keywords: 
kbrapidpub kbnomt KB970819
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate