Answered by:
Sharepoint Configuration Wizard Fails

Question
-
Hi,
I am having trouble in running SharePoint Configuration Wizard.Actually when i try to run the wizard it fails on step number 5 as can be seen from the below screen shot.
I tried to do remove the SPSearchService entry as mentioned in the below article but no success.
Can anyone help me and mention step by step what i need to do in order to run the wizard successfully.
Thursday, February 27, 2014 8:46 AM
Answers
-
two things:
did you execute these commands, to set the database to multiuser:
--Set the database back to Multi-User mode
ALTER DATABASE "SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c" SET MULTI_USER
--Ensure Database is reset
EXEC sp_resetstatus 'SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c'2) also make sure the "mossdev\administrator" must have DBO rights on the SharePoint Admin Content db.
Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog
- Proposed as answer by Hemendra AgrawalModerator Friday, March 7, 2014 11:46 AM
- Marked as answer by Hemendra AgrawalModerator Tuesday, March 11, 2014 7:12 AM
Friday, February 28, 2014 2:18 PM -
Hello,
If you are facing issue in browsing Central Admin then this can be a upgrade fails issue which is done either manually or through Windows Update.
Please do the following it should help.
- Click Start, click Run, type cmd, and then click OK.
- Locate the following folder:
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN"
- Open a Command Prompt window.
- At the command prompt, type the following command, and then press ENTER:
psconfig -cmd upgrade -inplace b2b -wait -force
After it's successfully executed then run the following SQL queries.
--Set the database back to Multi-User mode
Please Mark it answer if it solves problem.
ALTER DATABASE "SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c" SET MULTI_USER
--Ensure Database is reset
EXEC sp_resetstatus 'SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c'- Marked as answer by hellofragrance Friday, March 14, 2014 9:27 AM
Monday, March 3, 2014 6:10 AM
All replies
-
Hello,
Just verify the DB permission once again Open Sql Server Management Studio, make sure the user account have dbcreator, dbowner permission on the Sharepoint_AdminContent... db.
I have also found one article for your ref:
Hemendra:Yesterday is just a memory,Tomorrow we may never see
Please remember to mark the replies as answers if they help and unmark them if they provide no helpThursday, February 27, 2014 9:15 AMModerator -
one more thing ,I am able to open my sharepoint sites but cannot open central admin and cannot run configuration wizard as mentioned above.Thursday, February 27, 2014 9:40 AM
-
Hi
I noticed one thing in SQL Server Management studio that Database named with "SharePoint_AdminContent_fdef7fd9-72b7-42ee-9d51-9d5385234179" was in suspect mode so i googled and found following article
www.sharepointfix.com/2011/05/sharepoint-central-administration.html
followed the steps mentioned in the above article now my database is showing like this.
please help me what i need to do so that it becomes like others.
Secondly,I still cannot run the sharepoint configuration wizard as well as cannot ope central open but my other sites are opening successfully.
Friday, February 28, 2014 1:53 PM -
two things:
did you execute these commands, to set the database to multiuser:
--Set the database back to Multi-User mode
ALTER DATABASE "SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c" SET MULTI_USER
--Ensure Database is reset
EXEC sp_resetstatus 'SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c'2) also make sure the "mossdev\administrator" must have DBO rights on the SharePoint Admin Content db.
Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog
- Proposed as answer by Hemendra AgrawalModerator Friday, March 7, 2014 11:46 AM
- Marked as answer by Hemendra AgrawalModerator Tuesday, March 11, 2014 7:12 AM
Friday, February 28, 2014 2:18 PM -
Hello,
If you are facing issue in browsing Central Admin then this can be a upgrade fails issue which is done either manually or through Windows Update.
Please do the following it should help.
- Click Start, click Run, type cmd, and then click OK.
- Locate the following folder:
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN"
- Open a Command Prompt window.
- At the command prompt, type the following command, and then press ENTER:
psconfig -cmd upgrade -inplace b2b -wait -force
After it's successfully executed then run the following SQL queries.
--Set the database back to Multi-User mode
Please Mark it answer if it solves problem.
ALTER DATABASE "SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c" SET MULTI_USER
--Ensure Database is reset
EXEC sp_resetstatus 'SharePoint_AdminContent_38c5cc2d-aeec-4dc2-b7a5-65457250ae2c'- Marked as answer by hellofragrance Friday, March 14, 2014 9:27 AM
Monday, March 3, 2014 6:10 AM