SQL Server Performance Forum – Threads Archive

Permission Denied DTS Package Run From ASP-SProc A

Hello All. I want to run a DTS package from an ASP.NET page that runs a stored procedure. I created the simple sproc below to test it. CREATE PROCEDURE [dbo].[ExecuteTestDTS]
as
EXEC master..xp-cmdshell ‘dtsrun /SSERVERxxx /NTestDTSsproc /E /LxxxLog’
GO The TestDTSsproc package does a SELECT * INTO X-tmp FROM X that creates a copy of table X. I have run the package from the DTS service and it runs successfully.
I have run it from Query Analyzer and it runs successfully. When I run it from the ASPX page I get the following error: System.Data.SqlClient.SqlException: EXECUTE permission denied on object ‘xp-cmdshell’, database ‘master’, owner ‘dbo’. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) It seems I may not have enough permission as a /E and a remote IUSER_SERVERxxx to run the package. Should I use the /U /P parameters and specify the sa user-id? Or is there something else I am missing? Thanks in advance for your help.

---

Maybe you can try to add in a user to the SQL Server named ASPNET..I dont know if it will worked..but what i know is that ASPNET is a windows user for ASP.NET.

---

for executing system stored proc like xp-cmdshell, you need system admin level rights. Give System Adminstrator rights to you user IUSER_SERVERxxx and try again.

---

]]>