Database is in Single User Mode

If the database is in Single User mode please take the following steps to correct the issue:

1. From the search box under Windows Start in Vista or Windows 7, or from Start|Run in Windows XP, enter "services.msc" to show the list of services running on your computer. Look for "SixBit Agent" in the list. Right-click it and select "Stop".
2. Open a Command Prompt from Start | Programs | Accessories | Command Prompt.
3. At the prompt, enter sqlcmd -S localhost\SIXBITDBSERVER and hit enter.
4. Type: use master
5. Hit the enter key
6. Type: go
7. Hit the enter key
8. Type: alter database SixBit set multi_user (Note: "SixBit" should be replaced with the name of the database you are trying to restore)
9. Hit the enter key
10. Type: go
11. Hit the enter key
12. Once that completes, go back to the Services list, right-click and select Start for the SixBit Agent.

Now restart SixBit and you should be able to open the database.

  • Running SixBit, Database Error, Single User Mode
  • 13 Users Found This Useful
Was this answer helpful?

Related Articles

"Invocation of the constructor... Root element is missing" error starting SixBit

Background: SixBit stores many of its operating parameters such as window locations, settings...

SQL Server (SIXBITDBSERVER) Service Stops Frequently Even When Set to Automatic

BackgroundYou are experiencing an error with SixBit and it has been determined that one of the...

"Invocation of the constructor... Item has already been added" error starting SixBit

Background:SixBit uses controls from 3rd party vendors. Sometimes those controls have bugs that...

Argument Out of Range Exception When a Wacom Tablet is Installed

Symptom:When switching views, users running with a Wacom tablet get an "Argument out of range...

How to Tell if a Client can Access the Database on the Server

Background SixBit stores its data using Microsofts SQL Server 2008 R2.  SQL Server is a separate...