Ok i finally got it to work! Thanks Romtec for all your help! Type Exit to log out and close the command prompt. You will see the 2> prompt, type GO and hit Enter to execute the command. You can type the ALTER DATABASE command and hit Enter. Once connected to the SQL Server you will see the 1> prompt. SQLCMD -S SERVER\SQL Instance -U account name -P Password Open a new query window, enter the ALTER command and click execute to unlock the ?sa? account. Choose Widows Authentication mode and login with an administrator account. You will need authority to access the SQL Server directly. Option 1 ? From MicroSoft SQL Server Management Studio *Enter the existing ?sa? password if remembered, otherwise enter a new one. To unlock the SQL Server ?sa? account, run the following command:ĪLTER LOGIN sa WITH PASSWORD = 'new_password' UNLOCK The error occurs when the SQL Server administrator account is locked. : Login failed for user ?sa? because the account is currently locked out. So, clearly, this "-m" switch isnt working.ĭoes anyone have another workaround? All I need is to re-enable the administrator account again. same result - says that the account doesnt exist. Since there is another Administrator on this server, i logged in to Windows as this admin, then tried to open SSMS. i then reopen SSMS and try to login using the admin account and it still tells me that the account is locked. After making the change, i restart the SQL Server service as well as the SQL Server Browser service. I've now tried to use this "-m" technique through cmd as well as the SQL Server Configuration Manager. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role." Neither the -m or -f work, btw. I found this on the MSDN site, linked above: "Start the instance of SQL Server in single-user mode by using either the -m or -f options.
So, after doing some searches on Google, i found these sites which seemed promising: Last week i managed to lock myself out of SSMS :pinch:
0 kommentar(er)
