Post reply

DTS - sp_OAGetErrorInfo failed

  • March 23, 2004 at 8:38 am

    #359310

    I see online (http://www.msluder.dk/Resources/TSQL-Doc/ts_sp_oa-oz_3enj.htm) that "Only members of the sysadmin fixed server role can execute sp_OAGetErrorInfo."  I created a user on the master db to do this, and granted them execute permission to the sp_OA* stored procedures, but am still getting this error in Query Analyzer:
     
    ***  LoadFromSQLServer failed

    OLE Automation Error Information

      HRESULT: 0x80040e14

      sp_OAGetErrorInfo failed.

     
    I'm running SQL Server 2000, and trying to create an Excel file using a DTS package. 
     
    Any suggestions???

  • March 26, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 26, 2004 at 9:48 am

    #500689

    Did you give them the sysadmin fixed role? If not, the calls that the stored procedure makes will fail.

  • March 29, 2004 at 6:31 am

    #500851

    Steve,

    Thank you for replying.  I added my login to the sysadmin list and this still didn't solve the problem.  I also added that login dbowner permissions on the master db and am still getting the same OLE error. 

    ***  LoadFromSQLServer failed

    OLE Automation Error Information

      HRESULT: 0x80040e14

      sp_OAGetErrorInfo failed. 

    I would like to avoid adding this user to the sysadmin role, but if this is necessary, that's fine.  I just don't understand why this returns an internal stored procedure failure when this login is owner on the specific database, as well as the master database.  In addition to that, the user's login is in the sysadmin fixed role.

    Thanks again,

    Brett

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

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