KNOWLEDGE BASE

Error "Invalid username or password" Connecting to Microsoft Analysis Services


Published: 21 Aug 2014
Last Modified Date: 25 Apr 2016

Issue

When opening a workbook published to Tableau Server with a Microsoft Analysis Services connection, a prompt for login credentials might appear and no login credentials are accepted.

Or, in Tableau Desktop, the following error might occur when connecting to Microsoft Analysis Services:

Invalid username or password.

Additionally, the following error can be located in the Tableau Desktop logs:

MSG throw DataSourceException (type=BadPassword): Analysis Services database error 0x80004005: The peer prematurely closed the connection.

Environment

  • Tableau Server
  • Tableau Desktop
  • Microsoft Analysis Services (MSAS)

Resolution

Configure firewall to allow the computer running Tableau Server and/or Tableau Desktop to connect to MSAS.

Cause

A networking or firewall issue is blocking the computer running Tableau Server or Tableau Desktop from connecting to Microsoft Analysis Services.
Did this article resolve the issue?