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

    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
    Location
    Kansas City, MO
    Posts
    734
    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. ???
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    See whether this KBA http://support.microsoft.com/default...b;EN-US;814113 is any help to you.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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