0 Start SQL Server in Single-User Mode

Add –m in the sql server start up parameter to start SQL Server in Single User Mode.

Make sure you stop sql agent otherwise, sql agent will take the only connection right away.

Reference

http://msdn.microsoft.com/en-us/library/ms188236.aspx