Run Executable from a nework drive
jase74
Posts: 6
Hi,
I've created a very simple package that will create a table and add rows to the table. I want to run the exe from a network share, so that I pass the package to a release team. When I run the exe from a network drive I get the following error:
"You don't have sufficient permissions to run an executable located on another machine"
I don't know if the exe is throwing the error or that I don't permissions to run an execute from the share.
I'm newbie to SQL Packager so I may have missed something very obvious...
Jason
I've created a very simple package that will create a table and add rows to the table. I want to run the exe from a network share, so that I pass the package to a release team. When I run the exe from a network drive I get the following error:
"You don't have sufficient permissions to run an executable located on another machine"
I don't know if the exe is throwing the error or that I don't permissions to run an execute from the share.
I'm newbie to SQL Packager so I may have missed something very obvious...
Jason
Comments
Thanks for asking. This is actually a security exception being thrown from the .NET Framework. By default, the security permissions prevent you from running .NET code (such as your package) from across a network share. If you're really desparate to make this work, you can change your .NET installation's machine.config to allow remote execution as described here:
http://www.red-gate.com/MessageBoard/vi ... php?t=2736
Otherwise you would simply need to copy the package to the local computer.