DatasourceUsername and DatasourcePassword

Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 2180
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

DatasourceUsername and DatasourcePassword

Post by Steve Rowe » Fri Mar 20, 2020 5:24 pm

This is on PA 2.0.3

We've been having major issues with the account we use to query SQL (via ODBC) getting locked in one of our overnight jobs, causing all kinds of downstream issues.

In the process of tinkering with this to put some protection in place we established that no matter what we put in as DatasourceUsername and DatasourcePassword a query always ran successfully. We established that the query is running with the account the TM1 service is running under rather than the credentials we supply. (These are both the same normally, as is common practice(?))

Once we restarted the service with the Local System account we couldn't get anything to work, even using the correct credentials on the face of the TI.

I'm assuming this is a bug in the release we are on but has anyone seen this before?

Happy Fridays!
Technical Director

Posts: 1712
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom

Re: DatasourceUsername and DatasourcePassword

Post by declanr » Fri Mar 20, 2020 10:49 pm

At 1 of my previous clients the DSN we used was set to use windows authentication (somehow not quite sure how) so with that 1 we just provided the DSN name without user or password and it took it from the system account that was running the service. Sounds like the set up you have could be similar?
Declan Rodger

Posts: 13
Joined: Mon Mar 09, 2015 11:54 pm
OLAP Product: TM1
Version: 9.1 to 10.2.2
Excel Version: Office 2010

Re: DatasourceUsername and DatasourcePassword

Post by a1m80t » Thu Mar 26, 2020 9:22 pm

1. The service id used to start TM1 can be use for Windows Authentication to your ODBC data source. This is automatically done if you do not put a username and password in the TI Process and if your ODBC Data Source has Windows Authentication enabled for your TM1 service ID. BTW, by setting the service ID to Local System, you are basically turning this off

2. Regardless of what service id use use, you can manually input the ODBC Data Source user name and password in the TI Process. This only works if your ODBC Data Source has enabled standard user id/passwords for the user id you are using.

I've used both methods extensively on many version of TM1. My guess is that while the TM1 Service ID and ODBC user name are the same but the passwords are different... or the user id is simply blocked from too many failed attempts.

Post Reply