Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am getting the following error message when I try to open up My Site for the first time.

Your personal site cannot be created because it already exists with your user name. Please contact your administrator.

I am the only person on our network with my user name but I used to have two of them due to a federated domain situation. I think that I may have pulled up the My Site using the other domain name once. Now that I'm using my normal domain name it is hitting a conflict.

Is the correct resolution to this to simply delete the site that is there (there is no content to my knowledge worth saving) and give it a chance to create properly?

share|improve this question
add comment

3 Answers

up vote 1 down vote accepted

Within Central Administration, go to Application Management and click the Delete Site Collection link. Select the proper web application from the drop down and find your My Site. Delete it (or both of them). Go back to a Sharepoint site and click on the My Site link and it should provision a new one.

This is assuming you're talking about 2007. In 2010 the steps are probably different due to the GUI redesign, but the premise is still the same, find the site collection(s) and delete them.

share|improve this answer
    
Ultimately we ended up deleting the old site and allowing it to re-create. –  NA Slacker May 5 '11 at 20:37
add comment

You could use the "Site Naming Format" section of the "My Site Settings" page within the SSP Admin site to resolve conflicts like this... Choose the middle option:

User name (resolve conflicts by using domain_username)

This should allow you to create a new MySite without conflicting with your existing one

share|improve this answer
add comment

You can try to delete it from cental admin (Site Collections) however you should verify whether it's exactly your site.

Or go to the SP content database and query all the sites.

SELECT TOP 1000 [FullUrl],[Id] FROM [dbo].[Sites]

Then you can delete that site. Not recommended but should work

share|improve this answer
2  
Querying the databases is not supported and is bad practice. Other options exist to find that information in more supported formats, STSADM and Powershell for example. –  PirateEric May 4 '11 at 13:47
    
Agreed, however I've mentioned that it's not recommended and suggested deleting through Central Admin first. –  AlexSSE May 4 '11 at 13:55
    
You should at least add NOLOCK to that query to prevent it from causing locking issues. –  Alex Angas May 5 '11 at 0:50
    
Never update the SQL tables in SharePoint, use the PowerShell cmdlets for any OM changes. –  Brian Scott Jan 4 '13 at 12:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.