SQL Server 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';
NET START MSSQLSERVER /m"SQLCMD" //Instance Name.
C:\Windows\system32>NET START MSSQLSERVER /m"SQLCMD"
The SQL Server (MSSQLSERVER) service is starting.
The SQL Server (MSSQLSERVER) service was started successfully.
C:\Windows\system32>SQLCMD -S. -E
1> EXEC sp_addsrvrolemember ' <user to be added>','sysadmin'; //By this we add user to sysadmin role.