How to install Microsoft SQL Server 2014 manually
Topic
- How do I install Microsoft SQL Server 2014 Manually?
Environment
- Product:
- Component: Microsoft SQL Server 2014
- Control System: Venus 1500 v4.22 or newer and Vanguard v4.24.1 or newer
Note: Show Control Display Studio does not support Microsoft SQL Server 2008.
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 2012 | SQL 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 | No | No | 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.
- Download Microsoft SQL Server 2014 (SP3) Express from Microsoft’s website.
- 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.
NOTE: The image above is an example the exact file path may vary - but the Desktop is where we want to file to unpack.
- 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.
16. You can close out of the SQL Installation Center.
KB ID: DD3302758
DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.
DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.
The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.