ODBC Connector For SQL Server Using Active Directory Service Account

Post Reply
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

ODBC Connector For SQL Server Using Active Directory Service Account

Post by kenship »

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!
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: ODBC Connector For SQL Server Using Active Directory Service Account

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: ODBC Connector For SQL Server Using Active Directory Service Account

Post by kenship »

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

Kenneth
Post Reply