When connecting to an SSAS 2012 tabular model from Excel 2013 (Data... From Other Sources... From Analysis Services... fill in Server Name... click Next), I get the error:
An error was encountered in the transport layer.
Excel, SQL Server, and SSAS are all running on the same server (Windows Server 2012).
Because the server needs to be accessed from the Internet, there is a DNS entry for the server
x.mydomain.com but the server's actual Windows computer name is something else
In the Excel (on the server's desktop) connection dialog, if I use
servername it works without error. If I use
x.mydomain.com I get the above error.
I have added a hosts file entry so that
x.mydomain.com points to "::1". From the server, pinging
servername both return the same "::1" for the address. This did not help the problem.