...
- 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
- If you want to connect RMsis with Microsoft SQL Server database using windows authentication mode,
- 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.
- Choose this option, when
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) :
- Specify Database Connection : External
- Database Type : MS-SQL
- Hostname : <Hostname or the IP address of the database>
- Port : 1433 <TCP port number of the database server>
- Database : <RMsis_Database_Name>;instance=<Instance_name>
- Username : <Username to access the database>
- Password : <Password to access the database>
- The above settings can also be used when using named instances in SQL Server on dynamic port. Please make sure that SQL Server Browser Service is running if you are using dynamic port.