This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would there are three possible reasons for this error:
1) SQL Server is actually generating incorrect TDS. 2) Something crashes inside SQL Server, and the connection is broken. 3) A network glitch.
The fact that the error is intermittent to some extent rules out the first. It does certainly not rule out network problem, as the issue can be a bad cable or similar. Bad does not have to mean completely broken, but contact is only broken when the cable is a certain angle or whatever. It is very common for hardware errors to be intermittent.
You should investigate the SQL Server error log for stack dumps. If you can find stack dumps that coincide with these errors in SSAS, then you know that it is an issue in SQL Server. If there are no stack dumps, I would suspect a hardware problem.