Forget User ID and Password of SQL Studio

[Former Member]

Hi,

I have forgot User ID and Password of SQL Studio. How can I recover it? Can anybody help me please?

[Former Member]

Hi,

There is a two option as i know...

Option 1 :

Check If there is any other SQL Server Login that is a member of sysadmin role, you can log in using that account and reset the password of SQL Server. Change the password of SA account please see the link below :

http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-stud...

Option 2 :

If there is any other Windows Login that is a member of Windows Admin Group, log in using that account. Start SQL Server in Single User Mode please check the following link :

http://blog.sqlauthority.com/2009/02/10/sql-server-start-sql-server-instance-in-single-user-mode/

Create a new login and give it sysadmin permission.

Note : Please turn off SQL Server Agent before attempting any of the above options

Regards

Bhuban

[Former Member]

Hi Dear,

Please follow the link might be help for you.

http://techontip.wordpress.com/2010/02/22/sql-2008-server-forgot-logon-user-id-password-or-forgot-to...

only password

http://www.codeproject.com/KB/vbscript/SQLServerPasswords.aspx

Regards

Thomas