Home > Resources > SQL Server > 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:

Hot Categories
Windows Password
Product Key Finder
SQL Password
More +
Hot Articles
4 Ways to Change SQL Server SA Password
SQL Server 2012 SA Password Reset
How to Login SQL Server after SA Account Locked Out
How to Change Server Authentication Mode in SQL Server
How to Enable Mixed Mode Authentication for SQL Server
More +
Latest Articles
How to Correct SQL Login Failed Error after SA Password Forgot
Solve SQL Server Connection Error 26
How to Fix Login Failed to SQL Server
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +