TM1NEWUSER wrote: ↑Wed Jan 13, 2021 4:35 am
You are also probably right that it is probably an authentication issue - unfortunately there is limited knowledge about TM1 within our company.
Just to be clearer about that... I'm talking about
SQL Server authentication, not TM1 Authentication.
TM1 authentication regulates access to TM1 objects only. It doesn't have any impact on data sources.
I don't know whether you're using Windows Authentication or Mixed Mode authentication on SQL Server, but for something like this I expect it would be Mixed Mode; that is, where you specify a login and password for the connection. (It doesn't
have to be, but I suspect that it's more likely than not.)
If you are looking at the query in Management Studio, you will probably be logged in under your own login rather than the one that has been assigned to the TM1 server.
YOUR login in SSMS may well have access to table or view DB4, but it doesn't automatically follow that the login that TM1 is using to connect to SQL Server will have the same permissions. This isn't a TM1 authentication issue; a TurboIntegrator process runs with full Admin rights
on the TM1 side, but
on the SQL Server side it will still only have as many rights as the SQL Server administrator has granted to the SQL Server login that it is using .
Regardless of the security mode on the SQL server side, I'd be taking a stroll over to the SQL Server admin and asking him or her "Does this SQL Server login that TM1 is using have read rights to table / view DB4?"
If the answer is "no", that's where your problem is.