Skip to Content
0

SAP B1 installation setup (SQL)

Feb 26 at 10:35 AM

46

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abdul Mannan Feb 26 at 10:44 AM
0

You mean client should not communicate with database server directly ?

Show 1 Share
10 |10000 characters needed characters left 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

0
Johan Hakkesteegt Feb 27 at 07:31 AM
0

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

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Hi Johan,

Thanks for your reply. So this means that installing the fat client in another vlan without opening the ports to the SQL will not be technically possible, right?

Regards,

Marilyn

0

Hi Marilyn,

That is right.

Thinking out of the box, theoretically you could build your own B1 client that uses the DI Server (basically a web service using xml). However, such a client would have limited functionality, and the DI Server needs to connect to MS SQL Server.

Out of interest, how does the customer propose / expect to connect any application to MS SQL Server?

Regards,

Johan.

0

Hi Johan,

This client is a security provider vendor & very keen on their security of their infra. Their IT don't want to expose their SQL to the client layer due to security reasons. They expect that when B1 client is installed, it will connect only to the Apps server and not to the SQL server. I already informed them that this will not work unless you will connect using rdp only.

Regards,

Marilyn

0

Hi Marylin,

Ok, I see. Indeed B1 does not have a separate broker software between the clients and database, so an RDP scenario is the only option in this case.

Have they considered a hosted cloud solution? Though I don't know if a cloud host can provide sufficient (for this customer's taste) security assurances.

Regards,

Johan

0

Hi Johan,

They won't go for hosted cloud solution as they want to manage the infra themselves for security reasons.

Again, thanks for the inputs.

Cheers,

Marilyn

0