This describes the installation of the 64 bit version of SQL Server 2008 R2 Express, for use as a DB for MediaPortal's TV Server. The file names mentioned below apply to Windows installations using English as the preferred language. If you have a different language selected as the preferred langauge, you may receive files with slightly different names.
2017 is the last member of the MS SQL Server familysupported by Windows 8.1. The methodology described here enables its semi-automatic installation.
The basic principles of this methodology are:
- Download the desired version of SQL Express.
- Download SQL Server Management Studio (SSMS).
- Prepare the files for installation.
- Prepare a configuration file,
- Complete the installation.
This methodology can be employed from any account, as long as you have access to an account having administrative privileges to authorize the actions requiring User Account Control (UAC). However, there will be many such occasions, so it will be much easier if you perform the installation while logged into an account with administrative privileges.
Download the desired version of SQL Express.
- Download "SQLServer2017-SSEI-Expr.exe" from this Microsoft site. This is only a stub, which will download the full installation package for the host OS.
- Open a command (or PowerShell) window in the directory where you saved the file downloaded in the step above. In Windows 8.1, you can do this by holding down the SHIFT key, right-clicking the directory name in Explorer and choosing "Open command window here" from the resulting pop-up menu. In Windows 10, PowerShell has replaced CMD as the default command line interpreter (CLI), but it will serve just as well and you can invoke it in a simnilar way: Just hold down the SHIFT key while right-clicking the directory name and choose "Open PowerShell window here" from the resulting pop-up menu.
- Enter the following command into the new window:
- A dialog will open prompting you to select a download package and a folder to store it in.
- Select the "Express Advanced" package (this is the one which has been tested) and the same directory where you downloaded the stub file.
- When the download is finished, the downloader will report success:
- Click on "Open folder".
Download SQL Server Management Studio (SSMS)
This step is optional but highly recommended, in case you should need to examine the contents of the DB. In SQL 2008, the Management Studio was included in the SQL Server installation package, but this is no longer the case. The current version of SSMS (18.8 as of this writing) is compatible with SQL versions from 2008 - 2019.
- Download the SSMS installation package from this page, which also includes detailed explanations about the package's capabilities, compatibility and known issues. Choose the same direcotory where you downloaded the files in the previous section.
Prepare the files for installation.
- In the window which opened after downloading SQL Server 2017 Express, right-click on the file that was downloaded, "SQLEXPRADV_x64_ENU.exe", and select "Run as administrator" from the resulting pop-up menu.
- This will result in a dialog asking for a directory in which to unpack the installation files. The default is a sub-directory, named "SQLEXPRADV_x64_ENU", of that from which the file was executed, but please delete the subdirectory and extract it to the same directory you used for the other files.
Prepare a configuration file.
- Open Notepad (or other text editor of your choice, but not Word), copy the text under "Configuration file (MPSQL.ini)" below and paste the text into the open text editor window. This configuration file has been tested under Windows 8.1 and Windows 10 with MP 1.26 and 1.27. It should be valid for SQL Server 2016, 2017 and 2019. Nevertheless, changes in the configuration file may be required. You will find further information about configuration file syntax and interactive creation of configuration files, including a sample configuration file here. Another example of a configuration file (for SQL 2016, which should also be valid for SQL 2017 and 2019) can be found here.
- Save the file as "MPSQL.ini" in the directory you chose in step 2 above.
Complete the installation.
- Go back to the command (or PowerShell) window you opened in the first section of this procedure and enter the command:
- This will install SQL Server Express and create a database with an administrative (sa) password of "MediaPortal" (or whatever you substitute for it in MPSQL.ini). This is the login and password you will need when installing TV Server.
- If you downloaded SSMS, go back to the command (or PowerShell) window you opened in the first section of this procedure and enter the command:
.\SSMS-Setup-ENU.exe start "" /w .\SSMS-Setup-ENU.exe /Passive
You can verify a successful installation by starting the Management Studio and logging in as "sa" with the password "MediaPortal" (or whatever you chose in the configuration file) To do so, you will have to select "SQL Server Authentication" instead of "Windows Authentication".
This method evades the restrictions on passwords generally enforced by SQL Server in order to setup the default login parameters used by MediaPortal. These restrictions would normally prevent the use of a weak password, such as "MediaPortal". This is unlikely to be problematic as long as the database is only accessible within your local (home) network. If you plan to allow access from outside, please follow the recommendations for installation using a strong password in the command line as shown in the earlier wiki article, "SQL Server 2008".
Configuration file (MPSQL.ini)
This page has no comments.