Connect to SQL Server instance

Submitted by marcog_1361884 on Thu, 02/03/2022 - 19:12
1
0
-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

#database
4 answers

Submitted by walo2014 on Thu, 02/03/2022 - 19:40
1
+1
-1
This one is the BEST answer!

Hi.

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

Regards, Luis.

Submitted by Dibyajit.Roy on Fri, 06/10/2022 - 14:04
1
0
-1

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

Regards

Submitted by marcog_1361884 on Thu, 02/03/2022 - 20:02
1
0
-1

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

Submitted by marcog_1361884 on Thu, 02/03/2022 - 19:50
1
0
-1

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

Comments

Submitted by walo2014 on Thu, 02/03/2022 - 19:56

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

Permalink
Notifications