Very Computer

by **chrisclement** » Wed, 02 Aug 2000 04:00:00

I have two-part question. We have a user that created a DTS package and
saved it to SQL Server (not to the repository or a file). When that user
tries to go back to edit the DTS package, she receives the following error:
"The operator is privileged only to Load the package and Execute it". I've
tried giving her different permissions but can't fix it. Also, if I log on
as 'sa' and open the package on her machine, then right click a connection
and choose 'properties', Enterprise Manager just shuts down. I have
experimented with half a dozen different machines, and only on 2 of them
does this NOT occur---mine and the server itself. Any ideas?

by **Darren Gree** » Thu, 03 Aug 2000 04:00:00

Quote:>I have two-part question. We have a user that created a DTS package and
>saved it to SQL Server (not to the repository or a file). When that user
>tries to go back to edit the DTS package, she receives the following error:
>"The operator is privileged only to Load the package and Execute it". I've
>tried giving her different permissions but can't fix it. Also, if I log on
>as 'sa' and open the package on her machine, then right click a connection
>and choose 'properties', Enterprise Manager just shuts down. I have
>experimented with half a dozen different machines, and only on 2 of them
>does this NOT occur---mine and the server itself. Any ideas?

The message "The operator is privileged only to Load the package and
Execute it" indicates that this is an encrypted package. As such there
are two levels of users and their associated passwords, Owner and
Operator. Your user appears to be supplying the operator password which
only allows you to execute the package, not edit it.

The only permissions and SQL Login requires is to access the storage
location, i.e. msdb DB.

This should be consistent across machines.

As for the MMC shutting down, have you applied SP2, this will stabilise
the UI compared to RTM and SP1.

--
Darren Green
SQL/DTS - http://www.swynk.com/friends/green/

by **chrisclement** » Fri, 04 Aug 2000 04:00:00

Darren,
We seem to have the permissions part straight but the UI still shuts down,
even when SP2 is on the server and the client.
Chris

> >I have two-part question. We have a user that created a DTS package and
> >saved it to SQL Server (not to the repository or a file). When that user
> >tries to go back to edit the DTS package, she receives the following
error:
> >"The operator is privileged only to Load the package and Execute it".
I've
> >tried giving her different permissions but can't fix it. Also, if I log
on
> >as 'sa' and open the package on her machine, then right click a
connection
> >and choose 'properties', Enterprise Manager just shuts down. I have
> >experimented with half a dozen different machines, and only on 2 of them
> >does this NOT occur---mine and the server itself. Any ideas?

> The message "The operator is privileged only to Load the package and
> Execute it" indicates that this is an encrypted package. As such there
> are two levels of users and their associated passwords, Owner and
> Operator. Your user appears to be supplying the operator password which
> only allows you to execute the package, not edit it.

> The only permissions and SQL Login requires is to access the storage
> location, i.e. msdb DB.

> This should be consistent across machines.

> As for the MMC shutting down, have you applied SP2, this will stabilise
> the UI compared to RTM and SP1.

> --
> Darren Green
> SQL/DTS - http://www.swynk.com/friends/green/

by **Darren Gree** » Fri, 04 Aug 2000 04:00:00

Quote:>Darren,
>We seem to have the permissions part straight but the UI still shuts down,
>even when SP2 is on the server and the client.
>Chris

Can you reproduce this on other machines? If not I suggest try re-
installing SP2, try re-registering the DTS DLLs, or even try a re-
install of SQL and SP2 on the client.

Sorry, I can't think of any other reason.
--
Darren Green
SQL/DTS - http://www.swynk.com/friends/green/

Very Computer

dts troubles

dts troubles

dts troubles

dts troubles

dts troubles