Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DTS password problem


DTS password problem

Author
Message
ntt123
ntt123
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 722
Hi, everyone
We have a problem with one of our DTS package.
It was created some years ago, and it developer had left company even before I came.
The package has password and nobody remembers it including that developer(we contacted him).
if anybody has an idea how wee can open this package please help!
Thanks



russell-154600
russell-154600
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 Visits: 185
don't think it can be done (short of editing a backup of msdb with a hex editor). may try opening ticket with MS PSS team.
ntt123
ntt123
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 722
Thanks



K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (6.8K reputation)

Group: Moderators
Points: 6820 Visits: 1917
Is anything still executing the DTS package, such as a SQL Server Agent job?

K. Brian Kelley
@‌kbriankelley
ntt123
ntt123
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 722
Hello, everyone
Checking internet I combine everything and found my own solution
It takes 5 minutes and do not need any script to compile
1. transfer package ownership to my domain account
2. transfer job to my account
3. execute dtsrun DTSRun /~Z0x5...... with switches /!X /!C from my machine
It gave you decrypted line with parameter /M "password"
When I was trying to do this on server it did not give /M parameter, only from my machine
Thanks to everybody for help



ganeshtt
ganeshtt
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 10
Hi,

I am facing the same problem, can you explain me all the steps in sequence you have done to resolve the issue
ntt123
ntt123
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 722
Hi, you need to have admin account to do all of this
I did following steps
1. transfer package ownership to my domain account
use this stored procedure
sp_reassign_dtspackageowner
[@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'

You can find package id from sysdtspackages table
'newloginname' = your domain account

2. transfer job owner for this dts package to my domain account

3.
execute dtsrun DTSRun /~Z0x5...... with switches /!X /!C
from my machine
Z0x5...... is encrypted line from job step

for this purpose create batch file with lines

DTSRun /~Z0x5B4B.......2D495E /!X /!C
pause
DTSRun /~Z0x5B4B.......2D495E is a full line from the job step
I added pause at the end to read what it tells you
You should see lines
Dtsrun: LOading
dtsrun: Executing

After that you can paste to any notepad
It looks like this
DTSRun /S "ServerName" /N "DtsPackName" /M "password" /E /!X /!C


It gave you decrypted line with parameter /M "password"
Let me know when you done



ganeshtt
ganeshtt
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 10
Hi,

Thanks a lot for the details explanation. I have tried your solution and it works. Once again thanks for you prompt reply and the good solution. Smile
tutumho
tutumho
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 2
Thanks for great help....
hrudhay-385221
hrudhay-385221
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 215
I could't stop to say Thank you for gr8 tip.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search