Can B1if install on server other than DB server ?

[Former Member]

Hi experts,

The environment is 2 separate servers as following:

1.DB server: Windows server 2012+SQL server 2012, and all company databases( 7 DBs) reside in this server.

2.AP server: Windows server 2012+SAP B1 9.1 PL12 (include license server)

Now, I try to use integration solution. During B1if installation within AP server, I can NOT connect to DB server( AP server as default and gray out).

How can I solve this problem? Or  What structure should be changed ?

thanks for your assistances.

Helen

[Former Member]

Hi Helen

it´s recommended in the admin guide that the installation of B1if is NOT done on teh machine where B1 resides.

Bytheway - it´s a little difficult to assist. Can you provide screenshot(s) of your problem ?

Regards

Stefan

[Former Member]

Hi Stefan,

Thanks for your information.

I will try to follow the guide and will be back with the result. Hope it works.

Regards,

Helen

[Jerome3]

Hello Stefan, can you point to the webpage showing that recommendation ? Thanks,

[Former Member]

Hi ,

I have followed the admin guide of B1if , 

I check  B1DI and JDBC connection for all company DB of AP server and OK.

I check  B1DI and JDBC connection for all company DB of DB server and OK.

Afterward, I try to change B1if of DB server into B1if of AP server. That is one B1if  serves two server.

However, I can not get the desired result, the error message as :

Any idea?

thanks in advance,

Helen

[Former Member]

Above,

HOWONV2, bzEZERP_TDB are DB reside in AP server, ICS_B is DB reside in DB server.

I setup in event sender,  but I can NOT be successful for test connection either.

[Former Member]

Helen

as far as I know B1DI connection does not properly work before JDBC works. Thatswhy try to get JDBC working first.

For JDBC you have to set 4 settings :

driver  com.microsoft.sqlserver.jdbc.SQLServerDriver

url     jdbc:sqlserver://<IP-address>\SQLEXPRESS;integratedSecurity=false;databaseName=<database_name_in_SQL_server>;selectMethod=cursor;applicationName=IntegrServerSBO-COMMON

user I used sa

password pw of sa

This works at my installation. Maybe it helps.

Regards

Stefan

[Former Member]

Hi Stefan,

I do check the 4 settings for JDBC, but it still not work.

Before, I have install 4 company DBs,SAP B1 server, B1if, and intercompany in one server, it works but got very poor performance (same as installing more memory)

Therefore, I try to config 2 different servers: AP and DB. then I got errors as above and I really don't know what configuration I should take and will separating server solve the performance problem?

Any document I can refer to?

Regards,

Helen

[Former Member]

HI Helen

Performance problems: sure your servers are not swapping/do have enough memory?

Documents : hmm ... either the admin guide or the informations within this forum.

Are you sure there is no firewall active on one of your machines that is blocking the communication?

Regards

Stefan

[Former Member]

Stefan,

You are right, firewall block the operation.

Thank you.

Regards,

Helen