Home > Ole Db > Cannot Initialize The Datasource Object Of Ole Db Provider Msolap For Linked Server

Cannot Initialize The Datasource Object Of Ole Db Provider Msolap For Linked Server

Contents

If the logged in user is a SQL login, then provider is initialized under SQL Server service account. Add “Authenticated Users” and grant them all 4 launch and activation permissions. Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 24 Apply the new permissions. have a peek here

You cannot send emails. You cannot post or upload images. You cannot send private messages. When the provider is instantiated outside the SQL Server process, updates or inserts referencing long columns (text, ntext, or image) are not allowed. -- Linked Server Properties doc for SQL Server

Cannot Initialize The Datasource Object Of Ole Db Provider Msolap For Linked Server

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation I don't remember exactly, but 1 or 2 of the instances on the problem box may have been upgraded from 2008 to 2008 R2 at some point. Hot Network Questions output garbled when running "xargs ls" in parallel Is every parallelogram a rectangle ?? You cannot post EmotIcons.

You cannot edit your own events. sql-server oracle oledb windows-authentication linked-server share|improve this question edited Nov 21 '13 at 14:10 patrickmdnet 2,3481727 asked Jan 24 '13 at 11:14 th1rdey3 2,08941647 I am trying to run Wednesday, November 19, 2008 7:23 PM Reply | Quote 0 Sign in to vote Some answer?Carlos Mosquera Wednesday, April 01, 2009 8:50 PM Reply | Quote 0 Sign in to vote Msolap Driver How much effort (and why) should consumers put into protecting their credit card numbers?

My openrowset syntax is as given below.select * from openrowset('MSOLAP', 'Datasource='datasource'; Initial Catalog= 'cubedb','SELECT {my mdx query}')it works just fine. You cannot post replies to polls. It feels like something is awry in the registry. (I'm asking for direction first, as I can't perform any maintenance myself due to lack of permissions.) sql-server sql-server-2008-r2 linked-server share|improve this Close out of “dcomcnfg”.

Lynn Please mark replies that have helped you as answers. ‹ Previous Thread|Next Thread › This site is managed for Microsoft by Neudesic, LLC. | © 2016 Microsoft. Msolap.dll Download Then you can create the linked server. share|improve this answer edited Oct 1 '15 at 19:52 answered Jan 24 '13 at 12:28 David Brabant 18.8k64371 2 Brabank, I already tried that, but it still shows the same You cannot post topic replies.

Msolap.5 Download

asked 3 years ago viewed 14677 times active 7 months ago Linked 1 Get Results from DMV Query into SQL Server Table Related 4Access Linked Server error “The provider did not share|improve this answer answered Jun 5 '13 at 18:19 Matt Anderson 6111 it's dcomcnfg - drop the i –GilesDMiddleton Jan 14 at 11:59 In step 7 I Cannot Initialize The Datasource Object Of Ole Db Provider Msolap For Linked Server up vote 3 down vote favorite Here's the code I'm using to register a linked server to SSAS: USE [master]; GO EXEC master.dbo.sp_addlinkedserver @server = N'ServerAlias', @srvproduct = N'', @provider= N'MSOLAP', Msolap Provider Is Not Registered Privacy Policy.

But if I modify a formula of a calculated member which is part of my MDX query , it throws the error as given below. navigate here You cannot edit other posts. asked 2 years ago viewed 7158 times active 2 months ago Linked 1 routine to backup ssas databases fails with: The XML for Analysis request timed out before it was completed Close out of “regedit”. The Ole Db Provider Msolap Has Not Been Registered

Rate Topic Display Mode Topic Options Author Message csplrjcsplrj Posted Wednesday, April 30, 2008 8:44 AM Forum Newbie Group: General Forum Members Last Login: Friday, June 12, 2009 4:13 AM Points: This MSDN blog post describes the reason: MSDAINITIALIZE is a COM class that is provided by OLE DB. On the “Security” tab, select “Customize” under “Launch and Activation Permissions”, then click the “Edit” button. Check This Out You cannot delete other topics.

But when I run the simple select: SELECT CATALOG_NAME FROM OPENQUERY([BIREPLON1], 'SET FMTONLY OFF;SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS') as Radhe I get this error message: Msg 7303, Level 16, State 1, Line Analysis Services Ole Db Provider For Sql Server 2012 Does gunlugger AP ammo affects all armor? Close out of “dcomcnfg”.

Alternatively, hack the InprocServer32 location.

After many hours of messing around, I managed to fix the problem using the following steps: Run “dcomconfig”. In the future, there will be an Office XP and Office 2003 update that you can use to update the provider that Excel uses. This is pretty strange as this provider is installed as part of SQL Server. Msolap Sql Server 2014 How to block Hot Network Questions in the sidebar of Stack Exchange network?

You cannot post events. Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud Would a Repair fix this? this contact form Just re-registering alone didn't solve the problem, I had to delete the registry keys to make it point to the correct location.

You cannot edit your own topics. share|improve this answer answered Jan 14 at 12:27 GilesDMiddleton 1,3911219 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up Not the answer you're looking for? Here it is 4.2.3 Analysis Services 9.0 OLE DB Provider May Be Overwritten By Client Applications If you install Excel (or any other client application) after installing Microsoft SQL Server 2005

You cannot delete other posts. When i am trying to test the connection  for the linked server it says.."Cannot create an instance of OLE DB provider "MSOLAP" for linked server "GDM_FOREX""  i am using  MSOLAP provider If that's the case, or you can't find that string in the registry, then you'll have to install or re-register the component. You may download attachments.

You cannot upload attachments. Examples follow (your file locations may vary): C:\>regsvr32 "C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130\msolap130.dll" C:\>regsvr32 "C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll" And if you are using a 64-bit OS: C:\>regsvr32 "C:\Program Physical file: . You cannot post IFCode.

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Every other instance of this error I found on the internet was due to someone incorrectly defining the linked server, which also isn't applicable. Edit I have tried this on two machines running Windows 7 x64 & Windows Server 2008 x64 with MS SQL Server 2008 x64. I have installed Analysis Services 9.0 OLE DB Provider, as Vadim suggested and the problem has been fixed, I did not even need to restart the MS SQL Server service.  

I just don't understand the reason.