November 3, 2005 at 7:19 am
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
November 3, 2005 at 8:00 am
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.
November 3, 2005 at 11:24 am
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?
November 3, 2005 at 11:45 am
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