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.
| Author |
Topic |
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
 Posted - 2007-09-09 : 11:11:36
|
| I think that thread was closed prematurely. (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89098)You can move a login w/password to another host using the sp_help_revlogin stored procedure that microsoft created. There are 2 versions, 1 for SQL7/SQL2K and the 2nd one is for SQL2K5 only. Here are the links:SQL7/2K - http://support.microsoft.com/kb/246133SQL2K5 - http://support.microsoft.com/kb/918992This will not give you the text of the password. Rather, it will output the hash value which can be used when creating the login on the new system.These procs should be bookmarked by all DBAs since they are so useful. We use these procs several times a week it seems.-ec |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-09 : 13:54:16
|
| I should retry 2005 again... last time it generated a random passwordI must have done something different--------------------keeping it simple... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-09 : 17:52:05
|
| The problem in this case is that you need user id and password to install the app. You can transfer login with password to new server, but still can't install the app without password. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-09-10 : 08:29:54
|
| Nope, not premature.We made a decision years ago that SQLTeam wasn't going to help people crack passwords or decrypt code. 9 times out of 10 these threads are about someone trying to get at a 3rd party application they'd rather not pay extra license fees on, and we'd rather SQLTeam not be a resource for helping this happen.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
re: Decrypting the Password