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 |
|
tjams
Starting Member
8 Posts |
 Posted - 2002-06-27 : 19:24:34
|
| I have some DTS packages that I am running via stored procedures using the xp_cmdshell extended stored procedure. I am executing these stored procedures from asp.net web forms. I am using Windows authentication in my application and IIS is setup to use Integrated Windows authentication for this web app. Unfortunately, I have found that I am unable to execute these DTS packages successfully unless the users who are executing the associated pages are members of the System Administrators server role in SQL Server 2000. I'd prefer not to give all of these users Sysytem Administrator priviliges. Does anyone know of any way to get around this? If I remove the users from the System Admin role, I don't get any errors and the dts package appears to execute, but it doesn't do anything. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-06-28 : 01:53:15
|
| Right click on SQLAgent, and select properties. One of the tabs has a checkbox for allowing non-SA accounts to execute xp_cmdshell.-Chad |
 |
|
|
tjams
Starting Member
8 Posts |
Posted - 2002-06-28 : 13:06:01
|
| I'm not actually using SQLAgent for these DTS packages. Does that matter for this? |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-28 : 13:11:13
|
quote:
I don't get any errors and the dts package appears to execute ...
Make sure your package logs its execution and any transformations write to an exception log. If the xp_cmdshell appears to succeed then perhaps the package is accessing resources that only sa-equivalents have rights to. The messages coming from the execution log should tell you for sure.Jonathan Boott, MCDBA |
|
|
|
tjams
Starting Member
8 Posts |
Posted - 2002-06-28 : 13:24:09
|
| Thanks guys. Chad, your suggestion worked like a champ. You guys rock! |
|
|
|
|
|
|
DTS Fails using xp_cmdshell