I create a dashboard that uses various MS SQL Server data sources (generally materialised views). I authenticate using a specific username and password (rather than Windows Authentication).
I publish the workbook and go along my merry way.
But when I come back a couple of days later to edit the workbook, I open it from the published location. And it gives me the following error:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'tableau'.
Does anyone know why this might be happening?