Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

DTS password problem Expand / Collapse
Author
Message
Posted Monday, November 12, 2007 6:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 14, Visits: 680
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



Post #421023
Posted Monday, November 12, 2007 7:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 15, 2013 4:46 PM
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.
Post #421043
Posted Monday, November 12, 2007 8:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 14, Visits: 680
Thanks


Post #421094
Posted Wednesday, November 14, 2007 5:05 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Today @ 7:50 AM
Points: 6,624, Visits: 1,874
Is anything still executing the DTS package, such as a SQL Server Agent job?


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #422377
Posted Thursday, November 15, 2007 7:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 14, Visits: 680
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



Post #422639
Posted Friday, November 30, 2007 7:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 4, 2007 2:16 AM
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
Post #428087
Posted Friday, November 30, 2007 9:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 14, Visits: 680
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



Post #428165
Posted Monday, December 3, 2007 7:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 4, 2007 2:16 AM
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. :)
Post #429083
Posted Sunday, July 13, 2008 9:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 2, 2008 9:37 AM
Points: 1, Visits: 2
Thanks for great help....
Post #533144
Posted Wednesday, September 22, 2010 1:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 2, 2012 11:10 PM
Points: 17, Visits: 215
I could't stop to say Thank you for gr8 tip.
Post #990904
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse