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 |
|
TerryP
Starting Member
4 Posts |
 Posted - 2009-01-22 : 12:46:30
|
Server 2000We use Windows Authetication - user "Jerry" has left the co --- he has DTS packages we need to access/modifyand we're getting this error: Anyway we can login as "Jerry" without sysadmin role ?Can "Jerry" be created as a SQL Server Authentication user so that we can login as "Jerry" with password ?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-22 : 12:59:08
|
| It can be changed wth sp_reassign_dtspackageowner for New SQL Authentication user but that has to done by SYSAdmin |
 |
|
|
TerryP
Starting Member
4 Posts |
Posted - 2009-01-22 : 15:47:33
|
quote:
Originally posted by sodeep
It can be changed wth sp_reassign_dtspackageowner for New SQL Authentication user but that has to done by SYSAdmin
Thanks !How about this - making/saving a copy of ALL "Jerry"s DTS to my ("terry") ownership ? how to do that ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-22 : 16:39:48
|
| Did you look at the syntax for sp_reassign_dtspackageowner ? |
|
|
|
TerryP
Starting Member
4 Posts |
Posted - 2009-01-23 : 11:51:09
|
quote:
Originally posted by sodeep
Did you look at the syntax for sp_reassign_dtspackageowner ?
 I don't see sp_reassign_dtspackageowner insystem sp/system extended sp(actually don't see this sp in SS2005 either :( ) |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2009-02-02 : 12:26:51
|
| Look in the msdb database.I think u r looking in model database |
|
|
|
|
|
|
Creating User Authentication