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.Us
erProfiles
.PersonalS
iteCreateE
xception: A failure was encountered while attempting to create the site. ---> System.Data.SqlClient.SqlE
xception: 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.
Let me know how it goes.