Unexpected result

aicorda · Post by **aicorda** » Wed May 11, 2011 4:01 am

I use a powershell script to retrieve information from a sql database.

When I run the powershell script local on the server, I get the good result.

When I use hostmonitor to execute my script on the server, I get an unexpected result (= not good).

How is it possible I get a different result?

KS-Soft Europe · Post by **KS-Soft Europe** » Wed May 11, 2011 5:25 am

What Windows do you use ?
Microsoft provides 2 different versions of PowerShell (32bit and 64bit versions) for x64 Windows OS.
So, you may manually run 64bit powershell console, while HostMonitor uses 32bit.

KS-Soft · Post by **KS-Soft** » Wed May 11, 2011 5:36 am

What exactly Windows and SQL client do you use?
64bit? 32bit? Version?

Regards
Alex

aicorda · Post by **aicorda** » Wed May 11, 2011 5:48 am

Windows Server 2003, 32bit
Microsoft SQL Server 2008, 32bit

KS-Soft · Post by **KS-Soft** » Wed May 11, 2011 6:04 am

H'm... may be some permission related issue?
Are you using the same user account when you starting script manually and when you starting HostMonitor itself?
HostMonitor is started as service? as application?
What exactly script do you use?

Regards
Alex

aicorda · Post by **aicorda** » Wed May 11, 2011 6:15 am

I use the same domain administrator account for running it local and for hostmonitor.

I use the rcc to start hostmonitor and run the rest.

It's a selfmade powershell script.

KS-Soft · Post by **KS-Soft** » Wed May 11, 2011 6:31 am

HostMonitor version?
HostMonitor is started as service? as application?
What exactly script do you use? Could you modify it so it will show you what exactly function/method/command fails?

I use the rcc to start hostmonitor and run the rest

Its impossible to start HostMonitor using RCC.
May be you start script different systems? E.g. HostMonitor is running on systemA while you start RCC and test your script on systemB?

Regards
Alex