Impersonate user for SQL Server job
Posted on 2006-06-30
MS SQL Server is running on a machine that is not in the domain it has to communicate with.
I created a package in VBScript, and scheduled it. The package should go to a share on a machine in the domain, and pickup a file there. That gives a permissions problem, because "system" of the machine with the SQL Server has no permissions on the share (even not when "everyone" has modify permissions: because the machine is not in the domain, it isn't part of "everyone").
Is it possible (and if yes how) to pass login information to the job on SQL Server?