Welcome page
Ozeki 10
Ozeki NG SMS Gateway
Message Server 6
On-line manual
SMS technology
MMS technology
Product features
Installation guide
Installation steps
Product Activation
Server Preferences
Colour SMS
Database (SQL)
ODBC configuration
Service account
Backward compatibility
MyODBC driver
HTTP Client
POP3/SMTP connection
User accounts
Server port
System maintenance
User guide
Developers guide
Case studies
How to buy
SMS Wall
IP SMS Gateway
Android SMS
Excel SMS
Bulk Messenger
Developer tools

On-line manual:
  Explore all the features in this On-line HTML documentation of Ozeki Message Server 6.

Product guide:
  Download Ozeki Message Server 6 Manual in PDF format. This PDF guide explains all the features of Ozeki Message Server 6.
Ozeki Message Server 6
Service account Service account | Backward compatibility Backward compatibility


Under construction!!! check

If you use the Ozeki Message Server,   you can send and receive SMS messages using a database server with the help of SQL queries. In order to use this option, you need to have a database server MS SQL installed, and there should be two database tables created: ozekimessageout and ozekimessagein. One of these will be used for sending and the other for receiving SMS messages.

Reqire to install the MS SQL database server software.

Step 1: Configure the MS-SQL database

Summary: 1. start the service, 2. start a SQL Querry, 3. create DB, 4 Check  the DB exist

If the MS-SQL service did not start automatically, you set up   the Service Manager and click on   the Service Manager  (Figure ). Click on  , and find the Microsoft SQL Server menuitem, and click on Service Manager. After a window opens up: SQL Server Manager. It can be found at t he bottom of the window (Figure 1).

Figure 1 - SQL Server Service Manager


Start  the Query Analiser, Select on  / Programs / Microsoft SQL Server / and click on Query Analiser. After this a   window opens (Figure 2).

Figure 2 - Query Analiser

Click on the File menu, select Connect menu item. In the dropdown of the SQL Server  menu, select the SQL server IP address.  T ype the local IP address, because the SQL Server and the Ozeki Message Server are on the same computer. Place a checkmark into the " Start SQL Server, if it stopped" checkbox. Select the Use Windows NT authentication radio button. Click OK (Figure 3).

Figure 3 - Connection to SQL server

The following window opens SQL Server Query Analyser. In the DB dropdown menu database can be selected. Default is master (Figure 4).

Figure 4 - SQL Server Query Analyzer

The next form shows , how to create SQL database for Ozeki Message Server. It can be done easy. Just Copy-Paste the script into the Querry Analyser.

The SQL Script (case sensitive):

CREATE TABLE ozekimessageout (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg varchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(100),
 msgtype varchar(30),
 reference varchar(30),
 status varchar(30),

CREATE TABLE ozekimessagein (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg varchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(30),
 msgtype varchar(30),
 reference varchar(30),

When the script is placed to the Query Analyzer, c lick on parse icon . It checks the SQL script errors. If there were no errors  found, you will show The command(s) completed successfully. Click on execute icon . SQL Query return The command(s)  completed successfully. (Figure 5  ) The SQL databese was created!

Figure 5 - Running of the commands

To understand what's happened:  

(The  "SELECT * FROM ozekimessageout" list the columns of the ozekimessageout table.)

 Before the SQL script was ran:  (Figure 6 )

SQL Querry return an error, because the databases are empty. 

Figure 6 - Running SQL script

After the script was ran correctly, it means, that   DB and tables were created successfully:

The arrows show the created colums (id, sender,...) (Figure 7 ).

Figure 7 - Creating columns

You have a created MS-SQL DataBase !

Step 2 : Configure Ozeki Message Server

Go to the Plugins menu and select Installed Plugins menu item (Figure 8 ).


Figure 8 - Installing plugins

Click on Install, which is next to Database Plugin (Figure 9).

Figure 9 - Installing the database plugin

When the Plugin installed, click on Configure (Figure 10 ).

Figure 10 - Configuration

Place a check mark into the checkbox of Use Database for receiving SMS message . (2) It means, that the incoming SMS stored in the Database. Place a checkmark into the checkbox of Use Database for receiving SMS message (3). Place a checkmark into checkbox of Autoconnect on startup . When the Ozeki Message Server starts, then  the database connection will be established. Click on Build database connection (1). (Figure 11 ).

Figure 11 - Connection information tab


Select the Use Connection String radio button. Click on Build. (Figure 12 ).

Figure 12 - Connection string


Data Link Properities screen opens up. In t he OLE DB providers list box, you have to  select the Microsoft OLE DB Provider for SQL server. Click on Next. (Figure 13 ).

Figure 13 - Pointing out the data in the Data Link Properties tab

Click on the Connection tab. In the Select or enter a server name combo box, you have to  write the MS-SQL server IP address. (1) The MS-SQL server and the Ozeki Message Server are running on the same computer, so the IP address is . Select " Use a specific user name and password" radio button and write sa the input field. (2) 'Sa' is the default. Place a checkmark  into the checkbox of Blank password . Choose Select the database on the server radio button and select master item in the combo box (3) (Figure 14).

Figure 14 - Configuration in the Provider tab

Message Server was configured successfully : Click on Connect (1) and Refresh this page (2) (Figure 15).

Figure 15 - Configuration

As a last step,  configure the Ozeki Message Server with MS-SQL database!


Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Products > SMS > Message Server 6 > On-line manual > Installation guide > Server > Plugins > Database (SQL) > Microsoft-SQL
Legal | Privacy policy | Terms of use
Page: 576 | Login |