Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server “TABULAR”

Eugene Niemand
Jun 25, 2015 · 2 min read

Description

When querying a SSAS instance using a linked server on a remote server while the same user also have a RDP session (Active/Inactive) to the same remote server using SSMS or any other method for ex SQL Unit Tests this error is produced:

OLE DB provider "MSOLAP" for linked server "TABULAR" returned message "The following system error occurred: ".Msg 7373, Level 16, State 2, Line 1
Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "TABULAR".

Microsoft Connect Item

Please vote on this connect item if you experience the same https://connect.microsoft.com/SQLServer/feedback/details/1470258

Steps to Reproduce

The setup consists of 3 different machines:
LOCALHOST (LH)
REMOTE SQL SERVER (RSQL)
REMOTE SSAS SERVER (RSSAS)

Ensure that you don’t have a RDP session (active/inactive i.e. disconnected) to RSQL
Create Linked Server to RSSAS on RSQL using a domain service account for security context as below

exec master.dbo.sp_addlinkedserver @server = N'TABULAR', @srvproduct=N'', @provider=N'MSOLAP', @datasrc=N'RSSAS\tabular_2012', @catalog=N'GroupDW'
exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TABULAR',@useself=N'False',@locallogin=null,@rmtuser=N'domainX\builduser',@rmtpassword='SomePassword'

Now execute an open query from LH SSMS on RSQL for example:

select
*
from
openquery (TABULAR, 'EVALUATE SUMMARIZE (''#Loan Process'', ''~Data Source''[Source System], "Agreed Final Loan To Income Ratio",[Agreed Final Loan To Income Ratio])')

You get the results back from SSAS as expected

Login to RSQL via Remote Desktop to create a RDP Session
Now execute same query as before

OLE DB provider "MSOLAP" for linked server "TABULAR" returned message "The following system error occurred: ".
Msg 7373, Level 16, State 2, Line 1
Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "TABULAR".

Eugene Niemand’s Blog

Technology and Programming professional and enthusist

Eugene Niemand

Written by

Lead Data QA Engineer at ASOS.com - I have a passion for Test Driven Development, Agile Methodologies, Continuous Integration and Delivery using Microsoft Azure

Eugene Niemand’s Blog

Technology and Programming professional and enthusist

Eugene Niemand

Written by

Lead Data QA Engineer at ASOS.com - I have a passion for Test Driven Development, Agile Methodologies, Continuous Integration and Delivery using Microsoft Azure

Eugene Niemand’s Blog

Technology and Programming professional and enthusist

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store