November 22, 2010 at 8:51 pm
I have linked server setup from sql 2005 to ssas 2005/2008. If i RDP into the server,linked server test connection works fine and i am also able to use it.When i run the same query from local client i am not able to use the linked server and not able to do a test connection. Mentioned below is the config for linked server
i) allow in process is enabled( i have tested this by disabling also..doesnt work)
ii) ssas and sql server are same under same domain account with sa priviledge
iii) I am using my windows account to connect.
iv) error is :OLE DB provider "MSOLAP" for linked server "LINKED_OLAP" returned message "An error was encountered in the transport layer.".
OLE DB provider "MSOLAP" for linked server "LINKED_OLAP" returned message "The peer prematurely closed the connection.".
Please read the complete post before giving suggestions as i have tried almost all the one's online. Thanks
August 8, 2011 at 2:39 pm
Did you get an answer to this problem, or figure out?
August 9, 2011 at 8:31 am
Not sure if i was able to resolve this or not, i think my AD account was locked out when i doing this test. Are you facing similar issue?
August 9, 2011 at 9:23 am
Yes. I've been thinking it is a permissions issue. I'm going to check that out this morning.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply