Tuesday 15 February 2011

excel - SSAS 2005 The peer prematurely closed the connection RANDOMLY -


SSAS 2005, which was working fully for years, is now working oddly.

After a windows update, depending on the selected client, it throws random errors when it comes to both OleDb and AdoMD.NET drivers.

Here's what I got here

OleDbException (0x80004005): There was an error in the transport layer.
Peer closed the connection prematurely

First broke my SPN in Windows Update, so I had to fix it with the Kerberos configuration manager for SQL Server. Authentication back to the SQL Server Profiler (no more loans on the NTUserName column)

But exceptions, after installing the connection and some successful browsing in Excel seems completely random!

  • Depending on the selected members, Excel 2007
  • Excel 2013 based on selected members (except those in Excel 2007)
  • Website
  • Correcting
  • Fixing Excel 2007 on the server

When I Work Use the SQL Server Profiler on the MDX, there is nothing special in it.

Discovery Starts 4 - MDSCHAMAmbs
Discovery and 4 - MDSCAKMKBIS - Query Start 0 - MDXQuery
Query & 0 - MDXClite

And when I select a specific area (which is the cause of exception)

Discovery starts 4 - MDSCHEMA_CUBES
Search end 4 - MDSCHEMA_CUBES
Audit logout

Cubes are working, have they not changed for years any ideas?

SQL 2005: SP4
Windows Server: 2008R2
Both clients and servers on the same domain.


No comments:

Post a Comment