hi,
I created a .NET dll and registered in the component services (regsvcs)
to receive calls from my database via sp_OAMethod.
When I run in my local machine, via query analyzer SQL 2000, it works
just fine. but in our test server I get the message: (see below the
command and the error message )
EXEC @retVal = sp_OAMethod @comHandle, @command, @helloString
error: -2147467238 : ODSOLE Extended Procedure :
The server process could not be started because the configured
identity is incorrect. Check the username and password.
The user logged in the windows server 2000 is the administrator, and the
user logged in the query analyzer is SA.
any hints? should I give any special permission to any user?
TIA
-Edge
Edge - 05 Aug 2005 02:48 GMT
I found a solution for this anyway.
I am setting an user for the COM application manually. I opened the
component services and right-click the COM aplication. Then I set the
application to run logged as user administrator, then I specified also
the password for it.
I do not know yet if this is the best solution, but I got it working so
far.
-Edge
> hi,
>
[quoted text clipped - 18 lines]
> TIA
> -Edge