This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(179.20000000000002, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
I have azure SharePoint 2019.In one my my application we have connection with on premises SQL data base
When i created one console application on SharePoint azure server and tried to access SQL db its working fine
but when i tried to access premises SQL data base using SharePoint site collection getting the below error
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
Please check the below connection string i am using
Data Source=ServerIP,Port;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False
I tried without integrated security also but same issue i am facing.
Could you share the code for further research?
string storedProc = "StoreProcName";
SqlConnection sqlConnection = new SqlConnection("Data Source=IPAddress,PortNo;Initial Catalog=DBName;User ID = 'UserName'; Password = 'Password';Integrated Security=SSPI;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand command = new SqlCommand(storedProc, sqlConnection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@TaskName", "Parameters");
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
You're mixing User ID/Password with Integrated Security. User ID/Password are used when you want to use SQL authentication; Integrated Security when using Windows auth. Mixing them means you're using Windows auth as Integrated Security overrides User ID/Password.
If the farm isn't on the same domain as the SQL server or there isn't a trust in place between two forests, then yes it will fail because you're attempting to use Windows auth. If that isn't the case, you will likely need to set up Kerberos Constrainted Delegation so the end user's credentials can be passed to the SQL server (you'll encounter the double-hop scenario otherwise).
This issue requires a SharePoint environment in azure. I suggest you raise a ticket on SharePoint Server Support, the corresponding team could help this further.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.