Skip to main content

An object in the SharePoint administrative framework "SPDatabaseServiceInstance Name=SharePoint" could not be deleted. SPWebServiceName=WSS_Administration SPWebService

SharePoint 2013 – error – removing SQL Server – wss_administration reference


Symptoms:

When you try to remove a not used SQL Server from SharePoint in the Central admin:

An object in the SharePoint administrative framework, "SPDatabaseServiceInstance Name= could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation. The dependant objects are as follows: SPWebService Name=WSS_Administration

Workaround:

You have switched to a new SQL server but SharePoint kept a reference. You can use an existing correct Web application to update Central admin with the good one:
$centralAdmin=Get-SPWebApplication -IncludeCentralAdministration | ? {$_.DisplayName -match ‘SharePoint Central Administration’}$goodExample=Get-SPWebApplication -identity ‘http://mygoodwebapp’
$centralAdmin.Parent.DefaultDatabaseInstance=$goodExample.Parent.DefaultDatabaseInstance$centralAdmin.Parent.Update()$centralAdmin.Update()
Use SQL Alias for the next time :)

Comments

Popular posts from this blog

Using External Content Types with Stored Procedures with Input Parameters

NAV 2009 Issues in Role Tailored Client