I have a Cube which is hosted on Server1.
Then, in SSMS I do this: Right click -> Script Database As -> Create to -> New Query Editor Window. Then copy resulted XMLA. Then open XMLS query window on Server2, paste, run. Cube copied.
I right click Cube on SSMS and click process. Here is the error:
OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001.
What am I doing wrong?