Page Comparison

RMsis requires it's own independent database. This section contains instructions for setting up all the supported versions of Databases.

...

1. Windows Authentication mode
   • If you want to connect RMsis with Microsoft SQL Server database using windows authentication mode, 
     • then leave the username and password fields blank while configuring RMsis database during RMsis installation.
     • Make sure that the logged in user of windows machine (on which RMsis server is running or will run) has required credentials for RMsis database.
     • Download the SQL Server JDBC driver (v1.2.4) from JTDS and place the ntlmauth.dll (shipped with jtds driver) file in the system path
2. Mixed Authentication mode (SQL Server and Windows Authentication mode)
   • Choose this option, when
     
     • you wish to explicitly configure username and password for Microsoft SQL Server.
     • RMsis is running on Linux, and you wish to use SQL Server on a different node.
   • When this option is chosen, username and password are required during.RMsis configuration.

Connecting RMsis to named instances in SQL

...

Server

When using named instances in SQL Server, the following configuration can be used in RMsis Database Configuration (after performing the actions specified in above sections) :

...

Connecting RMsis to Oracle

...

Supported Version(s)

Currently, RMsis supports Oracle 11G and later versions.

Database Setup using Oracle

• Ensure that you have a database instance available for RMsis (either create a new one or use an existing one).
• Within that database instance, create a user which RMsis will connect as (e.g. rmsisuser).
  • create user <rmsisuser> identified by <user_password> default tablespace <tablespace_name> quota unlimited on <tablespace_name>;
  • Notes :
    • When you create a user in Oracle, Oracle will create a 'schema' automatically.
    • When you create a user, the tablespace for the table objects must be specified.
• Ensure that the user has the following permissions:
  • grant connect to <rmsisuser>;
  • grant create table to <rmsisuser>;
  • grant create sequence to <rmsisuser>;
  • grant create trigger to <rmsisuser>;

Database Configuration for Oracle

...