How to Install Microsoft SQL Server 2014 Manually

Question

  • How to install Microsoft SQL Server 2014 Manually?

Environment

  • Venus 1500 v4.22 or newer
  • Vanguard v4.24.1 or newer

NOTE: Show Control Display Studio does not support Microsoft SQL Server 2008.

Answer/Steps

 

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

​Supported​Supported

Vanguard

4.9 to 4.24.0

Supported

Supported

No

​No​No

Vanguard

4.0 to 4.8

Supported

No

No

​No​No

 

Product Name

Product Version

SQL Server 2005

SQL Server 2008

SQL Server 2014

Display Studio

1.0 and newer

Supported

No

No

Display Studio​2.0 and newer​NoNo​Supported​

 

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.       

 

  1. Download Microsoft SQL Server 2014 Express from Microsoft’s website.
    1. Select Language and click Download.
    2. Choose SQLEXPR_x86_ENU.exe, and click Next.
      SQL14SP2.PNG

      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).
    3. Select Save As, and save to the Desktop.
      SQLinstall2.png
      NOTE: You will need to allow Popups, and may need to click the Click Here to try download again.                                
  2. Run SQLEXPR_x86_ENU.EXE, and then click Next.
  3. Click Ok on the Choose Directory For Extracted Files dialog.
  4. This will open the SQL Server Installation Center.
  5. From the SQL Server Installation Center, from the left menu click on Installation.
  6. Click on New SQL Server stand-alone installation or add features to an existing installation.
    SQLinstall3.png
  7. Accept the license agreement and click Next.
  8. For Microsoft Update, optionally check for updates but it may take longer to install, then click Next.
  9. For Feature Selection, only Database Engine Services and SQL Client Connectivity SDK  should be checked, then click Next.
    SQLinstall4.png
  10. 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.
      SQLinstall5.png
  11. For Server Configuration, click Next. SQL Server Database Engine should be NT Service\MSSQL$NUCLEUS.
    SQLinstall6.png
  12. 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…
SQLinstall7.png

  1. In the Enter the object names to select field, type Administrators and click OK.
    • Be sure to set From this Location to the computer name.
      • May need to select Locations... and select the computer name.
        SQLinstall8.png
  1. Click Next.

13. Under Complete, you will receive a notice that Your SQL Server 2014 installation completed Successfully, click Close.

14. You can close out of the SQL Installation Center.

KB ID: DD3302758


Fill out my online form.
DISCLAIMER: Use of this content may void the equipment warranty, please read this DISCLAIMER prior to performing any service of the equipment.