Link to home
Start Free TrialLog in
Avatar of tiehaze
tiehaze

asked on

How do I reset a user password in SQL Management Studio Express?

I am developing a windows application that is currently connecting to a sql database. Here is the connection string I am using:

<connectionString>Data Source=(local)\SQLEXPRESS;Initial Catalog=Fundamental;Persist Security Info=True;User ID=FundamentalUser;Password=pass</connectionString>

When I go into SQL Management Studio Express, and then go to the local sql server/Security/Logins. I then double clicked on FundamentalUser to find the the SQL Server Authentication password is 15 characters long. I changed the Password to 'pass' and the the Confirm Password to 'pass'. When I hit 'OK' and go back into it, it did not save the password to 'pass'

Does anyone know how to change or reset the passwords within SQL Management Studio Express?
ASKER CERTIFIED SOLUTION
Avatar of Chris Mangus
Chris Mangus
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ALTER LOGIN LoginName WITH PASSWORD = 'newpassword';