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 Programming
 CHANGE PASSWORD

Author  Topic 

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-01-09 : 11:04:32
Any way to change the password on QA without knowing the old password?



http://www.sqlserverstudy.com

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-01-09 : 11:40:05
if you are a windows admin on the server, I think this is possible.


elsasoft.org
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-01-09 : 12:17:03
How? thanks



http://www.sqlserverstudy.com
Go to Top of Page

stowellg
Starting Member

9 Posts

Posted - 2008-01-09 : 13:37:01
Im an idiot - whats QA?

I have a stupid question for you...
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-01-09 : 13:37:48
Query analyzer.



http://www.sqlserverstudy.com
Go to Top of Page

stowellg
Starting Member

9 Posts

Posted - 2008-01-09 : 13:57:55
K -
I think you can do this via alter login, but ive only ever done it with sysadmin rights on the SQL Server instance (dont think you need windows admin).

ALTER LOGIN someuser WITH PASSWORD = 'NEWPW'



I have a stupid question for you...
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-09 : 22:16:27
Or sp_password in sql2k.
Go to Top of Page
   

- Advertisement -