How to install Microsoft SQL Server 2014 manually
Note: Show Control Display Studio does not support Microsoft SQL Server 2008.
IMPORTANT: Different versions of Daktronics products support different versions of Microsoft SQL Server.
Product Name
Product Version
SQL Server 2005
SQL Server 2008
SQL Server 2014
Venus 1500
4.22 and newer
Supported
Supported
Supported
Venus 1500
4.18 to 4.21
Supported
Supported
No
Venus 1500
4.0 to 4.17
Supported
No
No
Product Name
Product Version
SQL Server 2005
SQL Server 2008
SQL Server 2014
SQL Server 2012SQL Server 2016
Vanguard
4.24.1 and newer
Supported
Supported
Supported
SupportedSupported
Vanguard
4.9 to 4.24.0
Supported
Supported
No
NoNo
Vanguard
4.0 to 4.8
Supported
No
No
NoNo
Product Name
Product Version
SQL Server 2005
SQL Server 2008
SQL Server 2014
Display Studio
1.0 and newer
Supported
No
No
Display Studio2.0 and newerNoNoSupported
To install SQL Server 2005, please see DD2187510.
To install SQL Server 2008, please see DD2474426.
To install SQL Server 2014, please follow instructions below.
Important: The following steps require a significant amount of technical knowledge. It is recommended for User to seek assistance from their IT or Technical Department or Daktronics Software Support.
- Download Microsoft SQL Server 2014 (SP3) Express from Microsoft’s website.
-
- https://www.microsoft.com/en-us/download/details.aspx?id=57473
- Select Language and click Download.
- Choose SQLEXPR_x86_ENU.exe, and click Next.
NOTE: The x86 installer will work on both 32-bit and 64-bit versions of Window (Do not use 64-bit version of SQL Server).
- Select Save As, and save to the Desktop.
NOTE: You will need to allow Popups, and may need to click the Click Here to try download again.
-
- Run SQLEXPR_x86_ENU.EXE, and then click Next.
- Click Ok on the Choose Directory For Extracted Files dialog.
- This will open the SQL Server Installation Center.
- From the SQL Server Installation Center.
- Click on Planning and follow: How do I run a System Configuration Checker during installation of manual installation of Microsoft SQL Server?, DD4100643
- Note: System Configuration Checker will show any potential alerts, errors or incompatibilities that may cause issues with installation.
- Correct any issues or errors before proceeding with installation.
- Note: System Configuration Checker will show any potential alerts, errors or incompatibilities that may cause issues with installation.
- Click on New SQL Server stand-alone installation or add features to an existing installation.
- Accept the license agreement and click Next.
- For Microsoft Update, optionally check for updates but it may take longer to install, then click Next.
- For Feature Selection, only Database Engine Services and SQL Client Connectivity SDK should be checked, then click Next.
- For Instance Configuration, select Named instance and enter in NUCLEUS and click Next.
- IMPORTANT: The default name must be replaced with the correctly spelled value.
- IMPORTANT: The default name must be replaced with the correctly spelled value.
- For Server Configuration, click Next. SQL Server Database Engine should be NT Service\MSSQL$NUCLEUS.
- For Database Engine Configuration, Select the bullet for Windows Authentication mode.
IMPORTANT: For Nucleus Server to connect to the database the BUILTIN\Administrators group must be added as a SQL Server administrator.
1. Click Add…
2. In the Enter the object names to select field, type Administrators.
Note: If installing on a French OS use Administrateurs
- Be sure to set From this Location: to the computer name.
- See image below
- See image below
Click OK.
14. Click Next.
15. Under Complete, you will receive a notice that Your SQL Server 2014 installation completed Successfully, click Close.
14. Click Next.15. Under Complete, you will receive a notice that Your SQL Server 2014 installation completed Successfully, click Close.
16. You can close out of the SQL Installation Center.