Post reply

Cannot start a transaction for OLE DB provider "MSOLAP" for linked server

  • July 3, 2014 at 4:00 am

    #309739

    Hi All

    Server1 (SQL Server 2008R2):

    Cannot start a transaction for OLE DB provider "MSOLAP" for linked server "LINKED_OLAP"

    is the message I'm given when running a SP from Application (c#) code. When i run the SP from SSMS, it executes successfully.

    Server2 (SQL Server 2012):

    It executes successfully from SSMS and Application.

    Configuration for provider MSOLAP is same on both servers.

    LINKED_OLAP is same defined on both servers.

    All protocols are enabled on both servers.

    Sql server logins are used from the application. Both logins on servers have all privileges over databases.

    I'd appreciate someone gives some experience...

    Igor Micev,My blog: www.igormicev.com

  • July 3, 2014 at 4:22 am

    #1726728

    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

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • July 3, 2014 at 6:36 am

    #1726770

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply