Home Forums Article Discussions Article Discussions by Author Discuss content posted by Martin Cremer Reporting Services: Read Data from SSAS and SQL Server in One Dataset RE: Reporting Services: Read Data from SSAS and SQL Server in One Dataset

  • June 11, 2009 at 5:07 am

    #1007900

    Hi Martin,

    As i posted here Problem with linked server,

    I have problem with the linked server, it work fine but from time to time I get this error

    "Cannot create an instance of OLE DB provider "MSOLAP" for linked server "SALES_CUBE". (Microsoft SQL Server, Error: 7302)"

    restarting the SQL fix the problem' but this times i have to restart SQL on a daily base.

    Any advice?

    Kupy