Home Forums SQL Server 2008 Security (SS2K8) Cannot start a transaction for OLE DB provider "MSOLAP" for linked server RE: Cannot start a transaction for OLE DB provider "MSOLAP" for linked server

  • Erland Sommarskog (7/3/2014)


    Apparently, you have a transaction active in your application.

    I seem to recall that I saw somewhere that MSOLAP does not support distributed transactions.

    This should help

    EXEC sp_serveroption LINKED_OLAP, 'remote proc transaction promotion', false

    Thanks for your replay, but unfortunately this didn't help. ... 🙁

    Igor Micev,My blog: www.igormicev.com