Avatar of hlking
hlking
 asked on

Error Creating MySite in SharePoint

The problem is that I have a user that clicks on "MySite" and gets this error message:

"There has been an error creating the personal site. Contact your site administrator for more information."

I checked the error logs and this is what I found:


02/16/2010 16:28:05.82       w3wp.exe (0x0980)                             0x0A1C      Windows SharePoint Services         Database                            6y63      Critical      SQL Database 'SPS01_Config_db' on SQL Server instance 'WVDLPortal' not found. Additional error information from SQL Server is included below.  Cannot open database "SPS01_Config_db" requested by the login. The login failed.  Login failed for user 'DOMAIN\administrator'.       
02/16/2010 16:28:05.84       w3wp.exe (0x0980)                             0x0A1C      SharePoint Portal Server            User Profiles                       7fyq      Critical      My Site creation failure for user 'DOMAIN\John.Doe' for site url 'http://intranet/personal/John_Doe'. The exception was: Microsoft.Office.Server.UserProfiles.PersonalSiteCreateException: A failure was encountered while attempting to create the site. ---> System.Data.SqlClient.SqlException: Cannot open database "SPS01_Config_db" requested by the login. The login failed.  Login failed for user 'DOMAIN\administrator'.  


It is trying to login to a configuration database that no longer exists.  That is the one that was used before I upgraded to 2007.  When I go into Central Administration it lists the correct configuration database.  I can't figure out why this is trying to login to the old one that is long gone.

This is a single server installation of SharePoint 2007 that has been upgraded from 2003.  Other "MySites" work.
Microsoft SharePoint

Avatar of undefined
Last Comment
hlking

8/22/2022 - Mon
Sushanta Sahu

Run the SharePoint products configuration wizard again. Check the SQL credentials for all the DBs. Make sure you have added the users to have Mysites in the SSP Permissions.
Let me know how it goes.
hlking

ASKER
I reran the configuration wizard and I verified the permissions on both the SQL DBs and MySite and I am still getting the same error.

I also tried deleting the user profile from SharePoint which didn't resolve the issue either.
Sushanta Sahu

The event viewer indicates about SQL Config DB issue. Try reconfiguring MySites again from SSP
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
hlking

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.