SQL Server Performance Forum – Threads Archive

Cannot Post to DTS Forum

Hello Folks. Can anyone tell me why I blow out of a Post to the DTS Forum? I have logged in and out a number of times. And I have tried to post 3 or 4 times since yesterday. It seems the post just hangs for a while and then the browser goes to a server-not-found screen for the post_info.asp page. Any clue? Thanks.

Strange. But in case your posting containted the name of an extended procedure like xp-cmdshell try changing the underscore ‘_’ to a ‘-‘ and try again. We have no real explanation for that behaviour. [<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

As a matter of fact I did. Here’s the post. By the way, can you help me? ;> ********************************************************** 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.

Sorry, I can’t help you with that. [<img src=’/community/emoticons/emotion-6.gif’ alt=’

>>Should I use the /U /P parameters and specify the sa user-id? Try them and test Madhivanan Failing to plan is Planning to fail

Can you repeat your answer in DTS? webbob startet there a thread, too. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

For me it seems the problem with privileges for the account used on ASP page and also check the privileges for SQLAgent account in this case. As you say it is better to use /U and /E (for trusted connection) option with a privileged user. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>