At the time this document was written, the link http://www.microsoft.com/express/Database/InstallOptions.aspx gets you to the "Database with Advanced Services" installer package for SQL Server 2008 R2 Express.
Depending on your system architecture, please choose the "Database with Advanced Services" 64-bit or 32-bit SQL package.
Considering the size of the package, downloading it to your server is recommended. Once downloaded, please run the installer. This guide for SQL's installation process will only touch on areas & settings critical to the operation of FocalScope. For more detailed instructions on setting up SQL, please see official documentation on http://www.microsoft.com.
The SQL installer alerts us to SQL's own dependencies, simply click [OK] to install the required ".NET Framework" & "updated Windows Installer".
There must be a security account (either SQL account or Windows) configured, to connect FocalScope with the SQL server instance. When setting up a dedicated SQL server instance for FocalScope, it is highly recommended that you use [Windows authentication mode].
The Windows account must exist on both the FocalScope and the SQL server computers or be a Windows domain account. On the FocalScope computer the account must have "Logon as a service" rights. See the lesson Windows Account to accurately configure the Windows account.
Alternatively you can use the SQL "sa" (system administrator) account in Mixed mode. This is not recommended as SQL account names and passwords are stored in clear text and a security risk. If you must use the "sa" account, select [Mixed mode] and enter the "sa" account password you want to use.
Click [Next] to continue.