cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beyj Frequent Visitor
Frequent Visitor

PowerBI Enterprise On-Premises Data Gateway Network Status Disconnected

I have installed a gateway on a VM within my network. It can connect to an SQL server on the same network in the same domain, but cannot connect to another SQL Server on the same network but in a different domain. The ports test is successful, but the Network Status shows as Disconnected. 

 

The error message we are receiving is:

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

Activity ID:ebc8df01-bae1-40aa-8664-f737a4b7afa8
Request ID:9082338b-d773-73f2-dcdd-9ac9a9bceb60
Cluster URI:https: //wabi-us-north-central-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Thu Aug 08 2019 13:52:33 GMT-0400 (Eastern Daylight Time)
Version:13.0.10315.184
Test-OnPremisesDataGateway:We reached the data gateway, but the gateway can't access the on-premises data source.
Underlying error code:-2146232060
Underlying error message:A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2146232060
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode:-2146893007
5 REPLIES 5
Community Support Team
Community Support Team

Re: PowerBI Enterprise On-Premises Data Gateway Network Status Disconnected

Hi @beyj ,

Firstly, please check if your gateway is online.

In addition, could you connect with the SQL Server data source successfully in power bi desktop which is installed on the same device with on- premise gateway.

If you could, I think you could add the sql server data source to the gateway in power bi service either.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
beyj Frequent Visitor
Frequent Visitor

Re: PowerBI Enterprise On-Premises Data Gateway Network Status Disconnected

My gateway is online. I've downloaded Power BI Desktop and tried to connect to the SQL Server, but I still get the following error:

 

Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.)"

Community Support Team
Community Support Team

Re: PowerBI Enterprise On-Premises Data Gateway Network Status Disconnected

Hi @beyj ,

Have you configure SSL on SQL server? If that is a case, I'd like to suggest you to double check credentials to confirm if his credentials is invalid?

How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console

Best Regard,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: PowerBI Enterprise On-Premises Data Gateway Network Status Disconnected

Hi @beyj ,

Have you solved the problem?

If you have solved the problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
beyj Frequent Visitor
Frequent Visitor

Re: PowerBI Enterprise On-Premises Data Gateway Network Status Disconnected

I have not solved the problem, and the SSL would probably not affect the network status of the gateway.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)