3 Replies Latest reply on Jan 24, 2017 4:09 AM by Allen Gapara

    Permission to view tables without permission to view Database

    Allen Gapara

      I would like your help in connecting to data source. I have lost and cannot connect Tableau to the data source. I am connected to the server but can not connect Tableau to data source. This started because of some security update. I have lost my permission to view the SQL Database but still have permission to view  tables, fields and data via queries. To verify that, In Management Studio, I run


      SELECT * FROM <database><dbo><database name>


      and I can get data even though, I cannot see the Database. I have tried the following to try to connect:



      On Server


      <server Address>, <port number> <Database name>


      tick Require SSL


      Then OK to get connected


      This is as far as I got. My question is, Is there a way to access the tables without Databases in view. Thanks for reading, your help will be appreciated.