Link to home
Start Free TrialLog in
Avatar of 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.
Avatar of Sushanta Sahu
Sushanta Sahu
Flag of Canada image

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.
Avatar of hlking


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.
The event viewer indicates about SQL Config DB issue. Try reconfiguring MySites again from SSP
Avatar of hlking

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial