- KnowledgeBase >
- SQL >
- How to Start SQL Server Instance in a Single User Mode
How to Start SQL Server Instance in a Single User Mode
SQL SERVER – Start SQL Server Instance in Single User Mode
There are certain situation when user wants to start SQL Server Engine in “single user” mode from the start up.
To start SQL Server in single user mode is very simple procedure as displayed below.
Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on desired SQL Server instance and right click go to properties. On the Advance table enter param ‘-m;‘ before existing params in Startup Parameters box.
Make sure that you entered semi-comma after -m. Once that is completed, restart SQL Server services to take this in effect. Once this is done, now you will be only able to connect SQL Server using sqlcmd.
Make sure to remove newly added params after required work is completed to restart it in multi user mode.
- Firewall
- Website Panels
- DELL
- Dynamic DNS
- Hardware
- P2V
- PineApp
- PRTG
- SSL
- VMware
-
Windows
- hmail
- IIS
- Logs
- Security
- How to change activation key in WIN2012
- How to configure time server in server 2003 & 2008
- How to disable the tcp connection limit per IP
- Scripts
- Basic Encoding
- Add disk cleanup utility in windows server 2008 r2
- Custom snmp for Windows
- Reduce Windows 7 +sp1 or 2008 +sp1 WinSXS Folder Size (Cleanup WinSXS After SP1 Install)
- How to install and set Remote Desktop Service
- How to recover DFS of a cloned windows server
- How to find files by size with PowerShell
- How to recover DFS of a cloned windows server (1)
- Wordpress
- DB
- Linux
- Public Cloud
-
SQL
- Backup SQL server Agent
- Backup resotre multiple bak files from directory
- Change db schema to dbo
- ChangeDBownerOnTables
- Export sqlusers with password and sid
- Found max big table
- Full Text Search On SQL
- How To Obtain The Size Of All Tables In A SQL Server Database
- Kill all active connections on DB
- SQL Server which database takes all memory
- How to change a mirrored database server to principal
- How to kill all active connections on MSSQL server
- What to do when SQL Server is in recovery
- How to Start SQL Server Instance in a Single User Mode
- SQL Change schema to dbo
- How to generate a memory usage by database report in mssql
- Switchs
- Backups
- More topics....
- Networking