SQL Professional

SQL Server with Geoff Pasley

Main menu

Skip to primary content
Skip to secondary content
  • Home

Tag Archives: Password

Jul 21

Login Failed or Permission Denied when Starting SQL in Single User Mode

Posted on July 21, 2014 by Geoff Pasley

Getting an error like this after you start SQL in single user mode can be frustrating: 

This happens to me sometimes when I am attempting to reset passwords of instances. Here are the steps you can take to get by this error (“Run as Administrator” should be selected for all command below) :

  1. Stop the SQL Server Service:
    1
    net stop MSSQLSERVER
  2. Start the SQL Server Service using the switches below. The service will not fully start and the “service is starting…” message will remain in the command window. Once this message is displayed you can move on to step 3:
    1
    net start MSSQLSERVER /c /m /T3608
  3. Either open Management Studio and connect to the instance, or open a new CMD window to use SQLCMD.
  4. Once you’ve completed the necessary changes the SQL Server Service will need to be forcibly stopped. Either end the process in task manager or use the following command in the windows CMD window:
    1
    taskkill /IM sqlservr.exe /F
  5. Now SQL can be started normally.
Posted in Troubleshooting | Tagged Login Failed, Password, SQL Professional, SQLCMD | Leave a reply

Recent Posts

  • AlwaysOn Multi-Subnet Configuration
  • Failover Clustering Tools Install Failure | Object reference not set to an instance of an object
  • Backup Restore Progress
  • Group Managed Service Accounts (gMSA) for SQL services
  • SQL Job Runtime

Recent Comments

  • Code Highlighter on Row Count for all Tables in a database
  • wig on Table Structure Overview

Archives

  • April 2017
  • December 2016
  • November 2016
  • October 2014
  • July 2014
  • April 2014
  • February 2014
  • January 2014
  • June 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012

Categories

  • Knowledge Base
  • Scripts
  • Tips
  • Troubleshooting
  • TSQL
© 2021 SQL Professional
Admired Theme