Get Data Moving 1
Results 1 to 2 of 2

Thread: Fail to user Azure SQL DB as source

  1. #1
    wolfchan is offline Junior Member
    Join Date
    Nov 2017
    Posts
    2
    Rep Power
    0

    Question Fail to user Azure SQL DB as source

    Hi All,
    I am currently having issue to use Azure SQL DB as source, same DB use as target no issue.

    When configure as source, click "Test Connection", will having below error message

    • SYS-E-HTTPFAIL, Request failed. Application status is RetCode: SQL_ERROR SqlState: 42S02 NativeError: 208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.servers'. Line: 1 Column: -1 [122502] ODBC general error.


    If ignore "Test Connection" error, use it as source. When click "Table Selection", will having below error message

    • SYS-E-HTTPFAIL, Request failed. Application status is Command get_owner_list failed when creating the stream component. [122517] Table error.

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Microsoft Azure SQL DataWarehouse
    Microsoft Azure SQLDatabase

    are only support for Target not source.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •