HI.. i installed onpremise gatway on azure VM server (cluster). and I am trying to add azure sql database to this gateway but not able to do that. i am gettig below error. iam using basic authentication to login
'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 want to know if it is even supported to add azure sql database to a gateway installed on azure VM. ?
i know we dont need a gateway in this case since it is a azure sql database but we have some users not able to refresh it directly so we thought adding it to gateway n see.
can anyone suggest ?
@v-frfei-msft can u help?
