Hi, I am trying to connect to a SQL server from my computer.
I have done this before (but not from this computer) and I know the basics.
I am using the "Microsoft OLE DB Provider for SQL Server" and I have all necessary info such as ServerName, UserName and password. The connection works and the OLE DB string is created but once I try to access the database no tables or views are visible or accessible.
I have also tried using ODBC with the same result.
When I try to do the same thing using Xls it works and I can see all of the tables and views in the data base.
Actually, master is a database (at least afaik). Perhaps you've got the wrong database too. A SQL Server instance can have many databases. Perhaps you should ask your local friendly database administrator to help you get connected correctly.
I just had a similar issue in Qlik Sense with the OLE DB connector, and ended up finding help in an old QlikView knowledge base artice (000048672). If the database name contains a period character the connector can end up being confused.
Example Server: sqlserver01 DB name: My.database.name
That confuses the GUI when selecting data from schemas, but if you just insert the connection string and throw an SQL statement it will work just fine.