Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Cloud
  • Cloud On-Premise: Attempting to log into Wasp Configuration Tool or SQL Server Management Studio, error message is encountered mentioning "Server is in single user mode"
Subscribe Download PDF

Cloud On-Premise: Attempting to log into Wasp Configuration Tool or SQL Server Management Studio, error message is encountered mentioning "Server is in single user mode"

Scott Leonard
2023-01-18
in Cloud

Example error message: "Login failed for user 'domain\username'. Reason: Server is in single user mode. Only one administrator can connect at this time."

Solution to set SQL Server to Multi-User mode:
1. Launch SQL Server Configuration Manager.
2. On the left, click SQL Server Services.
3. On the right, right-click SQL Server (WASPDATA), Properties.
4. Startup Parameters tab
5. In the Existing parameters section, click the line that is just -m
6. Remove button.
7. OK.
8. Right-click SQL Server (WASPDATA), restart.

SQL Server should now be in Multi-User mode, and you should be able to log into Wasp Configuration Tool and/or SQL Server Configuration Manager.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro