I would think that you would need access to the database. That Tableau connector shows that you're connected to the Server, then you'll have to select a database to pull the tables from. If the credentials that you're using to log into the Server don't have permissions to view the databases, I'm not sure that they'll populate in the drop down for you to select since it's using the permission that are granted to the credentials that you're using.
Above the "Connected to Microsoft SQL Server" is the name of Database in the form of
<server Address>, <port number> <Database name>
(I have removed the server address, port number and database from view) I thought with those credentials, it might be able to show the table(s). I am having resistance in having my database view permissions reinstalled.Now I just want a definite answer whether it can or cannot be done.
Thanks for your help.
It can not be done. You will need permission to view the database otherwise you get nothing.