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 Appian 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.
To configure Windows Authentication:
1) Remove the lines for username and password from tomcat-resources.xml.
2) Modify the URL to include "integratedsecurity=true" like so: url="jdbc:sqlserver://<host_name>:1433;databaseName=<database_name>;integratedSecurity=true"
"integratedsecurity=true"
url="jdbc:sqlserver://<host_name>:1433;databaseName=<database_name>;integratedSecurity=true"
3) Add the SQL Server driver sqljdbc42.jar to <Appian_Home>\tomcat\apache-tomcat\lib\
<Appian_Home>\tomcat\apache-tomcat\lib\
4) Add sqljdbc_auth.dll to <Appian_Home>\tomcat\apache-tomcat\bin\
5) Start Tomcat.