Deployment Agent: changing username for a project

System

I just noticed that it is not possible to change the username that is used to run a project in Deployment Agent.

Now, I have a few rather elaborate projects (several derivatives, targets, schedules) for which I have to do it, for internal reasons.

If I have to create them from scratch I'm in for several hours of very boring work, so I started looking at the database.
I noticed that usernames are stored in the "Projects" table of the MediaBinDA database, so I was wondering if the following procedure would work:

1. stop the DA service
2. edit the Projects table, so that the new usernames replace the old ones (passwords will be wrong at this point)
3. go to the mbda website and edit the properties of each project, so that the correct password is used
4. restart the DA service

I guess that steps 1 and 4 are needed, but as an alternative, would setting all schedules for all projects on "Execute Never" have the same effect? It's just that I have the rights to set the schedules but someone else is responsible of the services, and they're not lightning fast...

Has anyone tried it, or is there a kind soul at Interwoven who can help me out with this one?

Thanks in advance

Folco Banfi

Migrateduser

I forwarded a link to your post on to a few folks, and there's no concrete reply as yet. Someone did ask if you tried backing up your DA database and attempt the procedure?

hth,

lissa