here's my problem :
i've created a DTS with enterprise manager directly on the server, and
everything was ok for some days.
But i've modified this DTS on a distant computer and since i've done it,
i've an access denied message when i try to save or execute any dts on the
server. I've acces to everyting else on the entreprise manager (i'm using
a system administrators account) but the only thing i can do with the DTS
is deleting.
On the other side, i can do everything on the DTS on the distant computer.
pleaaaaaaaaaaase...help meeee !!!See if you can run the same commands that the DTS package is executing from
OSQL or ISQL.
Access Denied maybe permissions with the filesystem rather than DTS or SQL.
You can run FileMon.exe from www.sysinternals.com to see where the
permission problem is.
Hope this helps.
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||What was the error message when saving the DTS package?
--
--
Satya SKJ
"jc@.leman-industrie.fr" wrote:
> here's my problem :
> i've created a DTS with enterprise manager directly on the server, and
> everything was ok for some days.
> But i've modified this DTS on a distant computer and since i've done it,
> i've an access denied message when i try to save or execute any dts on the
> server. I've acces to everyting else on the entreprise manager (i'm using
> a system administrators account) but the only thing i can do with the DTS
> is deleting.
> On the other side, i can do everything on the DTS on the distant computer.
> pleaaaaaaaaaaase...help meeee !!!
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment