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 |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2008-03-31 : 09:20:56
|
| Is there a T-SQL command or script that would help me in retrieving a lost SQL User password? I have just migrated a SQL server instances from one server to another, and in order to modify the SSIS packages, I need the password for the user that it uses. I would much rather know the existing password rather than change it.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 23:31:28
|
| There is no such buildin tool. |
 |
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-04-01 : 08:11:10
|
| That's what I thought... And so far I have found nothing for T-SQL when searching the web. I realize the security implications that such a function would inherit, but it is not saved (e.g., UDF or SProc), then the server instance is fine. I just need to try and retrieve an existing password for an SSIS user account.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
|
|
|
Retrieve SQL User Password?