Forum Discussion
ERROR:Powershell script from SQL management studio
However, when I run the same script using the SQL management studio as shown above, its not able to start F5 client.
I wonder what you expect here?
The PowerShell script gets executed on the machine where SQL Server is running and this under the SQL Server service account, which has not profile.
That will never work.
Use PowerShell Remoting instead, but if that client has a GUI, it won't work, too.
olafhelper Thank you for your response.
We want to pull data from different external agencies (about 10+) and each of them have their own VPN credentials. So instead of setting up different VM for each agency we are thinking of have one VPN client on a server and dynamically start (with credentials) and stop the F5 using the PowerShell Script. - this is what we are trying to do.
In your response you mentioned the "no profile" - it we setup a profile, will it work? also how to set the profile. Please share some knowledge on that.
thank you!
we setup a profile, will it work? also how to set the profile.
mstechmach , I wouldn't bet on. Why do you want to find a solution using database engine? I would use a SSIS package or a remote PowerShell solution.
- Thank you! I will try it out.
