Error 18486 Sql Server 2008
Contents |
SERVER - FIX : Error: 18486 Login failed for user ‘sa' because the account is currently locked out. The system administrator can unlock it. - Unlock SA Login April 23, 2009Pinal DaveSQL, SQL Server, SQL Tips how to unlock user account in sql server 2008 r2 and Tricks41 commentsToday, we will riffle through a very simple, yet common reset password for the login while unlocking issue - How to unlock a locked "sa" login?It is quite a common practice that SQL Server is sql server authentication login is locked out greyed out hosted on a separate server than application server. In most cases, SQL Server ports or IP are exposed to the web, which makes them risk prone. For hackers, System Admin login
Unlock Sql Sa Account Without Changing Password
"sa" is the preferred account which they use for hacking. In fact, a majority of hackers try to hack into SQL Server by attempting to login using "sa" account. Once hackers gain access to server using "sa" login, they get a complete control over the SQL Server.Hackers apply Brute Force method to hack "sa" login. Brute Force method is an attempt sql server password changer to guess a password using every possible combination. Be it in your machine where SQL Server is hosted or in your domain, if you have a policy setting that disables any account after a certain number of unsuccessful attempts, it will also disable all your SQL Server logins including "sa" login. In this scenario, SQL Server will display the following error:msg: 18486 Login failed for user ‘sa' because the account is currently locked out. The system administrator can unlock it. Fix/Solution/Workaround: 1) Disable the policy on your system or on your domain level. However, this may not be the most appropriate option as it will adversely affect your security protection level.2) If this is a one-time issue, enable "sa" login WITH changing password of "sa" login.ALTER LOGIN sa WITH PASSWORD = 'yourpass' UNLOCK ; windows server 2008 r2 domain for 5 invalid logon attempts. I have one member server which has a web application that uses a SQL server 2008 R2 database installed on the same box. When I browse to the site on the same box or accros the network, it did not http://blog.sqlauthority.com/2009/04/23/sql-server-fix-error-18486-login-failed-for-user-sa-because-the-account-is-currently-locked-out-the-system-administrator-can-unlock-it-unlock-sa-login/ browse correctly and it displays the following error: Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. I disabled the Account Lockout Threshold policy in my domain to solve this issue but this is not the requirements, kindly any idea? Wednesday, April 03, 2013 8:11 AM Reply | Quote Answers 1 Sign in to https://social.technet.microsoft.com/Forums/en-US/afccf414-ce8f-4625-aa9f-5982b25dc105/sql-sa-account-locked?forum=winserverDS vote Hello, Please read this links: SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. Regards Proposed as answer by Eugene Pavlov (Softerra) Thursday, April 04, 2013 8:44 AM Marked as answer by Yan Li_Moderator Thursday, April 11, 2013 5:17 AM Thursday, April 04, 2013 8:17 AM Reply | Quote 0 Sign in to vote Hi, If this account isa domain user account, then we could unlock it on DC. I would like to suggest not disable the account policy, as this may cause some security issues to your environment. And if the account is an SQL account which is create in the SQL, then, maybe we should go to the SQL management tools to unlock it. And as far as I know, in SQL we could create password policy to those account too. To find out lock out reason, please use lockout tools and for details, please Password Changer PDF Password Recovery Protect My Folders Video Converter Assist KeyFinder Plus More... PurchaseDownloads Support FAQ Tutorial & Guide Knowledge Base About Us Company Information Contact Us Affiliate Blog Home > SQL Server Password Changer > Unlock SQL Server SA Account Special Offer http://www.top-password.com/knowledge/unlock-sql-server-sa-account.html Password Recovery Bundle Only $29.95 to get All-In-One toolkit to recover passwords for Windows, PDF, Office, http://readtrace.blogspot.com/2011/04/unable-to-login-into-sql-server.html Outlook, Email, MSN, and more... Guide & Tips Reset Windows Password Windows 10 Password Reset Forgot Windows 8 Password Bypass Windows 7 Password Recover Outlook Password Reset SQL Server Password Reveal Asterisk Password Find Lost Product Key Unlock PDF file Convert FLV to MP4 2 Methods to Unlock SQL Server SA Account When It's Locked Out Can't connect to SQL Server sql server due to SA account locked out? If the SA account is locked down you may receive the error message "Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486)." When password policy is checked for a SQL Server login account, your account will get locked out after too many failed login attempts. In this article we'll show you 2 methods to unlock SQL Server SA sql server 2008 account when it is locked out or disabled. The methods work with all versions including SQL Server 2014. Option 1: Unlock SA Account in Management Studio If the mixed mode authentication is enabled in SQL Server, you can log into SQL Server Management Studio with Windows Authentication, and then unlock any SQL Server user account easily. Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right click on SA account and go to Properties. In the Login Properties window, uncheck the box beside Login is locked out and click OK. Option 2: Unlock SA Account with SQL Server Password Changer SQL Server Password Changer is a powerful recovery utility that can reset lost SQL Server password and unlock any locked-out or disabled user account. You do need to stop your SQL Server instance before following these steps to unlock SA account: Download SQL Server Password Changer on your local PC, install and launch it. Click the Open File button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL10\MSSQL\DATA. The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click the Change Password button. Type a new password and click OK. The program will replace the existing password with your new pas 2008 because you do not have access through Windows account and your SQL account is locked or you have forgotten the password Errors: ======= Different errors you may get: as you attempt through various ways: Error 1: TITLE: Connect to Server ------------------------------ Cannot connect to abcsql\sql. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'test'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18470&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Error 2 TITLE: Connect to Server ------------------------------ Cannot connect to abcsql\sql. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'test' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18486&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Solution: ======= Solution 1: Simple and easy ===================== If you have not deleted the builtin\adminsitraors account from SQL login explicitly, logon to the Server/Machine with one of the builtin\administrators of the machine and you should be able to connect with SQL Server Solution 2 ========= 1. Stop SQL Server and SQL Server Agent2. Start SQL Server from cmd with -c -m3. Connect to SQL instance using sqlcmd or SSMS (timing here is important, you need to make sure that no one else is able to login before you connect, even default trace) and as you connect run a command similar to below: sqlcmd -S abcsql\sql -i"D:\abc.sql" where abc.sql should
GO3) If this is a one-time issue, enable "sa" login WITHOUT changing password of "sa" login.ALTER LOGIN sa WITH CHECK_POLICY = OFF;
ALTER LOGIN sa WITH CHECK_POLICY = ONAlter Login UnlockSql Server Account Lockout Threshold