Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  SQL server Windows Authentication for TM1 process

    Posted Mon March 08, 2021 11:40 AM

    Is it possible to use Windows Authentication when connecting to an MS SQL server from a PA/TM1 process?

    I have created and tested the ODBC connection at the TM1 server, using the default TM1 server user.
    When I try to use this connection in the TM1 process, then I get prompted for user and pass. 

    How should I configure TM1 for using Windows Authentication?

    Thanks, Asgeir
     




    ------------------------------
    Asgeir Thorgeirsson
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: SQL server Windows Authentication for TM1 process

    Posted Tue March 09, 2021 08:24 AM

    For the SaaS offering, windows authentication is not supported.  

    We've added this note to the product compatibility reports for SaaS for MS SQL Server: "Requires SQL Server Authentication using a login ID and password entered by the user."


    I'll let others speak about how this may be possible for on-premises installs.



    ------------------------------
    Paulo Monte
    ------------------------------

    Original Message


  • 3.  RE: SQL server Windows Authentication for TM1 process

    Posted Tue March 09, 2021 09:09 AM
    HI Asgeir,

    Sounds like you are doing it correctly but just to confirm:
    - Create a SystemDSN for the ODBC connection
    - SQL should verify authenticity using Windows NT authentication
    - User that is set to Logon As on the TM1 instance should be give necessary access in SQL

    On the TM1 side, the TI should have Username and Password: as blank as they are not necessary.

    That should be it if memory serves.

    ------------------------------
    George Tonkin
    ------------------------------

    Original Message


  • 4.  RE: SQL server Windows Authentication for TM1 process

    Posted Tue March 09, 2021 11:23 AM
    Hi,
    If you want the TI to run as part of a chore, then the TM1 Server service has to be setup to login with a user name and password.  This account will be used when the chore connects to the ODBC connection.

    What security mode are you using?  You need to be using a mode that validates the TM1 login against the Windows system.

    ------------------------------
    Scott Brown
    ------------------------------

    Original Message


  • 5.  RE: SQL server Windows Authentication for TM1 process

    Posted Tue March 09, 2021 03:50 PM
    Yes it's possible. In fact if the Odbc connection validates correctly, using the same credentials within the TI process should work. If you don't want to be set credentials for each process, you'll need to create an Windows (service) account to run the planning analytics database service. Once you've assigned an account to the service which also has access to the tables in SQL, restart the planning analytics database service and the process should automatically connect.

    Fyi if you don't already have an account assigned to run the service, you may want to consider setting the password to not expire, otherwise if it does expire, the service will fail to start until the password is updated.

    ------------------------------
    Simon Saul
    ------------------------------

    Original Message


Related Content