How to see or change 'sa' password of sql server management studio 2005

[Former Member]

hi experts,

how can i see or change sql server management studio 2005 server password &

again connect to my SAP database.

i am using sap 8.80 PL 10 & sql server 2005.

i want to change password of 'sa' username & connect to my database to SAP 8.80 PL 10.

how can i do this please help..

Thank you in advance.

santosh

[cherry_tian · Accepted solution]

Hi, Santosh,

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 as described here :

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

If there is no one you can find with the sysadmin role, you can logon the server in single user mode.

The description is in the following blog.

http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-p...

Best regards.

Cherry

[Former Member · Accepted solution]

Hi Cherry,

Thank you so much for reply,

but i want to connect sql server SAB b1 to my database also. can you please tell me how can i do

after changing sa password.

Thank you & Regards

santosh.

[cherry_tian · Accepted solution]

Hi, Santosh

SA user isn't related to SAP installation. Note 592514 shows all of the users ,logins needed for SAP system, but not including sa.

After you change the password, you can use sa and its new password to login the SQL Server . Couldn't you do that?

Could you let me know more details about your SQL Server scenario (which server you want to connect, what error you got when you failed to connect the server) and login mechanism?

Best regards.

Cherry

[Former Member · Accepted solution]

hi cherry,

I am using SQL server management studio 2005. i wan t to use SQL Server 2005 for Crystal report 2008 for making reports. now i don't know 'sa' password of sql server so  i am not able to connect my Crystal report 2008 to sql server. 

Thank you

santosh.

[Former Member]

Please check out this article:

http://www.instructables.com/id/How-to-Reset-Lost-SA-Password-on-SQL-Server/

With the tool mentioned in the article above, you can reset lost sa password and unlock sa account in case it is locked out or disabled.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

Hello,

You have same ways to reset/change the SA password. One is:

- Login into SQL server --> SQL Management Studio

- Open Security folder -> Logins --> Right click on sa account --> properties

- Put a new SQL sa password

- Click OK

Best regards

Joao Vagarinho

[Former Member]

Hi,

If your query is "How to reset the password", then the answer is go to SQL server management studio expand Security>Logins>Select the ID and then right click>Properties>Enter the new password>OK

Regards,

Nick Loy

[Former Member]

This message was moderated.

[Former Member]

Hi Santosh,

Resetting password is easy..You can have a look at this knowledge base article:

http://support.microsoft.com/kb/322336

Besides, check this one to that offer couple of manual ways to recover lost password:

http://www.sooperarticles.com/technology-articles/databases-articles/sql-server-management-what-sql-...

Thanks

[former_member188883]

Hi Santosh,

Please refer link http://support.microsoft.com/kb/322336

http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/

Hope this helps.

Regards,

Deepak Kori