Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Got an existing enterprise gateway data source set up properly connecting to a SQL server using SQL standardard connection. However, when I tried changing to a Window Authentication (windows login and password), it came up with an error like this.
Unable to connect: We encountered an error while trying to connect to [server name]. Details: "Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller for the authentication request."
I have confirmed that I can connect to the SQL server using the window credential via SQL management studio so definitely nothing wrong with the permission. And the gateway is installed on the same server of the SQL server. So assume no firewall issue. The standard connection works anyway.
Anyone got a clue?
Solved! Go to Solution.
@v-qiuyu-msft you are right. It must be to do with the DNS name as I found out later that I could connect using IP address.
Hi @Anonymous,
From the error message, the issue is caused by that the typed server name is not corresponding to the IP address which you can connect to successfully. If you want to configure data source connection use server name, you need to check DNS settings. Please take a look at the article below:
DNS client fails to resolve name
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
@v-qiuyu-msft you are right. It must be to do with the DNS name as I found out later that I could connect using IP address.
Had another try using IP address as the server name and it worked. So it probably is the DNS server issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |