Dear,
while trying to connect to a datawarehouse on Microsoft Fabrics, following error is being raised
However, connection is successful on SSMS.
Grateful for a guidance.
Thanks
Khaleelah
Hi Robert,
Followed below and was able to connect successfully to fabrics
Hi Khaleelah, from your screenshot it appears that your connection is succeeding but it's not liking the username/password combination, are you quite sure those are both correct?
The login/password is correct. Is the security configuration ok below?
Hi Khaleelah, the exact configuration of your connection will depend on the setup of your source so it's hard to say whether that's correct. Looking at this article since you say it's a MS Fabric database you're connecting to, it states that SQL Authentication isn't supported and that you need to use a Microsoft Entra ID, not sure whether that could be related to your issue? https://learn.microsoft.com/en-us/fabric/database/sql/authentication
