ms sql powershell

Question

I want to execute a powershell script within microsoft management studio. But I get an error. Look below for more details:

EXEC master..xp_cmdshell '%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy unrestricted -command "C:\tmp_es\test.ps1"'

C:\tmp_es\test.ps1 : The term 'C:\tmp_es\test.ps1' is not recognized as the 
name of a cmdlet, function, script file, or operable program. Check the 
spelling of the name, or if a path was included, verify that the path is 
correct and try again.

It's probably because the SQL process doesn't have access to C:\tmp_es Try changing the permission on tmp_es to read all users. — Conrad Frix
– Conrad Frix, Commented Jun 20, 2016 at 12:14
I think you are right. But now I must know what the name is of the sql management studio server. Do you maybe know? — Ezra P.
– Ezra P., Commented Jun 20, 2016 at 12:21
Are you running Sql Server on the same machine as Management Studio, or on a remote server? — vonPryz
– vonPryz, Commented Jun 20, 2016 at 12:31
It was indeed the wrong path. Now I've inserted the good path and it is working now. Thanks — Ezra P.
– Ezra P., Commented Jun 20, 2016 at 13:34

Avshalom · Accepted Answer · 2016-06-20 12:18:06Z

1

Change the -Command to -File

EXEC master..xp_cmdshell '%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy unrestricted -File "C:\tmp_es\test.ps1"'

answered Jun 20, 2016 at 12:18

Avshalom

8,9471 gold badge29 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ezra P. Over a year ago

this doesn't work. I think indeed it has no permission to that folder sql management studio.

Collectives™ on Stack Overflow

ms sql powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related