Products
Ozeki 10
SMS
Ozeki NG SMS Gateway
SMS Gateway
Quick Start Guide
SMS with Client Software
HTTP API
SMS from/to Database
PHP SMS API
Solutions
C# SMS API
VB.NET SMS API
SQL Logging
System Database
MySQL
Oracle
MSSQL 2008
MSSQL 2012/2014
Import messages
Switch from file
SMPP
Message Server 6
SMS Wall
IP SMS Gateway
Android SMS
Excel SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Technology
Company


Ozeki 10 SMS Gateway
MSSQL 2008 MSSQL 2008 | Import messages Import messages

MSSQL 2012/2014 configuration

You can make SMS Gateway faster by storing your messages in your MSSQL database instead of storing them in files on your computer. As a default Ozeki SMS Gateway saves SMS messages in files, but you can change this option by connecting Ozeki 10 to your MSSQL database. Speed up message sending by following this small tutorial.

Keep in mind!!!

If you receive an error message telling that your SMS messages cannot be found, there is no problem. Probaby the messages are still in the files, although the system searches them in the database. If you are uncertain how to import messages from your files, you can look back and see how to switch from file to database. It is a short site to scroll through. The diagrams will help you understand. You can check out this detailed explanation as well.

Configuration steps

STEP 1: Create MSSQL database
STEP 2: Create MSSQL database user
STEP 3: Add MSSQL system database to Ozeki 10

Before continueing please make sure that Ozeki SMS Gateway and MSSQL 2012/2014 is already installed on your company's server. Start SQL server Management Studio and login with administrator privilages (Figure 1). It is important to remember the administrator password provided at the MSSQL installation process.

Step 1: Create MSSQL database


Figure 1 - Login to MSSQL

Open the Database menu, click the right mouse button and select 'New Database...'. It is recommended to create an individual database for Ozeki SMS Gateway (Figure 2). This will avoid confusions.


Figure 2 - Click 'New Database...' after opening the menubar

It is time to provide a name to your database and click 'Ok' (Figure 3). You will connect this database to Ozeki 10, so it will store incoming and outgoing messages in your database instead of storing them in files.


Figure 3 - Name your database

Look at Figure 4.

Under 'Databases' menu you can see all of the created databases.


Figure 4 - The database for Ozeki 10 have been created

Step 2: Create MSSQL database user

Now expand 'Security' and make a right click on 'Logins' and select 'New login...' (Figure 5).


Figure 5 - Create 'New login...'

When creating a login, please specify the following parameters (Figure 6):

  1. Specify 'Login name': The name of the database user (e.g. 'ozeki')
  2. Check 'SQL Server authentication' checkbox and set Password.
  3. Un-check 'User must change password at next login'
  4. Select the 'Default database' for the user (e.g. 'ozeki_sys').


Figure 6 - Specify SQL server details

Stay in the window after adding the user parameters. Now it is time to configure 'User mapping' (Figure 7).


Figure 7 - Click 'User mapping'

Enable the created database by ticking the checkbox then click '...' on the end of the row (Figure 8).


Figure 8 - Map the user to your database

A new window will appear. Select 'Schema' and click on 'Browse' (Figure 9)


Figure 9 - Browse database schemas

Please select the [dbo] schema, which is needed in this case and click 'OK' (Figure 10).


Figure 10 - Select [dbo] schema

You will find yourself on the previous window with the [dbo] schema added. Click 'OK' (Figure 11).


Figure 11 - You can see the selected schema listed

Please look at the 'Database role membership' checkboxes (Figure 12) and select the following roles:

  • db_ddladmin
  • db_owner
  • Public (selected by default)
Now you can click the 'OK' button to create the user.


Figure 12 - Specify the membership roles for the user

After making the correct setting you will see the created user under the 'Logins' menu item (Figure 13). In this example the created user is called 'ozeki', although you can create any other user with it's own SQL authentication password (Figure 6).


Figure 13 - The list of available user logins

Step 3: Add MSSQL system database to Ozeki 10

Start Ozeki 10 and login with your username and password (Figure 14).


Figure 14 - Log into Ozeki 10

Select 'Edit' from the top menu and click 'Server preferences' as seen on Figure 15.


Figure 15 - Modify 'Server preferences'

Select 'Databases' tabpage and under it please select 'System database settings' tabpage (Figure 16). Check the tick left to 'Use a database server instead of file system to store messages ' and choose 'OleDb' database connection type.

Now it is time to specify the connection string:

Connection string type:OleDb
Connection string:Provider=SQLOLEDB.1;Data Source=YourComputerName;Persist Security Info=False;
Integrated Security=SSPI;User ID=YourUserName;
Password=YourUserPassword;Initial Catalog=YourDatabaseName
Code 1 - Connection strings for MSSQL. Please copy-paste and customize it

Please modify the following parameters:

YourComputerName= The IP address and port number of your MSSQL server
(The value is 'local' if the SMS Gateway and the database server is on the same machine)
YourUserName= username for the database
YourUserPassword= password belonging to the database username
YourDatabaseName= the name of the database that was created in this tutorial (e.g. 'ozeki_sys')

Finally, click 'OK'.


Figure 16 - Modify system database settings

Now you can click 'View' on the top menu and select 'System DB events' menu item (Figure 17).


Figure 17 - Check system database events

Search the following event in the event list:
'Database connection successful' (Figure 18)


Figure 18 - In the event list you should see the 'Database connection successful' sign

Now it is time to insert an outgoing message into the database. You will find the message in the 'Sent' message box (Figure 19).


Figure 19 - The test message should be in the 'Sent' folder

You can find the test message in the database table of the given user (Figure 20).


Figure 20 - Find the messages in the database table as well


Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Products > SMS > SMS Gateway > System Database > MSSQL 2012/2014
Legal | Privacy policy | Terms of use
Page: 5796 | Login | 3.214.184.250