title: Cross Server Select In SQLAlchemy
body: <p>Is it possible to make SQLAlchemy do cross server joins?</p>
  
  <p>If I try to run something like </p>
  
  <pre><code>engine = create_engine('mssql+pyodbc://SERVER/Database')
  
  query = sql.text('SELECT TOP 10 * FROM [dbo].[Table]')
  
  with engine.begin() as connection:
      data = connection.execute(query).fetchall()
  </code></pre>
  
  <p>It works as I'd expect. If I change the query to select from <code>[OtherServer].[OtherDatabase].[dbo].[Table]</code> I get an error message <code>"Login failed for user 'NT AUTHORITY\\ANONYMOUS LOGON"</code></p>