Installing Noodle with MSSQL

The full database engine should be installed with all components, including the full-text search option before Noodle.

Make sure you have Microsoft SQL Server 2012 or later installed. Download (ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe 1.1 GB) here. EOL dates here.

  1. Create a Database
    • Open up the MSSQL Enterprise Manager.
    • Connect to the database engine that will be used for Noodle.
    • Right-click on the folder and select Create Database.
    • A new window will open to configure the database, Specify the name: intranet.
  2. Creating a Login
    • Expand the Security section and right-click on Logins then New Login.
    • Login Name: noodleuser
    • SQL Server Authentication
    • Password: noodlepass
    • Do not enforce password policy (at least don't require change or expire)
    • Default Database: intranet
    • Set User Mapping of the intranet database to db_owner
  3. Enable TCP/IP Settings
    • Right click on the instance and select properties, security, than select SQL Authentication
    • SQL
    • Open the Sql Server Configuration Manager and expand SQL Server Network Configuration.  Select Protocols for MSSQLSERVER, enable TCP/IP.
    • Right-click to reveal properties, ensure one IP# is set as 127.0.0.1
    • For all IP#s using 127.0.0.1 and the IPAll set the port to 1433, and blank out the dynamic port.
    • Restart the MSSQL service
  4. Install Noodle
  5. Configure Noodle
    • Edit the "intranet.conf" file in the "C:\Program Files (x86)\Noodle\enhydra\cfg" folder
    • Verify the user, and pass
    • Uncomment (#) from the MSSQL lines and comment any other databases
    • Close and save changes.
    • Make sure the lib directory contains the 2005 JDBC JAR.
    • restart the noodle service
  6. Open a web browser (preferably chrome), go to the IP and port (http://127.0.0.1:81 is the default), and paste in your license key.