title: SQL Server creating external data source
body: <p>I'm trying to create external data source in SQL Server 2019. From one SQL Server instance to another.</p>
  
  <p>I have done everything like in documentation (<a href="https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-sql-server?view=sql-server-ver15" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-sql-server?view=sql-server-ver15</a>).
  To create external data source i use following command:</p>
  
  <pre><code>CREATE EXTERNAL DATA SOURCE SQLServerInstance
      WITH ( LOCATION = 'sqlserver://SQL2:port',
      PUSHDOWN = ON,
      CREDENTIAL = MyCredentials);
  </code></pre>
  
  <p>But i keep getting following error:</p>
  
  <blockquote>
    <p>Msg 46721, Level 20, State 1, Line 1<br>
    Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.</p>
  </blockquote>
  
  <p>What can I do to fix this?</p>