User Guide: Installation > Database Server Setup
NLS Interface
|

Database Server Setup

If Nortridge Loan System is to be installed in a Client / Server environment, it will be necessary to configure the database prior to installing the loan system on any client computer. This will not be necessary for NLS users who are employing the SaaS (Software as a Service) implementation of NLS in the ASP (Application Service Provider) environment. In this case, Nortridge Software will be acting as your database administrator and you do not need to set up your own database server.

The Nortridge Loan System must be installed to one of the following database platforms:

  • Microsoft SQL Server
  • Microsoft SQL Server Express (This version of SQL server may be used for demo purposes and for single user implementations, and may be downloaded free of charge directly from Microsoft)
  • Oracle

The Nortridge Loan System is capable of automatically configuring the default NLS database schema. The sections on MSSQL Server and Oracle are for the use of DBAs who wish to know how to manually configure the database.

Microsoft SQL Server Setup

If NLS will be used in a multi-user environment with Microsoft SQL Server, a database must be set up. While NLS can automatically build a database, the process may be performed manually if desired. The following are the basic steps required to set up the database for use with NLS using SQL Server 2005.

  1. Log onto SQL Management Studio. You must have privilege to create a database and users.
  2. Create a new database with the name NLS. Set the initial size to 100 MB. A database name other than NLS can be used. The Nortridge Loan System uses approximately 80–200 MB per 1,000 loans with one year of history.
  3. Navigate to the Security folder and choose Logins. Create a new login named NORTRIDGE. A user name other than NORTRIDGE can be used.
  4. Navigate to the Databases folder and expand the newly created database object. Right-click the Users object underneath the newly created database and select “New Database User.” In the New User dialog, select the Login Name that was created in step 3. Assign the role of “db_ddladmin” or “db_owner.”
  5. Edit the database properties of the newly created NLS database and on the permissions tab check the permissions: Create Table, Create View, Create SP, Create Default, and Create Rule; for the newly created user NORTRIDGE.
  6. Log onto Management Studio as the newly created user NORTRIDGE. Once logged in, set the DB: field on the toolbar to the newly created NLS database name.
    Using File > Open, choose the mssqlxx.sql file from the sql folder inside the NLS installation directory (C:\Program Files (x86)\Nortridge Software\NLS\bin\sql) and execute (where xx is the version number of the .sql file).
    After successfully reading in the initialization scripts, the database is ready for connection from the NLS program.

Oracle Setup

In order to use Oracle, a database must first be set up. The Nortridge Loan System supports Oracle 9i, 10g, 11g, and 12c. The following are the basic steps required to set up the database for use with NLS using Oracle. If you need further assistance, please call Nortridge Software technical support.

  1. Create a user named NORTRIDGE. Assign it to a default tablespace and temporary tablespace. Grant this user “connect” and “resource” roles.
  2. Log on to SQL Plus using the newly created NORTRIDGE user. Read in the oracle.sql initialization script located in the dump folder supplied to you using @e:\sql\oraclexx.sql; (where xx id the version number of NLS being installed).
    The default path to this file is:
    Program Files\Nortridge Software\NLS\bin\sql
    After successfully reading in the initialization scripts, the database is ready for connection from the NLS program.


Updated: 2018.08.23


Fill out my online form.