Sharepoint 2019 e office online server 2019 - External Data Refresh Failed

Question

Boa tarde,

Há dias estou enfrentando um problema para acessar dados externos no sharepoint. Quando tento acessar os dados usando com autenticação o Secure Store, tudo funciona perfeitamente. Agora, quando tento acessar os mesmos dados usando a autenticação do windows, sempre apresenta a mensagem de erro abaixo:

Parte dos logs do Office Online Server:

Excel Calculation Services a1tj3 Medium CredentialsDelegation.UpnLogon: logon elapsed 0ms> Excel Calculation Services c9la Medium CredentialsProvider.GetCredentials: Failed to get WindowsIdentity.> Excel Calculation Services aq0kx Medium EcsCommandResultExtendedInfo.AddExternalDataException: There's an existing error for connection 'SRV-DB' with the same exception Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException' was thrown.. This error message will not be added:> Excel Calculation Services ajhkx Medium SessionUser.EnsureCredentialsForExternalData: Failed to get credentials. User=i:0#.w|empresa\srv.adm> Excel Calculation Services 3sia Medium ExcelServerRegionalSettings.CurrentUICulture: Set the current thread's UI culture to LCID 1046 'pt-BR' (Portuguese (Brazil)). > Excel Calculation Services a1tj8 Medium CredentialsProvider.TranslateSidToUpn translation elapsed 23ms> Excel Calculation Services a1tj2 Monitorable CredentialsDelegation.UpnLogon: logon failed (C2WT / KCD not configured?): exception: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at net.pipe://localhost/s4u/022694f3-9fbd-422b-b4b2-312e25dae2a2 that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.IO.PipeException: The pipe endpoint 'net.pipe://localhost/s4u/022694f3-9fbd-422b-b4b2-312e25dae2a2' could not be found on your local machine. --- End of inner exception stack trace --- Server stack trace: at System.ServiceModel.Channels.PipeConnectionInitiator.GetPipeName(Uri uri, IPipeTransportFactorySettings transportFactorySettings) at System.ServiceModel.Channels.NamedPipeConnectionPoolRegistry.NamedPipeConnectionPool.GetPoolKey(EndpointAddress address, Uri via)

Parte dos Logs do SharePoint:

SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (POST:http://srv-spoint/_layouts/15/WsaUpload.ashx) > SharePoint Foundation Asp Runtime avwhz Medium SPRequestModule.BeginRequestHandler End, SP Build Version: '16.0.10337.12109' > SharePoint Foundation Claims Authentication bjkuz Medium Using input cookie name. CookieName: 'FedAuth'. > SharePoint Foundation Audience Validation a9fy6 Medium The absolute uri validation succeeded. AudienceUri: 'http://srv-spoint/'. > SharePoint Foundation Application Authentication bjvyg Medium SPApplicationAuthenticationModule: Clear outgoing token context from SpThreadContext > SharePoint Foundation Application Authentication bnksk Medium SPApplicationAuthenticationModule: Clear cross tenant token context from SpThreadContext > SharePoint Foundation Asp Runtime avwh6 Medium SPRequestModule.PostAuthenticateRequestHandler Begin 56ec0da1-a796-40da-1e35-4d7feba77548> SharePoint Foundation Authentication Authorization agb9s Medium Non-OAuth request. IsAuthenticated=True, UserIdentityName=0#.w|empresa\srv.adm, ClaimsCount=81 > SharePoint Foundation Runtime ajd6k Medium Value for isAnonymousAllowed is : True > SharePoint Foundation Runtime ajd6l Medium Value for checkAuthenticationCookie is : True > SharePoint Foundation Runtime ajd6m Medium ExistingCookie is System.Web.HttpCookie

Podem me ajudar???

Answer 1

Olá Cleiton Carlos da Silva

Esperamos que esta mensagem o encontre bem.

Pedimos sinceras desculpas pela demora em trazer seu tópico para este fórum.

Quero me colocar à sua disposição se hoje você ainda tiver o problema para o qual abriu este tópico.

Estarei atento à sua resposta.

Se não recebermos uma resposta sua nos próximos dias, continuaremos a fechar o tópico. No entanto, gostaríamos de garantir que estamos sempre disponíveis para qualquer assistência que você possa precisar.

Agradecemos sua compreensão e estamos disponíveis para ajudar no que for necessário.

Atenciosamente

Jonathan