I forgot sql server sa password

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

I forgot sql server sa password

Author

Topic

Abid

110 Posts

Posted - 2010-11-08 : 23:21:11

hi, when i open the SQL SERVER Management Studio and Logged in with Server Authentication so it asked for a user name "SA" by default and password field was empty, i gave a password and marked the "Remember this password" option. now my sql server password is saved and working properly, but i have forgotton the password, can anyone tell me the righteous way to find my password" :(

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-08 : 23:55:13

If you don't remember it, then just reset it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Abid

110 Posts

Posted - 2010-11-09 : 23:31:43

quote:
Originally posted by tkizer

If you don't remember it, then just reset it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hello Mr. Tara Kizer, i did not understand on your answer, please explain your answer and assist me properly,

thanks

Sachin.Nand

2937 Posts

Posted - 2010-11-10 : 00:02:41

Just execute the below statement

ALTER LOGIN [sa] WITH PASSWORD = 'Put your new password here';

PBUH

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-11-10 : 00:28:58

Mr. Tara Kizer

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-10 : 11:17:39

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Abid

110 Posts

Posted - 2010-11-11 : 00:51:21

quote:
Originally posted by Sachin.Nand

Just execute the below statement

ALTER LOGIN [sa] WITH PASSWORD = 'Put your new password here';

PBUH

hi sachin, sachin could you please tell me that where do i write this statement, and please tell me that have you done ever this before on your system?

Abid

110 Posts

Posted - 2010-11-11 : 00:55:20

quote:
Originally posted by tkizer

If you don't remember it, then just reset it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hi, sorry Miss Tara, I read about you today, last time i asked a question by saying Mr. Tara, I really oppologize for my mistake. Mam please tell me that how do i get out of my problem? i forgot SA password

Sachin.Nand

2937 Posts

Posted - 2010-11-11 : 00:58:45

quote:
Originally posted by Abid

quote:
Originally posted by Sachin.Nand

Just execute the below statement

ALTER LOGIN [sa] WITH PASSWORD = 'Put your new password here';

PBUH

hi sachin, sachin could you please tell me that where do i write this statement, and please tell me that have you done ever this before on your system?

You have run it in the Query Analyzer.

PBUH

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-11-11 : 01:02:17

Have a look at:
http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources