Run Executable from a nework drive

[jase74]

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

[Brian Donahue]

Hi Jason,

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/viewtopic.php?t=2736

Otherwise you would simply need to copy the package to the local computer.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521