Views in SQL can span many databases. For example, if the view resides on Database A but the view is created from a table on A and a table on B then you need privileges for both databases Hope this helps out!
We are using 2 SQL servers for our work with Tableau. TablSQL01 sever is for our data and Tablwb01 is for Tableau Server (Publishing / Website). I can access my data from Tableau Desktop and even publish. The problem is that I can't open the published report in the Tableau site / Tableau Server. This is very odd to me. Wandering is this could be setting?