Enterprise Gateway failed to connect to SQL server with Windows Authenticatoin

[Anonymous]

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?

[v-qiuyu-msft]

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

[Anonymous · Accepted 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.

[Anonymous]

Had another try using IP address as the server name and it worked. So it probably is the DNS server issue.