Error code = 80004002 No such Interface Supported RRS feed

  • Question

  • Hello All,

    Iam  getting this  Error "No such Interface Supported"   when iam trying to access multiple clients remotely to SQL Server2008Ri.

    Error Message:

    Error code = 80004002 No such Interface Supported


    * Iam able to connect one client and I can run the applliaction remotley.

    * Iam working  on VMware ESX Mahines.

    Any ideas on this problem ?

    • Changed type ArthurZ Thursday, January 3, 2013 7:32 PM revised to reflect the thread intedt
    • Moved by ArthurZ Thursday, January 3, 2013 7:32 PM Not related to SSIS (From:SQL Server Integration Services)
    Thursday, January 3, 2013 6:17 PM


  • lpsStatement;provider=SQLNLI10;Server=Esxsql2008;Database=Sec;DataTypeCompatiabilty=80;MARS...SE_ON_COMMIT=OFF;

    DataTypeCompatiabilty=80 OLE DB clients will connect using the SQL Server 2005 tabular data stream (TDS) version, rather than the TDS version. This means that for SQL Server 2008 and later data types, down-level conversion will be performed by the server, rather than by SQL Server Native Client. It also means that the features available on the connection will be limited to the SQL Server 2005 feature set. Attempts to use new datatypes or features are detected as early as possible on API calls and errors are returned to the calling application, rather than attempting to pass invalid requests to the server.

    Below is the reference article which might help.


    SQLHarry Blog

    Thursday, January 3, 2013 9:34 PM