SBM contains both a Windows component (IIS) and a Java component. IIS uses the ODBC Administrator for its database connection. SBM 11.x and Tomcat stores its database connection information in the following file.
ERROR [HY000] [ SBM ][ ODBC Oracle driver]The DataDirect product you are attempting to access has been provided to you by Serena Software, Inc. for the exclusive use with SBM . You are not licensed to use this product with any application other than SBM. If you would like to purchase this product, please ....
If your MS SQL Server is setup with the Force Encryption value set to yes then you will have to make the following changes for SBM to communicate with it. If your SQL server is setup this way then the Application Engine components will work fine because they connect via ODBC but the JBOSS components will fail to connect via JDBC and need the following changes made to the JDBC connection string in order to connect to the SQL Server database.
After upgrade to SBM 10.1 or later from a version prior to SBM 10.1 I cannot do the functions I used to be able to do in the ODBC System Administrator e.g. field overrides. In SBM 10.1 the legacy Web Admin has now been replaced by the Application Administrator and many of the System Administrator functions moved here also.
If your MS SQL Server is setup with the Force Encryption value set to yes then you will have to make the following changes for SBM to communicate with it. If your SQL server is setup this way then the Application Engine components will work fine because they connect via ODBC but the Tomcat components will fail to connect via JDBC and need the following changes made to the JDBC connection string in order to connect to the SQL Server database.
install, which installs every component on a single 64-bit server. You can still perform Remote Administration tasks or connect directly to the database via ODBC using 32-bit clients.
3. Open the OBDC Adminstrator 4. Edit your ODBC data source and go the the Advanced Security tab. Set your encryption level and data integrity level to '3 - Required' and set the required types. You have now set encryption and integrity for the Application Engine (user interface).
