SQL Server 2005 in single user mode

Starting SQL 2005 in single user mode and getting admin console

In the startup parameters at the end add ";-m", you could get that in

the SQL Server Configuration then restart the service.

The service gets started in single user mode,

Make sure anybody or any service is not accessing the sql server.

At command prompt execute :


After which you would get prompt like this


If you want to add a login to "Sysadmin role" execute this.

1>EXEC sp_addsrvrolemember '<username>', 'sysadmin';