June 11, 2009 at 2:52 am
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
🙁
July 16, 2009 at 11:56 pm
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
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
Hi,
Sorry for the late response, at my case the Allow InProcess was enabled on creation.
March 20, 2011 at 9:00 pm
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