Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Vin21
New Member

Gateway Error - "Unable to connect: We encountered an error while trying to connect to"

Hello!

I am trying to add data source to my gateway. However, I am encountering this error:

 

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."

1 ACCEPTED SOLUTION

Hi ,

 

When you configure the gateway data source,  the  most important thing is to make sure the credentials are correct  and unexpired.
(Windows account you enter must have Server Administrator permissions for the instance you're connecting to. If this account’s password is set to expire, users could get a connection error if the password isn’t updated for the data source. )

 

Then if you use windows authentication method ,please use domain\username instead  in windows username

08.png


07.png

 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi, @Vin21 

 Please show more details .

You can take a screenshoot  as below to better show us the basic error message details. (Be careful to block out some sensitive information)

04.png


Best Regards,
Community Support Team _ Eason


Hi @v-easonf-msft 

I am unable to upload snapshot. Here is the error message:

Activity ID:967ab9d5-a1c1-42fe-88e6-81754ef75e63
Request ID:a2618a28-800c-edc3-13af-82d8f90d9edc
Cluster URI:https://wabi-uk-south-b-primary-redirect.analysis.windows.net/
Status code:400
Error Code:DMTS_UpdateClusterDatasourceCredentialsErrorCode
Time:Thu Feb 27 2020 08:09:51 GMT+0000 (Greenwich Mean Time)
Service version:13.0.12439.190
Client version:2002.3.018

 

SQLSERVER:Invalid connection credentials.
Underlying error code:-2146232060
Underlying error message:Login failed for user '••••••••••••'.
DM_ErrorDetailNameCode_UnderlyingHResult:-2146232060
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode:18456

 

Best Regards,

 

Vin

Hi ,

 

When you configure the gateway data source,  the  most important thing is to make sure the credentials are correct  and unexpired.
(Windows account you enter must have Server Administrator permissions for the instance you're connecting to. If this account’s password is set to expire, users could get a connection error if the password isn’t updated for the data source. )

 

Then if you use windows authentication method ,please use domain\username instead  in windows username

08.png


07.png

 

 

Best Regards,
Community Support Team _ Eason

THANK YOU!!!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors