Daktronics

When trying to manually start the SQL Server (NUCLEUS) receive an error 1814.

Potential Symptoms

  • When trying to install Venus 1500 v4.18.1, receive the following error:
    • A network-related or instance-specific error occurred while establishing a connection to the SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).
    • DD2481497.jpg
  • When going to manually start the SQL Server (NUCLEUS), receive the following error:
    • Windows could not start the SQL Server (NUCLEUS) on Local Computer. Fore more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 1814.
    • DD2481497 1.jpg
  • When reviewing the Windows Event Viewer, you find the following error:
    • FileMgr::StartLogFiles: Operating System Error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.

Environment

  • Venus 1500 v4.18
  • Microsoft SQL Server 2008
  • Windows 7 or 8

Cause

  • Either the SQL Server (NUCLEUS) cannot start on Local and needs to be set to Network or the User.config file became corrupted in the Windows Operating System.

Resolution

Step 1: Uninstall Microsoft SQL Server 2008.

  1. Go to Windows Start Menu -> Control Panel -> Add or Remove Programs or Programs and Features.
  2. Browse and locate Microsoft SQL Server 2008, select and click Remove or Uninstall.
  3. Click Remove.
  4. After scan has completed, click Ok.
  5. In the drop-down menu for Instance to remove features from:, select NUCLEUS, and click Next.
    • DD2479815 1.jpg
  6. In the Features Panel, place a check next to Database Engine Service under Nucleus, and click Next.
    • DD2479815 2.jpg
  7. Allow scan to complete, click Next.
  8. Click Remove.
  9. After uninstall is successful, click Next and Close.

Step 2: Manually install the SQL Server 2008 by following DD2474426 and set to run on Network rather then Local.

  1. During the manual install process of the SQL Server 2008, for Instruction #12, instead of choosing NT AUTHORITY\SYSTEM choose NT AUTHORITY\NETWORK.
  2. Continue through the remaining install process as normal.
Step 3: Rename the User.config file and manually install SQL Server again if Step 2 does not resolve the issue.
  1. Go to Windows Start Menu.
  2. Go to the following location:
    • Windows XP: C:\Documents and Settings\[USER_NAME]\Local Settings\Application Data\Application Name\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0
    • Windows Vista, 7 or 8: C:\Users\[USER_NAME]\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0
  3. Right-click on the user.config, select Rename.
  4. Give it a different name such as: user.config.bak

 

KB ID: DD2481497

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.