How to Configure MSSQL Connections Using Windows Authentication in Appian?

Is it possible to create MS SQL Server connections in the standalone.xml file that use integrated (Windows) authentication to connect to the server from JBoss when running on Linux?

  Discussion posts and replies are publicly visible

Parents
  • I can't recommend pursuing this.
    I don't think it's possible, but if it were, the proposed configuration would most likely be a customization.

    The proposed configuration also introduces complexity into the design, support, and maintenance of applications. 
    Appian's user security features make it possible to easily control which users have access to database data while using a single set of credentials to access the database.  
    If you were to authenticate to the database per user, it would increase the likelihood that certain application features would not work as designed from time to time. 
    This might be the result of a certain user not having access to a given database resource. 

    Also, Users can access Appian from mobile devices as well as Windows and Mac OS. 
    How should Appian authenticate to SQL server for a user who's accessing Appian from their mobile device?

Reply
  • I can't recommend pursuing this.
    I don't think it's possible, but if it were, the proposed configuration would most likely be a customization.

    The proposed configuration also introduces complexity into the design, support, and maintenance of applications. 
    Appian's user security features make it possible to easily control which users have access to database data while using a single set of credentials to access the database.  
    If you were to authenticate to the database per user, it would increase the likelihood that certain application features would not work as designed from time to time. 
    This might be the result of a certain user not having access to a given database resource. 

    Also, Users can access Appian from mobile devices as well as Windows and Mac OS. 
    How should Appian authenticate to SQL server for a user who's accessing Appian from their mobile device?

Children