AMAG JDBC

AMAG JDBC

jdbc:sqlserver://<Server Name>:1433;databaseName=<dbName>;

For example : jdbc:sqlserver://425P-ACS-SR01v:1433;databaseName=multiMAXImport;


To change this:
  • Login to PassagePoint desktop client with admin rights
  • Navigate to home >configure system > External Systems > Access Control System > Select and edit the configured AMAG(JDBC configuration)
  • Change the JDBC server url in following format : jdbc:sqlserver://<Server Name>:1433;databaseName=<dbName>;
  • For example : jdbc:sqlserver://425P-ACS-SR01v:1433;databaseName=multiMAXImport;
  • Save the changes
  • Restart the PassagePoint services

    • Related Articles

    • Directory Link - CCURE 9000 JDBC lookup example

    • Migrate Data Source to SQL Server

      To migrate to SQL: 1. Have SQL DBA create a clean database on SQL Server. Have DBA create a user with DBO rights to the database, and get the username/password (SQL authentication) from the DBA (database administrator). 2. In Database tools => select ...

    • Using windows authentication for SQL server

      To use Windows Authentication,  add service account to "PassagePoint Server" services The account used to start the passagepoint service is the account used to connect to SQL server The SQL context file will need to contain the following string: ...

    • How to connect to Microsoft SQL database and encyrpt user password

      Note: For windows authentication see KB article https://support.stopware.com/portal/en/kb/articles/sqlcontext-for-windows-authentication For SQL Authentication see instructions below. If TLS is required, see attachements. 1) Create a clean database ...

    • How to set up passagepoint to talk to an encrypted SQL server DB

      When Data at rest is required to be encrypted, STOPware recommends using SQL server, and using native SQL server data encryption. Once that is done on the SQL server side, on the passagepoint side, pls see attached sqlcontext.xml on how to configure ...