Yes, you can set up a linked server but first, you need to create an ODBC connection.

  1. Create an ODBC connection
  2. Open SQL Server Management Studio
  3. Create linked server using other data source
  4. Select provider: Microsoft OLE DB Provider for ODBC Drivers
  5. Select Product name: same as the ODBC connection name
  6. Select Data source: same as the ODBC connection name
  7. Under Security tab select option “Be made using this is security context”
  8. Enter remote login with password

then  select top 1 * from [linked server name]..[schema name].[table name]