Sql Server forget password
-
Sunday, March 10, 2013 1:57 PM
Hi
what i do when i forgot the sql server password for authentication.
and my all database in sql server authentication mode.
Thank you.
As Kushwaha
All Replies
-
Sunday, March 10, 2013 2:33 PM
A local administrator can always get access. See:
Batch File to Grant Local Administrators a Sysadmin Login in SQL Server
David
David http://blogs.msdn.com/b/dbrowne/
-
Sunday, March 10, 2013 2:56 PM
Hi Kushwaha,
Try these links ,
http://technet.microsoft.com/en-us/library/ms365941.aspx
http://stackoverflow.com/questions/237006/forgot-sql-server-password
http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/
Thanks & Regards, sathya
- Proposed As Answer by vr.babu Monday, March 11, 2013 1:34 PM
- Marked As Answer by Allen Li - MSFTModerator Monday, March 18, 2013 7:48 AM
-
Monday, March 11, 2013 4:07 PM
And the topic from the SQL Server documentation Troubleshooting: Connecting to SQL Server When System Administrators Are Locked OutRick Byham, Microsoft, SQL Server Books Online, Implies no warranty
- Marked As Answer by Allen Li - MSFTModerator Monday, March 18, 2013 7:48 AM
-
Tuesday, March 12, 2013 1:06 AM
Log in as an administrator and reset the password.
make sure you maintain in a secure location.
-
Thursday, March 28, 2013 10:59 AMIf you forgot SQL Server password then you can use our Advanced SQL Server Password Recovery Software which is inexpensive utility that provides you very effective ways to get back lost SQL Password.
-
Friday, March 29, 2013 4:39 AM
Hi,
If you ever lost a SA password, you may have thought your only option is to reinstall SQL and re-attach to the DB’s. However, SQL server provides a much better disaster recovery method which preserves objects and data in the master DB. Members of the server’s Local Administrator’s group can access SQL server by starting it in single-user mode.
1. Configure SQL Single-User Mode
- Open SQL Server Configuration Manager
- Stop the SQL Server Instance you need to recover the SA password
- Open the properties on the SQL Server Instance and click on the Advanced tab
- Change the Startup parameter by adding -m; at the begging of the line and click OK
- Start the SQL Service Instance2. Use SQLCMD to add a Sysadmin Account
- Open the command prompt
- Run sqlcmd and press enter
- Run a Transact-SQL (Below) command to add an existing account or a new account to the sysadmin server role. Replace DOMAIN\Username with the account you want to add. *NOTE: if you receive errors, I’ve listed some common issues at the end of this article.EXEC sp_addsrvrolemember 'DOMAIN\Username', 'sysadmin';
GO3. Un-configer SQL Single-User Mode
- Open SQL Server Configuration Manager
- Stop the SQL Server Instance
- Open the properties on the SQL Server Instance and click on the Advanced tab
- Change the Startup parameter by removing the -m; at the begging of the line and click OK
- Start the SQL Service Instance4. Reset sa Password
- Open Microsoft SQL Server Management Studio and login with the account you added
- Under the DB, expand Security, then Logins
- Open the properties for the sa account, and reset the passwordThanks & Regards LAKSHMI NARAYANA REDDY.L
-
Friday, March 29, 2013 7:43 AM

