Having issue with non "sa" user saving tracking numbers

(0) Share

Report

Posted on by Jay Kimelman

Received the following error:

[Microsoft][SQL Native Client][SQL Server]EXECUTE permission denied on object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.

I added cmdshell proxy and execute permissions for GP user.

Then recevied :

[Microsoft][SQL Native Client][SQL Server]EXECUTE permission denied on object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.

added execute permissions for gp user and then got same error message for sp_OAsetproperty and sp_OAmethod. created execute permissions for each and then logged in. After this, I was allowed to close the page without error, but the tracking numbers were not saved.

GP 10 with SQL 2005

Has anyone experianced this issue and if so, any solution?

thank you

*This post is locked for comments

I have the same question (0)