Tableau can easily connect to #SQLAzure, but there’s one tiny catch – it appears we (Tableau) may need to read something in SQL’s master database during the connection process. Quite often your friendly DBA may not have explicitly added YOUR login as a user in that database.
For example, this blog entry shows how to add users to a database in SQL Azure:
http://blogs.msdn.com/b/sqlazure/archive/2010/06/21/10028038.aspx
…note how the user in question is only being added to the database they should have access to? Makes sense, as we don’t expect to have normal users spellunking around in master.
However, if you don’t also add the user to master, the following error will occur (For Google: “Invalid username and password”):
While your friends and loved ones may be highly amused as you enter a CORRECT username and password over and over again, begin turning red, and then dropping F-bombs, here’s the solution – get your admin to add you as a user to master. To be clear, you don’t even need to be added to a SQL Server Security role (like db_datareader) which enables to you to see stuff – you just need to be a user:
CREATE USER Tableau FROM LOGIN Tableau;
Happy Azure-ing!