When using the Diagnostics Utility the databases show offline and when you try to connect error 'The Database is in single-user mode, and a user is currently connected to it.'

Potential Symptoms

  • When using the Nucleus Database Diagnostics Utility the databases show offline and when you click Repair, you get the following error:
    • An error occurred during database ope

      rations!
      Changes to the state or options of database 'Nucleus log' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
      ALTER DATABASE statement failed.
    • Login failed for user 'NT Authority\SYSTEM'.  Reason: Server is in single user mode.  Only one administrator can connect at this time.
      error.png

Environment

  • Venus 1500 v4
  • SQL Server 2005, SQL server 2008, SQL server 2014

Cause

  • The database was switched to run in a single-user mode, and the Daktronics Nucleus SQL Database needs to run in Multi-User mode.

Resolution

  • Contact Daktronics Technical support for assistance. 

Work Around

  • Try restarting the computer (make all users logged out of the computer) and try the database utility again.

KB ID: DD2376011


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.