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:

Professional Opinions
Ask a Question
Did 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

troubleshooting Question

Error Creating MySite in SharePoint

Avatar of hlking
hlking asked on
Microsoft SharePoint
4 Comments1 Solution927 ViewsLast Modified:
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 hlking

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers