SAP BI Connector - MS Connector 1.0 Error

• BackT0Work

  Mr or Mrs. 500

  Points: 525

  More actions

  April 27, 2011 at 6:34 am

  #147939

  I am trying to connect to SAP BW and access a cube that they have created. SAP people have created RFC connection and have given me the details.

  I have installed Microsoft Connector 1.0 and Added SAPBI connection, SAP Source, SAP Destination to my DataFlow components.

  SAP Connection works fine. (Checked using Test connection Button)

  Then I dragged a SAP Source into a Data Flow Task, and gave all info required (OHS destination, Execution mode as Wait for Notify, Gateway host, Gatway service ,Program ID)

  1. When I do a Preview, it always gives me a time out error with following details.

  An internal exception occurred.

  Microsoft.SqlServer.Dts.SapBw.Connectivity.ERPException: The RFCServer object could not be registered. Check your network configuration.

  at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCServer.Accept()

  at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCServer.Run()

  2. When I just give OK (without preview) and connect the SAP source with DataReaderDestination, it gives the below error:

  [SAP BI Source [1]] Error: Microsoft.SqlServer.Dts.SapBw.Connectivity.ERPException: Value for ID 'PASSWD' not found

  at Microsoft.SqlServer.Dts.SapBw.Connectivity.R3Connection.Open(String ConnectionString)

  at Microsoft.SqlServer.Dts.SapBw.ConnectionManager.SapBwConnectionManager.AcquireConnection(Object txn)

  at Microsoft.SqlServer.Dts.Runtime.ManagedWrapper.AcquireConnection(Object txn)

  at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.AcquireConnection(Object txn)

  at Microsoft.SqlServer.Dts.SapBw.Components.SapBwPipelineComponent.AcquireConnections(Object transaction)

  at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)

  Does anybody have any ides on this? Pls help if possible.

  Thanks in advance.