ssis - Failed to connect Analysis Services using linked Server

Question

I have a Database Server and Analysis Server hosted in the same server itself(Lets say Server1).

I want to create a Linked Server from my database(Server1) and connect to the Analysis Server(Server1).

I have created a linked Server with below details-

ID -Microsoft Provider for OLEDB Provider for Analysis Services 14.0 Data Source-Server1/instance Intitial Catalog- A cube db.

Security to be made using security context- Service account ID/pass,which has access in both servers.

But I am getting the below message while establishing connection.

**TITLE: Microsoft SQL Server Management Studio

The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?

---

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

---

Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "Server1". OLE DB provider "MSOLAP" for linked server "Server1" returned message "An error was encountered in the transport layer.". OLE DB provider "MSOLAP" for linked server "Server1" returned message "The peer prematurely closed the connection.". (Microsoft SQL Server, Error: 7303)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.2014&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476

---

BUTTONS:

&Yes &No

**What could be the possible reasons behind the failure.

question from:https://stackoverflow.com/questions/65516702/failed-to-connect-analysis-services-using-linked-server

Answer 1

Waitting for answers