• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 735
  • 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 Jose.Net Team LeadCommented:
you can use the below code to change it through query analyser.

sp_password 'old pwd','new pwd','login name'
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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