Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozeki.hu
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

MSSQL 2008 Contents | SearchMySQL configuration

Home > Product Manual > Installation Guide > Installation Steps > System database > MSSQL 2012/2014

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  Prerequisites
  Download Information
  Installation Steps
  System database
  Oracle configuration
  MSSQL 2008
  MSSQL 2012/2014
  MySQL configuration
  Import messages
  Switch from file
  HTTPS
  Firewall on Windows 7
  Firewall on Windows 8
  Firewall on Windows 10
  Service Provider Connections
  Users and applications
  Linux
  User Guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

System database

In case you need to store great numbers of SMS text messages it is possible that your system will be slowed down by this amount of stored files. By default, Ozeki NG SMS Gateway stores messages in files. In this way, it is highly recommended to use the System Database option in Ozeki NG SMS Gateway. This option allows you to speed up message sending. On this webpage you find a detailed configuration guide for using System Database in MSSQL 2012/2014.

Please note!!! >
When you switch to System Database, you can receive an error message since the system cannot find messages.
The reason for this: the system searches for messages still in the file but system database stores them in a database. To avoid this error message please read How to import messages to System Database and How to switch from file to database sections.

Configuration steps

In the follows you can find detailed configuration steps on how you can configure System Database option in Ozeki NG SMS Gateway software. In this example, MSSQL 2012/2014 is used. Please follow the steps below to make your settings effectively.

It is assumed that you have already downloaded, installed and configured Ozeki NG SMS Gateway and MSSQL 2012/2014.

First of all, start SQL server Management Studio (Start menu \ All programs \ Microsoft SQL Server 2012/2014 \ SQL Server Management Studio).

Login as administrator (admin user has been created during the installation of MSSQL Server 2012/2014) (Figure 1).


Figure 1 - Login

Expand Databases menu. Then right click on Databases and click on New Database. In this way, you can create the database that will include the system database of Ozeki NG SMS Gateway. It is recommended to create a new database to avoid confusion (Figure 2).


Figure 2 - Create new database

On New Database form specify Database name (in this example, we use ozeki_sys) and click on OK (Figure 3).


Figure 3 - Database name

Under Databases menu item you can see the created database (Figure 4).


Figure 4 - Created database

Now expand Security menu item. Then right click on Logins and select New login (Figure 5).


Figure 5 - New login

On the appeared form please specify the follows (Figure 6):

  1. Specify Login name: it is the user name (in this example: "ozeki")
  2. Enable SQL Server authentication checkbox and specify the Password.
  3. Disable User must change password at next login checkbox.
  4. Specify Default database (in this example: "ozeki_sys").


Figure 6 - Specify details

After you have specified the details on New login form, click on User mapping still on the same form (Figure 7).


Figure 7 - User mapping

Enable the checkbox of the created database (in this example it is "ozeki_sys") and click on ... button at the end of the row (Figure 8).


Figure 8 - Enable the database

On the appeared Select Schema form click on Browse to be able to select the schema you wish to use for the user (Figure 9).


Figure 9 - Browse

Select the schema you wish to use (in this case dbo schema is needed) and click on OK (Figure 10).


Figure 10 - Select the schema

On Figure 11 you can see the selected schema is listed. Click on OK again.


Figure 11 - Selected schema is listed

You also need to specify Database role membership for the created database (Figure 12). You can do so by selecting the wished items at the bottom of New login form. Please select:
db_ddladmin
db_owner
Public is selected by default. Please leave it selected.

Finally, click on OK to create the user.


Figure 12 - Database role membership

If you made settings correctly, you can see the created user under Logins menu item (Figure 13). In this example it is "ozeki".


Figure 13 - Created user

Now start Ozeki NG SMS Gateway and login with your username and password (Figure 14).


Figure 14 - Log into Ozeki NG SMS Gateway

Go to Edit menu and select Server preferences menu item (Figure 15).


Figure 15 - Server preferences

Select Databases tab and click on System database settings tab (Figure 16). Here, enable Use a database server instead of file system to store messages. Database connection type needs to be OleDb.

Then specify the Database connection string as follows:

Provider=SQLOLEDB.1;Data Source=YourComputerName;Persist Security Info=False;Integrated Security=SSPI;User ID=YourUserName;Password=YourUserPassword;Initial Catalog=YourDatabaseName

Please customize the Database connection string according to the follows:

YourComputerName= the IP address or domain name of the computer on which the database server has been installed. If the Ozeki NG SMS Gateway and the database server are on the same computer, this value is (local).
YourUserName= username for the database.
YourUserPassword= password belongs to the username.
YourDatabaseName= the catalog or database that you have created for storing the system database. (In this example, it is "ozeki_sys")

Finally, click on OK.


Figure 16 - System database settings

Now restart the Ozeki NG service by right clicking on the Ozeki icon on the tray and select Restart service option (Figure 17).


Figure 17 - Restart service

After restart, go to View menu and select System DB events menu item (Figure 18).


Figure 18 - System DB events

If the configuration was correct then you can see the following server event: "Database connection successful" (Figure 19).


Figure 19 - Database connection successful

If you send a test message it needs to be appeared in the Sent box in Ozeki NG SMS Gateway as Figure 20 demonstrates.


Figure 20 - Sent test message

As a consequence of the test message it can be seen that the database tables containing the messages have been created in the database successfully for the given user (Figure 21).


Figure 21 - Database tables have been created successfully

Dig deeper!
People who read this also read...


System database
Import messages to system database
Switch from File to Database





Next page: MySQL configuration
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Installation Guide > Installation Steps > System database > MSSQL 2012/2014
Legal | Privacy policy | Terms of use
Page: 2895 | Login | 34.204.173.36