Problem with linked server

  • 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

  • 🙁

  • 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.

  • 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!!!

  • Hi,

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

  • 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