SQL Server Performance

Cannot Post to DTS Forum

Discussion in 'SQL Server DTS-Related Questions' started by webbob, Mar 29, 2006.

  1. webbob New Member

    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.
  2. FrankKalis Moderator

    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=':(' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  3. webbob New Member

    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.
  4. FrankKalis Moderator

    Sorry, I can't help you with that. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  5. Madhivanan Moderator

    >>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
  6. FrankKalis Moderator

  7. satya Moderator

    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.

Share This Page