How to setup SQL EXPRESS database connection

This chapter will show you how you can connect to your own MSSQL Express or MSSQL Server through SQL EXPRESS connection. Via MSSQL it is possible to connect to different types of database servers. If the connection is successful, you can import contacts from your database to the Ozeki Bulk Messenger Software.

Step 1 - Create new database connection

The first step to create a connection between the Ozeki Gateway and the MSSQL software pack, is to Create a new Connection with the dedicated button on the upper side of the window. You can see where to click on Figure 1.

create new connection
Figure 1 - Create new connection

Step 2 - Type of database

Now you need to choose what is the connection method you wish to create. In this case you would want to connect to an app. To do that, click the Application button as you can see on Figure 2.

connection method
Figure 2 - Connection method

Now you need to choose the type of application you wish to connect to. MSSQL is a database management tool, so you need to choose the Database option. Click the dedicated button located on the right side of the screen. On Figure 3, you could see which button you need to click

Figure 3 - Application type

In this step, you need to choose what would you like to use the connection for. In this scenario, you want to use it for communication, so please choose the SQL messaging option. Click the button that you can see on Figure 4.

sql messaging
Figure 4 - SQL messaging

In this step, you need to choose which Database Management software you would like to connect to. In this case this software is the MS SQL Express.

sql messaging
Figure 5 - SQL messaging

Step 3 - Database connection details

There are two possible ways for giving the details: you can give the data below the General menu, or you can give the connection string below the Advanced menu. In case you give the connection string, it overwrites the data given below the General menu. In this example we give the connection string under the Advanced menu: Server=192.168.0.113\SQLEXPRESS; Database=ozeki; User Id=ozekiuser; Password=qwe123;

  • In connection string you have to give the availability of the server computer after the server. [IP address or hostname and the name of the ms sql server after \ (backslash)]
  • Database: give your database name
  • User Id: give your id
  • Password: give your own password

sql messaging
Figure 6 - SQL messaging

If the connection is successful, a green tick will appear under State. Click to the Open button to go to the details page of this connection

click to open
Figure 7 - Click to Open

You could use the event log to see every action that is happening on the connection. It means that in case of a successful connection, you will see the log registration for it, as you can see on Figure 8.

event log
Figure 8 - Event log

Step 4 - Testing the database connection

If you click to the Test button, you can give the database table in which you store your contact lists.
Click to the Execute button to list the phone numbers that are stored in the given database's table.

test the database
Figure 9 - Test the database

More information