Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Windows Authentication mode
    • If you want to connect RMsis with the Microsoft SQL Server database using windows Windows authentication mode, 
      • then leave the username and password fields blank while configuring the RMsis database during RMsis installation.
      • Make sure that the logged-in user of the windows machine (on which the RMsis server is running or will run) has the required credentials for the 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, a username and password are required during . RMsis configuration.

Connecting RMsis to named instances in SQL Server

...

  • You can follow the steps mentioned below to securely connect RMsis to a SQL Server database :
    • Switch to the database configuration page RMsis Menu > RMsis Configuration > Database Configuration
    • Select MS-SQL (Microsoft Driver) from the drop-down menu while selecting Database Type.
    • Fill in appropriate values for other fields in the database configuration page (as mentioned above in on this page) and click on the TEST AND SAVE CONFIGURATION page.
      • Please note that it is necessary to configure RMsis using an unsecured connection first.
      • This will create and store the necessary database configuration.
      • Additional parameters for secured connection can be added manually in the later stage.
      • If the MS-SQL server does not support an unsecured connection, the test will fail and settings will not be saved.
        • If this is the case, configure RMsis using internal any other database first.
        • This will create the <JIRA_HOME>/rmsis/conf/jdbc.properties file.
        • Replace the internal database details with MS-SQL database as explained in the next steps.
    • Once the configuration is saved, stop JIRA. This will stop RMsis as well. 
      • Kill all processes related to JIRA / RMsis (they are typically named as Tomcat*, java). 

      • This is important because sometimes stopping JIRA does not terminate all the processes.

      • Detailed description about killing RMsis is available at: https://docs.optimizory.com/x/iA_7

    • Locate <JIRA_HOME>/rmsis/conf/jdbc.properties file.

      • The contents of the file will be similar to:

        db.name=rmsisDbName

        jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

        jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=${db.name}

        jdbc.username=sa

        jdbc.password=sa123

        hibernate.dialect=org.hibernate.dialect.SQLServer2005Dialect

        jdbc.dataSourceClassName=com.microsoft.sqlserver.jdbc.SQLServerDataSource

      • Add the desired additional parameters to the jdbc.url. For example, in order to add HTTPS/ SSL, append ;encrypt=true;trustServerCertificate=true; to the existing URL.

      • The updated file will be

        db.name=rmsisDbName

        jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

        jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=${db.name};encrypt=true;trustServerCertificate=true;

        jdbc.username=sa

        jdbc.password=sa123

        hibernate.dialect=org.hibernate.dialect.SQLServer2005Dialect

        jdbc.dataSourceClassName=com.microsoft.sqlserver.jdbc.SQLServerDataSource

    • Save the contents of <JIRA_HOME>/rmsis/conf/jdbc.properties file.

    • Restart JIRA. This will automatically start RMsis with the updated configuration.

...

AttributeValue
Database Type
select "Oracle"
Hostname
Enter the hostname or the IP address of the database
Port TCP port number of the database server (by default 1521 for Oracle)
Database Enter the name of the database/SID to connect (The Oracle "System Identifier". The default value for most Oracle servers is 'ORCL'. If you are using the Oracle Express Edition, this will be 'XE'.)
Username Enter a username to access the database
Password Password The password to access the database.

  
 

...