![]() ![]() Microsoft SQL Server support logins using password authentication or operating system authentication. These services are: dispatcher, aserver, eserver. The main AXM/ClearTrust services need to be configured to run under the Windows Domain Account rather than Local Service. Within SQL Server, the Windows Domain Account needs to be placed into the CT_ADMIN_ROLE. Minimum File Permissions required for the Domain Userid on the CleartrustMachine:ĭatabase permissions required for the Domain Userid on the Database Machine: The ClearTrust services will run under this domain account and when they are started, will access the database using the domain account.Ĭ.mssql.jdbc_url:jdbc:JSQLConnect://mydbserver:myport/database=CT/trustedAuthentication=true Windows Domain User Account - Since the ClearTrust server and the SQL Server 2005 may run on different machines, this domain user account will be the account that the database is accessed with rather than the CT_ADMIN SQL Server Account. The DLL with it's driver, which if installed on the client machine, will allow their otherwise-all-java driver to connect the Java application to the DBMS as the current Windows user, without coding or entering any username or password at runtime. This file will need to reside in a folder that is included in the Path environment variable. JSQLTrustedAuthentication.dll file - This file will need to be supplied by RSA in addition to the above. ![]() This file will reside in the AXM\ClearTrust Installation folder under the lib folder ![]() JSQLConnect.jar file - JNetDirect JDBC driver for SQL Server version 5.5 that is supplied by RSA on the AXM 6.0 DVD. The following changes allow Windows Authentication rather than SQL Server Authentication to be used without password or user entered in the sql.conf and the windows services to still be utilized. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |