This page documents a few items of note for those who are installing Learn on the Microsoft platform.
- Q2 2017 Learn only installs and runs on MS SQL Server 2014 Standard or Enterprise editions. Q4 2016 and prior only install on MS SQL Server 2012 Standard or Enterprise editions. We know Learn does not work on MS SQL Web Edition or Express. Your milage may vary on other editions.
- JAVA_HOME should not contain any spaces. Install Java into a directory such that the path to the directory is space free. C:\Program Files will FAIL.
- Turn off virus protection during the install.
- Turn off firewalls during an install/upgrade.
- Turn off User Access control, or set it to a minimum. (run MSCONFIG > Tools tab > select the UAC line > launch > set the slider to a minimum)
- The command line prompt used to run the installer script and other Learn scripts should be elevated. "Run as Administrator"
- Use the sa account, and its password, for the DBA account.
- The account running the installation needs ALTER ANY SQL permission on the DB. See https://msdn.microsoft.com/en-us/library/ms191291(v=sql.120).aspx
- A JRE will not work. Make certain you have a JDK installed.
- The system you install on needs to be part of a domain or look like it is part of a domain. The simple way to do this is as follows:
Let's say you want to use the name: blackboard.localdomain. Add these lines to your windows\system32\drivers\etc\hosts file:
Microsoft SQL Server Installation and Configuration Requirements:
- Install SQL Server at the drive level, for example, C:\SQL Server.
- Use Mixed Mode Security Authentication.
- Make sure SQL Server is installed using a local account.
- Blackboard recommends using the default instance name. If the default instance name is not used, the instance name must not include any underscores, spaces, or punctuation. Use only alphanumeric characters.
- If an instance other than the default is used, make sure that the instance is not case sensitive.
- The SQL Server Client Tools must be installed on each application server.
Q2 2016 and Later Specific Requirements
1. Use Unix-style path names in the installer.properties file, unless the property name contains .win.
2. Create the data directory specified by bbconfig.database.datadir before starting the install.
3. Ensure that you remove any non-default password policies against MSSQL.
4. If installing for the first time, ensure that the password given for the BBLEARN accounts meets the MS SQL password requirements.
5. Gradle, which the installer uses, has a 12-character password limit.
Ensure that the SA password has 12 or fewer characters and NO special characters. (#!% etc. cause issues.)
6. MS SQL Server 2008 and MS Server 2008 are NOT supported. Upgrade before attempting the Learn Q2 2016 upgrade/install.