Daktronics

Error updating database (SQLCMD error code: 1) during first time install of Venus 1500 v4.22.0 or Vanguard 4.24.

Potential Symptoms

  • Install of Daktronics product (Venus 1500 v4.22.0) fails during updating database with SQLCMD returned error code: 1.
  • adminpic1.png
  • AND last line in Nucleus Database (dbo) v1.log states CREATE DATABASE permission denied in database 'master'.
  • adminpic2.png
  • SQLCMD returned error code: 1

Environment

  • Product Family: Software
  • Product: Venus 1500 v44.22 or newer
  • Component: Manual install of SQL Server 2014 (either first time or re-install)
  • Control System: 

Cause

  • Forgetting to add "BUILTIIN\Administrators" group during manual installation of SQL Server 2014.

Resolution

IMPORTANT: SQL Server (NUCLEUS) service needs to be started in order for this resolution to properly function. By default it is started, but you will get an error after step 2 is performed if it is not started.

    Note: If installing on a French OS use Administrateurs for Administrators.
    1. Launch the Command Prompt (right click and select "Run as administrator").

    adminpic3.png 

    1. Type "SQLCMD -S (local)\NUCLEUS" and press enter.

    adminpic4.png 

    1. Type "CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS" and press enter.
    2. Type "GO" and press enter.
    3. Type "ALTER SERVER ROLE sysadmin ADD MEMBER [BUILTIN\Administrators]" and press enter.
    4. Type GO and press enter.

    adminpic5.png 

           7. Run the Venus 1500 v4.22 installer again.

    NOTE: Default for installer adds only current user, accordingly the following must be done by the user who installed SQL Server.

    For Temporary Operation

    KB ID: DD3302789

    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.