Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 servername.

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 x.mydomain.com or servername both return the same "::1" for the address. This did not help the problem.

share|improve this question
    
    
If you start a profiler trace on the tabular instance and then and then try to connect via excel, is the NTUsername field your actual NTUsername or Anonymous Logon? –  brian Aug 6 '13 at 20:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.