Skip to Content

SAP B1 installation setup (SQL)

Hi Experts,

We have a client wherein they want to setup their installation in this way:

1. SQL server in 1 vlan

2. SAP components (SLD, License) in another vlan

3. SAP clients in another vlan

Now we already opened the SQL port to communicate between SQL and Application server and its okay. I can run SAP client in the App server. Now for the SAP client, we installed the fat client installation, but they don't want this client to communicate with the SQL directly due to security reasons, but should only be thru the Application server. Technically the client needs to communicate directly to SQL as its a fat client.

Is this setup technically possible without using RDP or other remote application?

Regards,

Marilyn

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 26 at 10:44 AM

    You mean client should not communicate with database server directly ?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Abdul,

      Yes, they're like thinking that the client should communicate to the Apps server and not with the SQL, to which I mentioned that B1 is not 3-tier but 2 tier only.

      Regards,

      Marilyn

  • Feb 27 at 07:31 AM

    Hi Marilyn,

    The B1 client, for the most part, merely calls stored procedures in the database. As such it cannot run stand alone in any way. It must connect to MS SQL Server.

    Generally the idea of an application server is specifically to provide all applications through the RDP role. For B1 this is actually a preferable scenario, as you only need one client installation, and it is much easier to allow access (through VPN) at home or other remote location.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded