TM1 Forum

Hi,

We have setup ODBC Connector for SQL using DNS Configuration. And for each SQL server TM1 connects to a SQL user account is created in each server.

We want to simplify account administration by creating an Active Directory (AD) service account. However we couldn't establish the connection, SQL log told us that the user account includes the TM1 server name instead of the Active Directory service account. For example, say our active directory name is "ABC" and our TM1 server is "abc-tm1" then the SQL server reports user name as "ABC\abc-tm1".

Does TM1's ODBC works with AD service account? If so, how should DNS and TI be setup to work with AD service account?

Thanks a lot!

What account does the TM1 service run under? In order to use Windows Authentication for your SQL server connections in TM1 the TM1 service must run under that account. It cannot run under the local system account. Also, the ODBC setup on the TM1 server must be set to use Windows Authentication. If you have it set up this way then you do not have to enter the User ID and password in the TI process Data Source tab. Just leave it blank.

Thanks! I'll pass this on to our tech team to figure this out.

Kenneth