Home > Resources > Password > Access SQL Server in Single-User Mode

How to Set SQL Server Access in Single-User Mode

This passage introduces how to access SQL Server in Single User Mode, when cannot access SQL Server using Windows Authentication Mode.

Steps to set SQL Server access in Single-User Mode:

Step 1: Launch SQL Server Configuration Manager and stop SQL Server instance.

stop SQL Server services

Step 2: Right-click on SQL Server instance and select Properties.

open SQL Server instance properties setting window

Step 3: Set SQL Server startup mode in Properties window.

set SQL Server startup in single-user mode

warning for taking SQL Server startup changes effective

Step 4: Save changes and restart the SQL Server instance. This will start SQL Server in single-user mode.

restart SQL Server instance

Once you could access SQL Server in single-user mode, new login can be created and added to SA server role with command prompt. So login SQL Server successfully again with SA account will be no problematic even after SA password forgot and Windows authentication is unavailable.

cannot access SQL Server instance in single-user mode

But if you cannot access SQL Server in single-user mode or cannot log on Windows as administrator, the startup setting would not do help you. In this situation, you would need to use SQL Password Genius which could easily unlock SA account or reset SA password offline.

Related Articles:

Quick Links

Password Recovery Software

Windows Password Tools
Windows Password Genius
Office Password Tools
Office Password Genius
Office Password Remover
Word Password Genius
Word Password Remover
Excel Password Genius
Excel Password Remover
PowerPoint Password Genius
Access Password Genius
Outlook Password Genius
SQL Password Genius
Archive Password Tools
RAR Password Genius
ZIP Password Genius
PDF Password Tools
PDF Password Genius

Hot Products