Installation Guide

Please follow these steps to get MemberJunction installed!

Prerequisites

  • SQL Server Database created – can be Azure SQL Server or regular SQL Server. Note: Azure SQL is currently recommended to avoid additional steps required to establish trust between a regular SQL connection and the server certificate.
  • On the computer you are installing MemberJunction:
    • node 20
    • npm
    • Angular 17
    • TypeScript
  • Local working directory. Create a directory on your computer that will be used for MemberJunction work. We highly recommend that this repository is a clone of a remote git repository in your favorite git tool such as GitHub, Bitbucket, etc.

📘

The process of installation attempts to run CodeGen to generate local code for your database. If you are starting with an empty database then this won’t result in new Entities or other artifacts being created in the metadata or code being generated. If you follow the above process and then separately get your data into the database, you can manually run CodeGen again at any time.

Steps

  • Select the version you want to download from this page
  • Download and unzip the file on your local computer into the working directory noted above in Prerequisites, where you want to work on MemberJunction

2. SQL Server Setup

  • Make sure you have your SQL Server and Database setup and ready to go
  • That database can have existing tables in it, just make sure there is no existing schema named “admin” as MemberJunction installs its tables, by default, into a schema called “admin”. If you do have a schema named “admin”, you will need to modify the table installation script and set configuration variables differently in the CodeGen and MJAPI projects to make MemberJunction work off a different schema.
  • Create the following logins within the master database of the SQL server. The syntax should be in the form CREATE LOGIN <login_name> WITH PASSWORD = ‘’:
    • MJ_Connect
    • MJ_Connect_Dev
    • MJ_CodeGen
    • MJ_CodeGen_Dev

3. Run SQL Scripts

  • Within the ZIP file there will be two SQL Scripts that you will need to run on your SQL Server database manually:
  • MJ_BASE_Structure.YYYY_MM_DD.sql – this file contains the DDL statements necessary to create the MemberJunction admin schema, tables, views, and other database objects for MemberJunction’s operation in your database. YYYY_MM_DD will be a specific date stamp and is different for each distribution. Your zip file will only contain one such MJ_BASE_Structure* file
  • MJ_BASE_Dataset.YYYY_MM_DD.sql – this file contains the data itself for the base MemberJunction metadata needed to bootstrap MemberJunction’s admin schema. Run this file after the Structure file has successfully run on your database.

📘

Run MJAPI before you run MJExplorer, the local API server is needed for MJExplorer (and any other API client) to run.

4. Run the MemberJunction Installer script

  • Run the MemberJunction Installer script with the following command in a terminal window from the root of where you unzipped the download file:
    • node InstallMJ.js
    • The installer script will ask you a series of questions. Instead of answering these questions in the console, you can opt to fill in the install.config.json file that will be part of the zip file. If you intend to run the MJ Installer more than once you can save this install.config.json file and reuse it, saving a lot of time compared to manually answering the questions in the installer script each time.

📘

MJExplorer is a useful application to test on your installation of MemberJunction. Even if you don’t plan to use MJ Explorer for your environment, running it successfully and by browsing some of your data helps you validate that your installation proceeded correctly.

5. At this point, you can run MemberJunction API and Explorer to test your install:

  • From the MJAPI directory, run the project either in a debugger environment like VSCode, or just run it with a node command line
  • In a new console window, from the MJExplorer directory, after MJAPI is up and running, run MJExplorer. Either run it in debug mode in VSCode, or run ng serve from the command line in the directory.

👍

After you complete the above steps you should have a functioning installation of MemberJunction on your local computer.