[MSSQL] MSCS 환경에서 SQL Server Upgrade Error - Failed to retieve data for this request.

MSCS 환경에서 SQL Server Upgrade Error

SQL Server Setup failure.

SQL Server Setup has encountered the following error:

Failed to retieve data for this request.

 

1) Log 확인

C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\ 에 있는로그를 보도록 하겠습니다.

Exception summary:

The following is an exception stack listing the exceptions in outermost to innermost order

Inner exceptions are being indented

​

Exception type: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException

Message:

Failed to retrieve data for this request.

HResult : 0x80131500

Data:

HelpLink.ProdName = Microsoft SQL Server

HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink

HelpLink.LinkId = 20476

HelpLink.EvtType = 0xE8A0C283@0xAC7B1A58@1233@53

DisableWatson = true

Stack:

at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)

at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)

at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()

at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)

Inner exception type: Microsoft.SqlServer.Configuration.Sco.SqlRegistryException

Message:

The network path was not found.

​

HResult : 0x84d10035

FacilityCode : 1233 (4d1)

ErrorCode : 53 (0035)

Data:

WatsonData = Microsoft.SqlServer.Configuration.Sco.SqlRegistryException@Win32Error

 

2) 해결방안

시작 메뉴 > Services

Remote Registry 서비스를 Disabled > Manual 로 변경 후 Start

설치 완료 후, 보안을 위해 다시 Disabled 로 상태 변경

 

참고1)

https://blog.sqlauthority.com/2017/03/18/sql-server-microsoft-sqlserver-management-sdk-sfc-enumeratorexception-failed-retrieve-data-request/

SQL SERVER - Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request - SQL Authori

 

참고2)

https://iheedol.tistory.com/entry/MSCS-%ED%99%98%EA%B2%BD%EC%97%90%EC%84%9C-SQL-%EC%97%85%EA%B7%B8%EB%A0%88%EC%9D%B4%EB%93%9C-%EC%8B%9C-%EC%98%A4%EB%A5%98

MSCS 환경에서 SQL 업그레이드 시 오류