I get error when calling Powershell script from SQL Server job

-

i'm new in powershell. installed powershell 2.0. works
fine when ran interactively. when schedule dts sql sever job
fails following error:

executed user: mhpnt\mhpsqlservice. file j:\eventviewer\getsystemlog.ps1
cannot loaded because execution of scripts disabled on
system. please see "get-help about_signing" mor e details. @ line:1
char:2 + & <<<< 'j:\eventviewer\getsystemlog.ps1' + categoryinfo
: notspecified: (:) [], pssecurityexception + fullyqualifiederrorid :
runtimeexceptiondtsrun: loading... dtsrun: executing... dtsrun onstart:
dtsstep_dtsexecutesqltask_4 dtsrun onfinish: dtsstep_dtsexecutesqltask_4
dtsrun onstart: dtsstep_dtscreateprocesstask_1 dtsrun onerror:
dtsstep_dtscreateprocesstask_1, error = -2147220330 (80040496) error
string: createprocesstask 'dtstask_dtscreateprocesstask_1': process
returned code 1, not match specified successreturncode of 0.
error source: microsoft data transformation services (dts) package
file: sqldts80.hlp context: 4900 error detail records:
error: -2147220330 (80040496); provider error: 0 (0) error string:
createprocesstask 'dtstask_dtscreateprocesstask_1': process returned code
1, not match specified successreturncode of 0. error
source: microsoft data transformation services (dts) package file:
sqldts80.hlp context: 4900 dtsrun onfinish:
dtsstep_dtscreateprocesstask_1 dtsrun: package execution complete.
process exit code 1. step failed.

within dts, 1 of task "execute process task" executes:
powershell.exe -command "& { j:\eventviewer\getsystemlog.ps1}"

based on error, thought need add "set-executionpolicy
unrestricted" profile, added profile located
@ c:\windows\system32\windowspowershell\v1.0. didn't , still
error "....file j:\eventviewer\getsystemlog.ps1 cannot loaded
because execution of scripts disabled on system. please see
"get-help about_signing" mor e details." in job history.

checked execution policy using get-executionpolicy , returns
"unrestricted".

can me: why script fails when run sql server job ?

fyi, i'm running on windows server 2003 64-bit sp2 , sql server 2008
enterprise edition (64-bit) rtm.

in advance,
jimmy

i found out why failing:

when job running, runs in context of account starts sql server agent service. decided remote desktop server job located , run there -noexit check execution policy. when comes task runs powershell script, kicks off command-line window error mentioned. then, checked execution policy, "resctricted". so, while still in command-line window, changed  execution policy "remotesigned" , exit it. after change, re-ran job management studio pc (instead of remote desktop server) , ran successfully.




Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

Error: 0x80073701 when trying to add Print Services Role in Windows 2012 Standard

-
hello, i'm getting error when trying add print services role in windows 2012 standard. i'm getting same error whether use gui or powershell. this new server install. the powershell error follows: add-windowsfeature : request add or remove features on specified server failed. installation of 1 or more roles, role services, or features failed. the referenced assembly not found. error: 0x80073701 at line:1 char:1 + add-windowsfeature print-services + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : invalidoperation: (@{vhd=; credent...name=localhost}:psobject) [install-windowsfeature],     exception     + fullyqualifiederrorid : dismapi_error__failed_to_enable_updates,microsoft.windows.servermanager.commands.addwind    owsfeaturecommand success restart needed exit code      feature result ------- -------------- ---------      -------------- false   no             failed         {} issue appreciated. hi, i think should st
Read more

Disconnecting from a Windows Server 2012 R2 file sharing session on a Windows 7,8,10 machine

-
i've been trying disconnect server while , haven't been able to. there quick way this? i've used net session , net user , work sometime never consistent. can task? hi yrusad, thanks post. does work when check “computer management > system tools > shared folders > open files/sessions”. directly manage from gui. and based on knowledge, quick way mentioned net session /delete /y. mean never consistent? best regards, mary please remember mark replies answers if , unmark them if provide no help. if have feedback technet subscriber support, contact tnmff@microsoft.com . Windows Server  >  Windows Server 2012 General
Read more

Event ID 64,77,1008 Certificates Events Windows Server 2008, 2008R2

-
hi guys, i need event ids. event id 64 clear - expired certificate. problem computers have new certificate ca of them keep old one. can remove them certificate store on computers or should check before? event id 77 - 1 strange me. warning , in same time don't see suspicious: "windows default" policy module logged following warning: active directory connection <domain controller name> has been reestablished <domain controller name>. have 4 dcs. should check or ignore these messages. event id 1008 - "certificate services client: credential roaming not performed because number of tokens in local store has exceeded limit." - i've checked articles credential roaming i'm not sure should do. if give tips , answers, great. in advance. hi, event id 64 clear - expired certificate. problem computers have new certificate ca of them keep old one. can remove them certificate store on computers or should check before? i assume these
Read more