Run Executable from a nework drive

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Run Executable from a nework drive

Postby jase74 » Wed May 16, 2007 11:12 am

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
jase74
 
Posts: 4
Joined: Wed May 16, 2007 10:56 am

Postby Brian Donahue » Sat May 19, 2007 6:17 pm

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

Otherwise you would simply need to copy the package to the local computer.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests