SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
364 questions
Azure Function connection issue with trusted SQL server connection
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 81%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Raunak Jaiswal
0
Reputation points
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;
{count} votes
-
MayankBargali-MSFT 69,841 Reputation points2023-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,406 Reputation points2023-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.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 93%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Ben Gimblett 3,655 Reputation points Microsoft Employee2023-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
Sign in to comment