Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • Last Modified:

Change MsSQL User Password

I have a windows server using MsSQL via Micsrosoft SQL Server Studio Express. I need to change the password for the user that my application is using. I just have not been able to find it.
0
cortdev
Asked:
cortdev
1 Solution
 
Hypercat (Deb)Commented:
If you are talking about changing the password for an account that is using SQL authentication, then you would need to open the SQL Server Mgmt. Studio program with a SQL administrator-level user and password. Then go to Security/Logins and find the user whose password you want to change. Right-click the user name, go to Properties and change the password on the General properties page.
If that's not what you're looking for, please provide further details on your exact situation and what you're trying to accomplish.
0
 
SandeepratanCommented:
Goto Management Studio

Goto Security --> Logins--> Right click on the user and goto password

here is the link
http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/
0
 
Jini JoseSenior .Net DeveloperCommented:
you can use the below code to change it through query analyser.

sp_password 'old pwd','new pwd','login name'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now