Post reply

Problem with linked server

  • June 11, 2009 at 2:52 am

    #131746

    Hi,

    I'm using linked server to SSAS that running on same machine.

    usually the linked server is working just 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 till the next time.

    Any suggestions?

    Kupy

  • June 15, 2009 at 12:58 am

    #1009492

    🙁

  • July 16, 2009 at 11:56 pm

    #1026017

    Hi all,

    i am also facing the same problem..

    when i moved script for linked server creation from dev touat enviroment , after changing the server name as per uat script runs but when i try to check the connection it says "Cannot create an instance of OLE DB provider "MSOLAP" for linked server " please helpme if any one has a solution to this problem.

  • July 17, 2009 at 2:22 am

    #1026053

    Have you tried setting the AllowInProcess property for the provider you are using

    EXEC master.dbo.sp_MSset_oledb_prop N'xxxPROVIDERxxx', N'AllowInProcess', 1

    or

    Server Objects | Linked Servers | Providers | Right-click on a provider, and select Properties. Enable the Allow InProcess property.

    TEST IT FIRST!!!

  • July 28, 2009 at 12:30 am

    #1030859

    Hi,

    Sorry for the late response, at my case the Allow InProcess was enabled on creation.

  • March 20, 2011 at 9:00 pm

    #1301100

    got any resolution for this..i am also facing this issue from long time back pls suggest resolution.

Viewing 6 posts - 1 through 5 (of 5 total)

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