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 Administration
 reseting user password

Author  Topic 

tnichols333
Starting Member

14 Posts

Posted - 2009-07-21 : 15:59:11
I am trying to just simply change a database user password in SQL Management Studio Express. I can not find where to do this. I have right clicked and there are no options to change a password. Looked on google for 3 hours. Any help will be very much appreciated!!!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-07-21 : 19:33:45
You should be able to double-click the login in Security\Logins to change the passsord, or you could run sp_password.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

tnichols333
Starting Member

14 Posts

Posted - 2009-07-22 : 10:15:29
I think the problem is the login says "without login" and I can't change it. I tried using sp_password and it tells me either it is an invalid user or I do not have permissions and I am logged in as sa.
Go to Top of Page
   

- Advertisement -