You are currently reviewing an older revision of this page.
There are 2 types of authentication for SQL Server: SQL Authentication and Windows Authentication. Windows Authentication is sometimes referred to as Integrated Authentication.
Windows Authentication will use the same user who started the application server to log into SQL Server.
SQL Authentication uses a plain text username and an encrypted password in tomcat-resources.xml to authenticate when connecting to SQL Server.
Note: This Knowledge Base article should be used for guidance purposes only. Additional information regarding the instructions in this article should be discussed with a Server Administration and Database Administration teams.
To configure Windows Authentication:
"integratedsecurity=true"
url="jdbc:sqlserver://<host_name>:1433;databaseName=<database_name>;integratedSecurity=true"
<Appian_Home>\tomcat\apache-tomcat\lib\
<APPIAN_HOME>\tomcat\apache-tomcat\bin\
This article applies to Appian 18.4 and later.
Last Reviewed: May 2019