Answered by:
Sharepoint Configuration Failed.

Question
-
Greetings,
I was following old old version (V1) of Ramblings of a Home Server User's guide for installing Sharepoint Services 3.0 on a WHS and then realized that there was an updated version that was generated after Power Pack 1. I uninstalled Sharepoint 3.0 from my machine to start fresh, rebooted it, then started to follow the updated guide (V2). I run into trouble when Sharepoint Services Configuration Fails. This is what I get...
Failed to register SharePoint services.
An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Could not find the stored procedure "dbo.proc_MSS_GetConfigurationProperty".
I have the log generated, but unless someone needs it I'll refrain from posting it because it's quite lengthy. Any assistance in this matter is greatly appreciated.
Edit: Spellchecked.
- Edited by Jon spraggins Sunday, February 1, 2009 8:27 PM
Sunday, February 1, 2009 7:53 PM
Answers
-
Jon,
I'm no expert on Sharepoint and my suggestion would be to do a server re-install if you can't get it fixed.
However, there is a dedicated Sharepoint forum, so while you wait, it might be worthwhile posting on there as well.
Good luck,
Colin
If anyone answers your query successfully, please mark it as 'Helpful', to guide other users.- Proposed as answer by kariya21Moderator Wednesday, February 4, 2009 5:37 PM
- Marked as answer by Lara JonesModerator Wednesday, February 18, 2009 6:12 PM
Sunday, February 1, 2009 9:05 PMModerator
All replies
-
Jon,
In the log file, it should show at what step it failed. If you could post that relevant section, it might help diagnose the problem.
Colin
If anyone answers your query successfully, please mark it as 'Helpful', to guide other users.Sunday, February 1, 2009 8:10 PMModerator -
I see a few "ERR" notes in the log ... Here they are. Six Total
First one ...
02/01/2009 14:30:28 7 ERR Exception: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.proc_MSS_GetConfigurationProperty'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.SharePoint.Search.Administration.SearchAdminUtils.GetProperty[T](SPSearchServiceInstance application, String name, T defaultValue)
at Microsoft.SharePoint.Search.Administration.SPSearchServiceInstance.get_IndexLocation()
at Microsoft.SharePoint.Search.Administration.SPSearchServiceInstance.Provision()
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstanceInConfigDB(Boolean provisionTheServiceInstanceToo, String serviceInstanceRegistryKeyName, Object sharepointServiceObject)
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstances(Boolean provisionTheServiceInstancesToo, String serviceRegistryKeyName, Object sharepointServiceObject)
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServices(Boolean provisionTheServicesToo)
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()Second One ...
02/01/2009 14:30:28 7 ERR An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Could not find stored procedure 'dbo.proc_MSS_GetConfigurationProperty'.
System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.proc_MSS_GetConfigurationProperty'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.SharePoint.Search.Administration.SearchAdminUtils.GetProperty[T](SPSearchServiceInstance application, String name, T defaultValue)
at Microsoft.SharePoint.Search.Administration.SPSearchServiceInstance.get_IndexLocation()
at Microsoft.SharePoint.Search.Administration.SPSearchServiceInstance.Provision()
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstanceInConfigDB(Boolean provisionTheServiceInstanceToo, String serviceInstanceRegistryKeyName, Object sharepointServiceObject)
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstances(Boolean provisionTheServiceInstancesToo, String serviceRegistryKeyName, Object sharepointServiceObject)
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServices(Boolean provisionTheServicesToo)
at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()Third One ...
02/01/2009 14:30:28 1 ERR Task services has stopped and failed. Total failed is now 1
Fourth One ...
02/01/2009 14:30:30 6 ERR Failed to register SharePoint services.
Fifth One ...
02/01/2009 14:30:30 6 ERR One or more configuration tasks has failed or some tasks were not run
Sixth One ...
02/01/2009 14:30:31 6 ERR One or more configuration tasks has failed to execute
Sunday, February 1, 2009 8:20 PM -
Jon,
I'm no expert on Sharepoint and my suggestion would be to do a server re-install if you can't get it fixed.
However, there is a dedicated Sharepoint forum, so while you wait, it might be worthwhile posting on there as well.
Good luck,
Colin
If anyone answers your query successfully, please mark it as 'Helpful', to guide other users.- Proposed as answer by kariya21Moderator Wednesday, February 4, 2009 5:37 PM
- Marked as answer by Lara JonesModerator Wednesday, February 18, 2009 6:12 PM
Sunday, February 1, 2009 9:05 PMModerator -
Okay, I'll cross-post there.Sunday, February 1, 2009 9:43 PM
-
You will probably not get a lot of assistance on this, other than the document you downloaded. Unfortunately, running Sharepoint on Windows Home Server is a completely unsupported operation, and if someone chooses to do so they are doing it at their own risk. As such, there will not be a lot of assistance in these forums.
Probably your best bet is going to be to step back to square one with a server reinstallation, as Colin has suggested, then see if you can get Sharepoint configured on a clean server. Just be aware that the only supported method of recovery for a WHS computer which has suffered a severe failure such as a failed system drive, or a corrupted OS installation, is a server reinstallation. This will require you to reconfigure anything you've added to your server, including Sharepoint.
I'm not on the WHS team, I just post a lot. :)- Proposed as answer by kariya21Moderator Wednesday, February 4, 2009 5:37 PM
Monday, February 2, 2009 12:04 AMModerator -
if I can avoid doing that, I will. I don't want to risk losing what data I have on the server for a superfluous feature. Thanks though.Monday, February 2, 2009 12:21 AM