password change

[ssphoenix]

I have full rights to the SQL box (sa, admin). I need to change or remove a password for a past user that apparently had the only admin rights to a particular application superuser account that uses SQL7. I assume it uses it's own encrypted password and to remove the password will do fine. Can it be done?

Thanks

 

[tlbroadbent]

For SQL Server authentication logins: Use sp_password from query analyzer.

exec sp_password null,newpassword,loginname

Or from enterprise Manager - Open Security | Logins. Open the login you want to change and type a new password in the password box. You'll need to confirm.

If the user was using NT Authentication, you'll need to change the NT login password.

Or you can just remove the login - If it is not an owner of objects in databases. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[ssphoenix]

Terry,

Thanks for your reply. However, the account I was mentioning that needs to be changed is not in the Enterprise manager. This is a software that sits on top of SQL. The account I need to change is stored in one of the tables for that database application. As I explained, this application has its own accounts. I am the system admin and have full rights to the box but not sure if I can go into the database and run sql scripts against that database and clear an account.

Thanks for help.

 

[tlbroadbent]

If I understand you correctly, this is not a SQL server question per se. It is application specific. Have you contacted the application developers or vendors? I don't have any idea how to answer your question. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.