Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
Troubleshooting
Research
Professional Opinions
Ask a QuestionDid You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
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
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.