Connect to SQL Server instance

Q&A
1

What is the best way to connect Bonita Engine Database and BDM to an instantiated SQL Server Database.

All attempts using "/", "\" failed.

Is there any documentation that I can follow guiding me to connect successfully?

Thanks

2

Hi.

I used this tutorial and works perfect: https://documentation.bonitasoft.com/bonita/2021.1/database-configuration

 

Regards, Luis.

3

Hi, thanks for answer.

I also used this documentation but the path was not successful.

I also used this documentation but the path was not successful.

the way to connect to the Database is:
instance intbfc\bonita_bdm

And in database.properties I change backslash to double-backslash and it doesn't connect either.

Regards, Marco

4

Hi,

I have to inform in the database.properties the path to the instance of the Database this way, otherwise it doesn't recognize the Database.

# if your database name contains a backslash (\) character, you must double it (\\):
db.database.name=intbfc\bonita_bdm or intbfc\\bonita_bdm
db.user=Beautiful
db.password=*************

But it doesn't connect to the Database. This is my problem.

If it doesn't point the instance it doesn't find the Database either.

regards

5

Can someone put all the steps together .
I am getting multiple errors. I am not sure where its going wrong.

Regards

6

This is my database.properties, may by the best way it's used a database user instead a windows user to connect to the database.

####################################################################################
#
# Modify the following values to suit your database needs.
# Fore more information, see file ../HOW_TO_CONFIGURE_AND_RUN.txt
#
####################################################################################


#########################################
# Bonita database properties
#########################################

# valid values are (h2, postgres, sqlserver, oracle, mysql)
db.vendor=sqlserver
# when using h2, no server or port setting is needed since connexion is made using file protocol mode using relative directory:
db.server.name=192.168.0.100
db.server.port=1433
# if your database name contains a backslash (\) character, you must double it (\\):
db.database.name=Bonita
db.user=Bonita
# if your database password contains a backslash (\) character, you must double it (\\):
db.password=************

###################################
# Business Data database properties
###################################
# valid values are (h2, postgres, sqlserver, oracle, mysql)
bdm.db.vendor=sqlserver
bdm.db.server.name=192.168.0.100
bdm.db.server.port=1433
bdm.db.database.name=BonitaBDM
bdm.db.user=Bonita
bdm.db.password=***************


# IMPORTANT NOTE regarding H2 database:
# in case you move whole setup folder to another directory, you must change property below
# to point to original folder containing h2 database folder
# new value can be relative or absolute since it still points to the right folder
# WARNING for Windows users: keep forward slashes like below (instead of backslashes):
h2.database.dir=../h2_database