Access denied when running sp_OACreate from sp

Hi,
I have a BIG problem, I'm trying to run sp_OACreate from a sp and keep
getting "Access Denied", this works just fine on my dev.machine but on
the production server it doesn't work at all. I've read all the papers
I can get my hands on and have gone through all the permissions but
still missing something, anyone who could give me a step by step
instruction how to get this to work.
/MagnusHi
This looks like a permissions issue, you don't say what/how this is being
run or exacly what error number/message you are getting. Does the account yo
u
are running under have the correct access permissions? Also check that the
COM object is installed and registered correctly.
Also check the Event log and SQL Server error logs to see if there is
information in there that may help.
John
"Magnus Nordin" wrote:

> Hi,
> I have a BIG problem, I'm trying to run sp_OACreate from a sp and keep
> getting "Access Denied", this works just fine on my dev.machine but on
> the production server it doesn't work at all. I've read all the papers
> I can get my hands on and have gone through all the permissions but
> still missing something, anyone who could give me a step by step
> instruction how to get this to work.
> /Magnus
>|||Hi John.
I'm trying to run a VB COM and it's registered with DCOMCNFG and all
the permissions is checked even on files and registry. It's going to be
used from a hand computer since they can run sp's directly to update an
application.
/Magnus
John Bell wrote:
> Hi
> This looks like a permissions issue, you don't say what/how this is
> being run or exacly what error number/message you are getting. Does
> the account you are running under have the correct access
> permissions? Also check that the COM object is installed and
> registered correctly.
> Also check the Event log and SQL Server error logs to see if there is
> information in there that may help.
> John
> "Magnus Nordin" wrote:
>|||Hi Again.
Error message from sp:
-2147024891, Access is denied., ODSOLE Extended Procedure
/Magnus
Magnus Nordin wrote:
> Hi John.
> I'm trying to run a VB COM and it's registered with DCOMCNFG and all
> the permissions is checked even on files and registry. It's going to
> be used from a hand computer since they can run sp's directly to
> update an application.
> /Magnus
>
> John Bell wrote:
>