Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ludwig
Starting Member
9 Posts |
 Posted - 2009-01-15 : 13:42:52
|
| Guys,I have 3 ssis 2005 packages developed on my laptop, did built them and deployed them successfully to the file system on the server using the deployment manifest. I was logged in as an admin on the server, when I run these packages, they worked fine. All the packages used windows authentication to the database destination on that server.Now I want my client to be able to execute these packages from a workstation using windows authentication. This workstation has the sql-server client tools installed.My idea was the client connects to the SSIS Services from the workstation and sees/executes the packages in the file system folders.Right click, execute. Of, course that failed. Denied access…?Now, what access rights would I need to give a user to enable him to execute packages successfully in this scenario?1.) To the destination database of the ssis packages. (The packages creates and deletes tables)2.) To the file system folder on the server. Any hints are very much appreciated.ThanksLA |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 20:30:00
|
| Clients need to have permission for File system Folder as well as DDL permission in database level. |
 |
|
|
|
|
|
SSIS Execution from workstation/security