Integrity Advanced Server Installation Guide
11
7. Record the database username and password for the Integrity Advanced Server.
To configure SQL Server:
1. Create your database.
2. Record your database server host name.
3. Record your database port for connections with the Integrity Advanced Server.
4. Create a database login.
The database login must have the following roles:
public
db_owner
ddl_admin
db_datareader
db_datawriter
5. Create the Integrity Advanced Server database names.
The preconfigured database name in Integrity Advanced Server is iss_main.
6. Use the Enterprise Manager (found in the properties for the server instance) to set
your authentication types.
In order for the JDBC drivers to log in correctly, your SQL Server security must be
set up to handle both SQL authentication and Windows authentication (Mixed
Mode). The JDBC drivers use a SQL authenticated user and password and will not
be able to connect if SQL Server is configured for Windows security authentication
only.
7. Set the recovery model to simple.
By default, SQL Server Enterprise uses “FULL” recovery mode. This means that all
transactions are logged until the database is backed up. This requires a log file
that is at least as large as the database file. As an alternative it is recommended
that you set the SQL Server recovery mode to Simple. Setting the recovery mode to
simple truncates the log at certain intervals. Be aware that if you choose to set the
Use a host name rather than an IP address to specify your database. This allows you
to later change your database.
The database login must not have the system administrator role.