SAP B1 Datatransfer Workbench Error

[Former Member]

Hi, every one

My data transfer work bench is not connected to my server. And it showing error like this.Please help to sort out this problem.

[former_member459385]

Hi Dev Raj,

I think the reason you could not connect was because you had the license port number in the server address. The server address should be the name of your SQL instance that SAP is installed on.

Regards,

Ansel

[Former Member]

Hi Mr.Devaraj,

First, you should restart your license server and SLD in Services.

May be you can get it.

Otherwise,

http://scn.sap.com/people/lisa.mulchinock/blog/2009/07/06/how-to-solve-errors-you-get-when-connectin...

Please Check this link. I hope it will help.

Thanks & Regards,

P.T.Sampath

[Private_Member_778511]

Hello,

Can you check :

- name of server (Server name or IP)

- Version of SQL

Kind regards,

Mohamed

[Former Member]

Hi

DEV RAJ, I have the same error like you had then I got this. Have you fixed your

problem?

[former_member312729]

Hi,

When you try to connect DTW please check the server name and license server name are correct , then try to  enable Database Authentication and give the sql user id and password then click refresh button once database list out further provide database user id and password.

If further problem persist the try by re-installing the DI setup.again cross-check the Server name.

Regards:

Balaji.s

[Former Member]

After a while, now I got this.

I just want to add some records to the table. very simple. Please help

server name is MS

[former_member312729]

Hi,

First click the change server button and then select the server type and name also in option area give db user id and password , refresh it and  the database will list out , now select the database give the user id and password.

Regards:

Balaji.S

[Former Member]

Hi

Balaji.S,

Thank you for helping me on this.

I clicked on the server button and selected the server type & name with the user id & password. Refreshed it. However, I got this:

[Former Member]

There are company databases on the server.

[Former Member]

How do you re-install DI setup?

[Former Member]

Hi

Balaji.S,

I am using SAP Business One version 8.82. Below is screenshot of my DTW version.

[former_member505219]

Plz try these two tips as well.

Use DTW on server only

Use DTW in a different Windows Account

[former_member312729]

Hi,

First uninstall the dtw through microsoft add/remove program function and then clear the temp files. Restart the system and then try to install .

Run the setup.exe file.

1. In the welcome  window, choose the Next button.
2. In the Select Destination Folder window, specify the installation path and choose the Next button.
3. In the Select Program Folder window,  specify the program folder and  choose the Next button.
4. In the  Review Settings window, review the settings you have made.

• To continue, choose the Next button.
• The Data Transfer Workbench setup process begins.
• To change the settings, choose the Back button to return to the previous steps.

  5.When the setup process is completed, choose the Finish button. You have installed Data          Transfer Workbench.

6.To check the installation choose all program--> SAP B1-->data migration.

Regards:

Balaji.S

[Former Member]

Hi,

Please run as administrator...And give update here

Thanks and Regards

DEV

[julie_jamieson2]

On the machine you are running the DTW on, go to C:\Program Files (x86)\SAP\SAP Business One DI API\Conf and check the server name in the b1-local-machine.xml file is correct.

[kvbalakumar]

Hi,

Try re-installing the DI setup.

Cross-check the Server name again (as other experts suggested)

Regards,

Bala

[former_member325312]

Hi Rajesh

When you connect DTW  check Sql user id and Pswd and in the same way check the server name and check the Database userid and pswd . if is not connected connect to sql management studio and see whether you are able to connect or not

Regards

Jenny

[kothandaraman_nagarajan]

Hi,

Please refer below step for DTW connection with server.

Prerequisites

• 
  You have a local area network connection from your
  workstation to the SAP Business One server.
• 
  You are running the Data Transfer Workbench on a
  server/client platform that is supported by SAP.
  To ensure you are on a supported platform, check the
  SAP Business One Supported
  Platforms Overview at http://www.service.sap.com/~sapidb/011000358700001241092005.
• 
  Before using Data Transfer Workbench, make sure you
  have an SAP AddOns
  license.
  To set the SAP AddOns license, from the SAP Business One
  Main Menu, choose Administration License License Administration , and on the Allocation tab, select the checkbox for the SAP AddOns
  license.

Procedure

1. 
   Choose Start All Programs SAP Business One Data Migration Data Transfer Workbench .
2. 
   The Logon window appears.
   You can also open the Logon window by the following ways:
   
   • 
     Choose the Log On button.
   • 
     In the menu bar, choose File Log On .
3. 
   Specify the user code and the password of the SAP
   Business One company.
   
   Note
   The user code and the password are defined in the
   SAP Business One application to which you want to connect. The user code is
   recorded in the database as the originator. Activity is restricted according to
   the user privileges, as defined in SAP Business One. For example, if the user is
   not permitted to create A/R invoices, when the user tries to import A/R
   invoices, DTW blocks the import.
   
   End of the note.
   
   
4. 
   Specify the current SAP Business One server.
   
   
   1. 
      From the dropdown list, select the SQL server type,
      MSSQL_2005 or MSSQL_2008.
   2. 
      To switch to another SAP Business One server, choose
      the Change Server
      button.
      The SQL Server Login window appears.
   3. 
      In the Database Server field, specify the IP address
      or the machine name of your SAP Business One server.
      
      
      Note
      If you want to import the source data to your local
      machine, enter (LOCAL) or localhost.
      

      End of the note.
   4. 
      Specify the logon ID and the password to the
      database server, or select the User Trusted Connection checkbox.
   5. 
      Choose OK.

• 
  To get a list of the available companies, in the Logon window, choose the Refresh button.
  The application connects to the SAP Business One
  server and retrieves all available companies.
• 
  Select the desired SAP Business One company.
• 
  To log on to the company, choose the OK
  button.

Hope helpful

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Please check your Database services connected or not.

2. Check your Sap License server connected or not

3. if it is a client machine check the fire wall setting in server.

Regards,

Shanmugam V.