This article explains how to configure your Asset Bank so that it connects to a SQL Server database using a Windows account (using Integrated Windows Authentication). You might want to do this to avoid having the database user credentials in Asset Bank's components.xconf file.
Note:For Asset Bank's updater to run successfully the user needs to be one with db_owner access to Asset Bank's SQL Server database.
2. Download the latest jTDS driver package and, depending on your server's OS, extract either the 32bit or 64bit ntlmauth.dll file from the respective directory within the zip file and place the file anywhere in the system path (defined by the PATH system variable).
3. Check (or change) the Tomcat service so it is runs as the Windows user account you want to use to connect to the database. Make sure this user has sufficient permissions on the Tomcat directory and on all the executables that Asset Bank needs to run.
4) Grant this Windows user permission to access the SQL Server database as follows:
In SQL Server Management Studio, go to Security->Logins and create a SQL Server login for the user.
In SQL Server Management Studio, right click on the [DOMAIN]\[user] login you've just created, go to User Mapping and grant db_owner permission on the relevant database. Alternatively, grant the user the following roles: db_datareader, db_datawriter, db_ddladmin and public.
5) Restart the Tomcat Service for the changes to take effect.