Allocate memory error for SSIS connection

• Linda Robinson

  Mr or Mrs. 500

  Points: 541

  More actions

  October 12, 2011 at 8:08 am

  #249161

  Hi,

  We have a consultant working on setting up a process to transfer data from SQL Server to Oracle. When he tries to use a connection manager to Oracle in SSIS, he gets the error "Test connection failed because of error in initializing provider. ORA-01019; unable to allocate memory in the user side." The connection works fine for me.

  I'm assuming this is a permission issue, but I don't work to grant him admin rights on our server. Is there anything else I can do?

  Thanks.

• SpringTownDBA

  SSCertifiable

  Points: 6917

  More actions

  October 12, 2011 at 10:47 pm

  #1393787

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/56660bac-4e2e-4a93-b1ef-5bea9728d26d/

  have you tried running it in 32 bit mode on the server?

• Linda Robinson

  Mr or Mrs. 500

  Points: 541

  More actions

  October 13, 2011 at 6:38 am

  #1393969

  It's a 32-bit system.

  We're going to create a separate development server with just the database the consultant needs, so we can give him admin rights on that. That solves our problem, but I'm still curious if one needs to be in the server admin group to develop packages in SQL Server.

  Linda