Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2013-06-06 : 04:02:22
|
| Hi all,we have created ssis Packages to loading sap data in SSMS2012.this packges connecitons connected successfully on daily basis.yesterday we have changed connections from development server to Production server.(IP address,username,pwd is different to dev server)when i am creating connection to Development server using ssispckage i am getting the below error.pls guide on this urgent basis. TITLE: Connection Manager------------------------------Test connection failed because of an error in initializing provider. Details: ErrorCode=RFC_OK. ErrorGroup=RFC_ERROR_LOGON_FAILURE. SapErrorMessage=Incomplete logon data.. AdapterErrorMessage=.------------------------------BUTTONS:OK------------------------------ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-06 : 04:12:44
|
| It seems connection string value passed is incomplete or incorrect atleast for logon parameters------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-06-06 : 09:20:54
|
| Hi vashak,thanks for Reply.i have found in google we need to update the Z_EXTRACT_DATA_OO Custom rfc in the production server.do you have any exp with above RFC if yes pls explain the functionality of the same.Is there any Custom RFC's are there for Connecting the server.what are the Changes need to take when SAP sever is moving from development to Production server for Connecting Production server using SSMS. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-06 : 10:20:28
|
| Sorry i'm not familiar with SAP so cant suggest anything on this.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-06-07 : 02:55:34
|
| Hi All,Finally we connected Successfully.we need to Raise a Request based on the Z_EXTRACT_DATA_OO file(4 files 2 for select and 2 for execution purpose).Thx Team.mohan |
|
|
|
|
|
|
SAP Connection Issue