Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Question Unanswered: DTS Design Error - Access is denied

    I am pretty new to MS SQL Server ....

    I have installed SQL Server Enterprise Manager Version 8.0. I am getting the following error while try to create a new DTS Package.

    "DTS designer Error .... Access Denied"

    getting the DTS packge design window but there is no TASK icon visible
    either in the tool bar or menu.....

    Enterprise Manager Version 8.0

    OS : Windows XP pro with SP1
    Last edited by murur; 04-06-04 at 18:12.

  2. #2
    Join Date
    Apr 2004
    Kansas City, MO
    If you go to the msdb database, the user you are using needs to have EXEC permissions on the procs that have dts in the name. This is by default granted to public, so I'm not sure why your user wouldn't have that. ???
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Aug 2002
    See whether this KBA;EN-US;814113 is any help to you.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts