I have the following scenario:
- Data Sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database.
However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error:
"Unknown error: The SELECT permission was denied on the object 'table_name', database 'database_name', schema 'dbo'..."
Using SSMS the server where the SQL is installed, I can SELECT the data from the tables.
What could be wrong?
Thank you in advance for your help,