Hello every one ,,
I have a DTS created by SA account , i want to give other
users ( not in the SA role) the permission to run that job
from thier clint tools at the same time they shouldn't
modify it.
Already i created the user ,but when he tryed to run it
from his machine using EM ,he gets access denied error ,
at the same time he can run that DTS directly from the
server without errors.
So can u assist me finding out what's wrong there??

In article <057301c37a97$a3c394a0$a101280a (AT) phx (DOT) gbl>, Naser wrote:

OK. Is he getting an Access denied within the package or when he tries
to run it. My guess is that it is the former. If you use NT
Authentication on the connections within the package then it will be
him that they authenticate against. Any file mappings will be in
relation to him.

You can apply a User password to the package so that he can run it not
modify it but this will not negate the points mentioned above.


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Thanx Allan for the reply ,,
the user has SQL authentication ,he can open the dts but
get the error when he try to run it,,

In article <01d801c37ab1$8ed464b0$a001280a (AT) phx (DOT) gbl>, Naser wrote:
Enable logging in the package and it will tell you on which step it
fails. Are the connections in the package using Windows Aythentication
or SQL Server. ?

Are there any mappings to be considered?


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Thanx again Allan

I've enabled the logging ,but still the DTS dosen't log
this action .
and the package is using windows authentication to connect
to the SQL Srver data source ,regarding the mapping ,i'm
using UNC //servername/.../
so is it from the connections withen the package it self?
if it so , what should i do to make this user and others
to be able running this DTS?

Thanx in advance

If it is a permissions problem onto other objects and you have set the
connections to use Windows Authentication then you need to grant these user
accounts permissions onto the SQL Server objects they are attempting to
access.


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Naser" <nrashed (AT) stc (DOT) com.sa> wrote