Azure Function connection issue with trusted SQL server connection

Question

Azure Function connection issue with trusted SQL server connection

Raunak Jaiswal 0

We have hosted our SQL server instance on Azure Virtual Machine with trusted connections (Windows Authenticator). Having issue to connect SQL server in azure function.

the error message showing - Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

connection String in the format used: Server=; Database= ;Trusted_Connection=SSPI;

MayankBargali-MSFT 71,016 Reputation points Moderator

2023-08-28T04:58:55.56+00:00

@Raunak Jaiswal I have added the SQL server tag so the right team can assist you.
tbgangav-MSFT 10,431 Reputation points Moderator

2023-09-11T08:59:48.6133333+00:00

Hi @Raunak Jaiswal ,

Can you please elaborate what you meant by saying "Having issue to connect SQL server in azure function."?

Can you share more information, context and azure documentation links to explain what steps were taken and followed such that you have ended up with the error "Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. connection String in the format used: Server=; Database= ;Trusted_Connection=SSPI;"?

Can you share any screenshots obfuscating any PII information?

Answers to above questions would help us to understand more about the issue and route it to appropriate SME (Subject Matter Expertise) area to try answering your question. Thanks.
Anonymous

2023-09-11T10:41:19.9533333+00:00

Hi @Raunak Jaiswal - connection string doesn't look correct, what I think you meant is "Trusted_Connection=true; Integrated Security=SSPI"

In any case setting trusted connection means the client will try and connect using windows credentials and this is not supported by App Service/Functions hosted in Azure.

Alternative would be to use AAD as the authentication provider which is compatible with later versions of SQL on [Azure] VMs and SQL client libs