DTS in Enterprise Manager

  • Environment: Windows 2000 Server, SQL Server 2000 - single instance with 3 Programmers on site.

    Can someone tell me how to grant access to a Programmer so they can build and execute DTS Packages but not be a System Administrator? I'm at the point where out of frustration I turn on the SA Role so they can do their work, then turn it off when they are done.

    Also, is there a way for all 3 Programmers to see each others DTS Packages?

    Maybe there is an article somewhere on DTS that someone knows about?

    Thanks

  • User must be granted Execute permission on xp_cmdshell unless they are a member of the Sysadmin fixed server role.  Not sure if this allows them to see each others packages though.

    http://www.sqldts.com/default.aspx?1  is a good resource.

  • Thanks. This gets me part of the way. Now I get an error as follows:

    Msg 50001, Level 1, State 50001

    xpsql.cpp: Error 87 from GetProxyAccount on line 604.

    Where do I go from here?

  • Never mind, I found the answer.:

    How to configure a SQL Server Agent proxy account to enable non-system administrators to execute the xp_cmdshell extended stored procedure in SQL Server 2000

    http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B890775

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply