Connecting to SAP server using sap client using SonicWall NetExtender SSL-VPN.

[former_member1169028]

Hi,

Our company is using SAP BUSINESS ONE and the thing is we have some users outside our local network which is also using SAP for their daily tasks. Currently, they are connecting to the SAP Server using RDP which is not really secure. So, we decided to install SAP Client to their PC or Laptop and use it to connect to the SAP Server over SonicWall SSL-VPN via Sonicwall NetExtender. After configuring the NetExtender to the client PC then we tried to login to SAP using the SAP Client 64bit and when we enter one of our users accounts an error show at the bottom of the screen and it says.

Connection to the database is lost; contact your system administrator(ODBC - 1102) [Message 131 - 183]

Please let me know if you found any solution to overcome this issue.

[AdKerremans]

are ports 1433, 30000, 30001 and 40000 open?

[former_member1169028]

When you say open ports are you referring to our sonicwall device?

As of now our sap clients are using these ports 40000, 30000, 30010.

[former_member1169028]

Do you mean open in the SonicWall firewall? as of now we are using Port 40000, 30000, 30010.

[davedai]

I'm 100% sure error 1102 means connection to database failed. So just check port 1433, and if you are using custom instance name, also check 1434.

The fact that you can see the list of databases means connection to SLD is successfully, so there's no need to check that part.

[former_member1169028]

Hi Dave,

Thank you for your response, I can actually see all the database on the company list but when I tried to login to a specific database then I'm getting that error. So, I tried to forward the port to our sonicwall tz300 device but nothing has changed, the error is still the same.

[davedai]

Please check SAP note 2641682.

This is basically NOT a SAP problem, because if you try to connect to your database with any other tool you will also fail. Just check the note and let me know if it helps.