Post reply

After changing SQL Server account, access denied on SP_OACREATE

  • November 5, 2008 at 11:52 am

    #201149

    This is SQL Server 7.0.

    I changed the SQL Server service account and the SQL Server agent account from the local system account to a domain service account.

    After changing the account, the user database uses the SP_OACreate, SP_OAdestroy extended stored procedures and this started reporting Access Denied (when the user stored procedure was even run by a system admin). I checked registry keys for the ActiveX object and it looks like my account has permission. I also added the domain service account as a local admin and still had the same issue.

    Any ideas?

  • November 5, 2008 at 2:00 pm

    #894519

    Have you checked the permissions of SQL Agent?

  • November 6, 2008 at 7:29 am

    #894851

    I was using the same account for the SQL Server Agent and the SQL Server services. I granted them Local Admin privileges and this did not resolve the issue.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply