Gateway issue

[Lorentz_]

In this last week I get this error during dataset update. No error occurred instead using Power BI Desktop I updated the gateway last version but the error still exist. I tried with a new gataway connection but nothing is changed. the user and password are right. The instance MSSQL is running in to the cloud envirorment ID attività: 7664aba2-2b1d-4421-9b0f-0c7a4c744b61 ID richiesta: eabac7bb-29e3-a64f-1f6b-a9b61861109d URI cluster: https://wabi-west-europe-b-primary-redirect.analysis.windows.net Codice di stato: 400 Codice errore: DMTS_UpdateClusterDatasourceCredentialsErrorCode Ora: Thu Sep 12 2019 11:05:11 GMT+0200 (Ora legale dell’Europa centrale) Versione: 13.0.10668.164 NAV PROD: La connessione a SQL Server non è riuscita Codice errore sottostante: -2146232060 Messaggio di errore sottostante: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) DM_ErrorDetailNameCode_UnderlyingHResult: -2146232060 DM_ErrorDetailNameCode_UnderlyingNativeErrorCode: 67 Any idea about my issue? Thanks, Lorenzo

[Anonymous · Accepted solution]

@Lorentz_ The specific error seems to be related to the Gateway not being able to communicate with the SQL Server, here is a good article of things to check between the servers where gateway is vs. SQL -> https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-erro...

You mention you are in a cloud, but I assume that means (Infrastructure as a Service) so I believe while the above is still relevant since you are using gateways etc. In any case, I would dig into it from the back end if nothing has changed on the front.

[Lorentz_]

@Anonymousthanks a lot. Your opinion makes sense. I'm going to check what happened in the past few days.