I have the setup below a BI4_SERVER and SQL_SERVER (see image attached)
BI4_SERVER
SQL_SERVER
-CMS
-AUDIT
When installing BI 4 I want to understand something about ports and what checks need to be carried out prior to install.
The SQL Server is installed first with empty databases setup for Audit and CMS. I have then on BI4_SERVER setup ODBC connection to the databases so i can provide this information in the install.
As default BI 4 uses port 6400 to connect to the CMS (as I understand). In the example above - this would be SQL_SERVER 6400.
If I try to (prior to install of application BI_SERVER but after the empty database install) telnet to SQL_SERVER 6400. It gets refused. Do I need to setup anything for the database to listen to port 6400?
If I try to (prior to install of application BI_SERVER but after the empty database install) telnet to BI4_SERVER 6400. It gets refused. Do I need to setup anything for the database to listen to port 6400? The reason for this second question is because in the install logs when i try and install BI 4 i get the following error
#FWM 20030|Could not reach CMS ‘BI_SERVER:6400’. Specify the correct host and port and check for network issues. (FWM 20030)|Could not reach CMS ‘BI_SERVER:6400’. Specify the correct host and port and check for network issues. (FWM 20030)#
The last question I have is that does the BI 4 application just use port 6400 on the “BI4_SERVER” and then use the ODBC connection to connect to SQL_SERVER. In turn we dont actually use the port 6400 on the SQL_SERVER
Any assistance would be grateful to clear my understanding on this.
Leo,
The CMS Inbound port is 6400. This is the port that the CMS listens on for communication from other BI application services, or servers.
Your SQL server will listen for communications on the port designated on the SQL server (IF you are using Microsoft SQL Server, the default is 1433).
You will need to allow the SQL_SERVER in this example to listen on whatever its port is from the BI_SERVER. MSSQL by default does not allow external connections to the database, so that will need to be adjusted on the SQL_SERVER (If you use MSSQL).
The Business Objects Administrator and Installation guides (available on the support.sap.com site) would be a good place to start for ensuring you have a compatible and supportable configuration. The PAM is another source for information on what specific drivers to use for your ODBC connector to the CMS/Audit databases (but note, the PAM actually links to another file for the CMS/Audit database platform list, as well as the connector type)
I think it now makes sense. The BI4_SERVER uses port 6400 to connect to the CMS DB.
I understand SQL_SERVER uses port 1433 but if I am able to create the ODBC connection that means all is ok? I am unable to telnet to the port for some reason.
(BOB member since 2009-06-11)