Azure(SharePoint) server connectivity with on premisesSQL server using code

vinesh nagpal 1 Reputation point
2020-10-07T14:18:57.75+00:00

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.

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,557 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Amos Wu-MSFT 4,051 Reputation points
    2020-10-09T09:34:49.14+00:00

    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.

    0 comments No comments