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.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.
"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
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.
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.
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Let me know how it goes.