Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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."
Solved! Go to 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
Best Regards,
Community Support Team _ Eason
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)
Best Regards,
Community Support Team _ Eason
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
Best Regards,
Community Support Team _ Eason
THANK YOU!!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
14 | |
8 |
User | Count |
---|---|
50 | |
39 | |
32 | |
15 | |
13 |